Robert Half Corporation Jobs

Job Information

Robert Half Business Intelligence (BI) Analyst in EAST GRANBY, Connecticut

Description The Business Intelligence Analyst is expected to create process improvement in all departments in conjunction with the

responsible department individuals through the creation of meaningful and actionable visualizations using Microsoft’s

suite of BI and database tools. As a member of a small team, this individual will be a critical technical resource

supporting all levels and departments within the company

Duties and Responsibilities:

• Providing assistance for Power BI, including training, problem-solving, and clarifying data within reports.

• Importing data into the database from user-submitted files.

• Creating queries for generating reports or extracting data to Excel files.

• Addressing data irregularities in the SQL database, such as incorrect Customer ID assignments, to ensure data


• Import data into tables within the production database for Technician Hours and HR Training.

• Update the new shipment forecast dates by uploading data to the BOLT environment.

• Grant new users access to the reporting server.

• Hold meetings with the CFO and IT team to provide project updates and status reports.

• Refresh all web-based Power BI files, comprising 20 reports.

• Schedule meetings with users to discuss and gather requirements for new Power BI report requests.

• Manage Reports (approximately 60 Power BI reports published to the shared drive) by regularly refreshing them,

updating queries, and maintaining connections.

• Update and maintain SSRS Reports

Current Projects:

• Automate the tracking of Top Level Key Performance Indicators (KPIs) currently managed in an Excel


• Develop a web-based maintenance interface that connects to SQL databases.

• Work on updating and integrating the new fiscal year into existing reports and future reporting.

• Incorporate new fields requested by users into existing reports to streamline their manual processes.

• Maintain and enhance the Sales Dashboard for the Leadership team.

• Automate manual processes for the Sales, Finance, HR, and Service teams.

• Enhance the GP system by integrating fields created with an extension (Extender) to enable more detailed

reporting that are not readily available in the system

Skills and Requirements:

• 3-5 years of experience in a similar capacity

• Proficiency with writing T-SQL and familiarity with SQL databases

Understanding of database relationships and table structures

• Experience with Power BI, DAX, and Power Query Editor

• Experience with SSRS (SQL Server Reporting Services)

• Experience with Excel

• Experience with uploading data into SQL tables

• Understanding and monitoring of SQL database replicatioon

• Experience with CRM and customized software programs on CRM (i.e. BOLT)

• Experience with Great Plains or a general understanding of financial reporting Requirements Business Intelligence (BI), Business Intelligence and Reporting Tools (BIRT), Business Intelligence Technologies, Microsoft Business Intelligence, Microsoft Power BI, Power BI, T-SQL - Transact-SQL, Financial Reporting, Microsoft Excel, Create Ssrs Reports, Microsoft SSRS, SSRS, Great Plains (GPAC), SQL Database, Dax Technologies, Power Query, SSRS - SQL Server Reporting Services, CRM Technology Doesn't Change the World, People Do.®

Robert Half is the world’s first and largest specialized talent solutions firm that connects highly qualified job seekers to opportunities at great companies. We offer contract, temporary and permanent placement solutions for finance and accounting, technology, marketing and creative, legal, and administrative and customer support roles.

Robert Half puts you in the best position to succeed by advocating on your behalf and promoting you to employers. We provide access to top jobs, competitive compensation and benefits, and free online training. Stay on top of every opportunity – even on the go. Download the Robert Half app ( and get 1-tap apply, instant notifications for AI-matched jobs, and more.

All applicants applying for U.S. job openings must be legally authorized to work in the United States. Benefits are available to contract/temporary professionals, including medical, vision, dental, and life and disability insurance. Hired contract/temporary professionals are also eligible to enroll in our company 401(k) plan. Visit for more information.

© 2023 Robert Half. An Equal Opportunity Employer. M/F/Disability/Veterans. By clicking “Apply Now,” you’re agreeing to Robert Half’s Terms of Use ( .