Operations BI Analyst
Role details
Job location
Tech stack
Job description
Operations Construction Supply Chain Data Quality Communication Data Analysis Microsoft Azure Data Validation Health Advocacy Data Warehousing Stored Procedure Microsoft Fabric Relational Databases Business Intelligence Artificial Intelligence Discounts And Allowances Manufacturing Operations Microsoft Power Automate SQL (Programming Language) Critical Illness Insurance Employee Assistance Programs Troubleshooting (Problem Solving), The Operations BI Analyst will support the company's data analytics and reporting platform, helping deliver reliable insights for manufacturing, operations, and supply chain teams. This role will work with a Microsoft Fabric-based data warehouse and contribute to Power BI and Excel reporting used across the organization. This is a junior-level role ideal for someone with a strong SQL foundation, an interest in analytics and manufacturing data, and a desire to grow their skills in data warehousing, reporting, and business intelligence tools., * Support the maintenance and enhancement of a cloud-based data warehouse in Microsoft Fabric
- Assist in developing and maintaining SQL queries, views, stored procedures, and data pipelines
- Create and update Power BI reports and dashboards to support operational and business needs
- Help maintain existing reports while contributing to the development of new analytics solutions
- Work with internal teams to understand reporting requirements and translate them into dashboards and data models
- Support reporting related to manufacturing and operations, including production, quality, shipments, backlog, and delivery performance
- Assist with data validation, troubleshooting, and resolving data quality or refresh issues
- Provide limited support for Power Apps and Power Automate solutions as needed (training and guidance provided)
- Document reporting logic, data definitions, and processes to support knowledge sharing and consistency, Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.
Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.
Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools. Related Jobs Operations BI Analyst Aerotek Bethel, CT*On-Site Power BI Dashboard Operations Construction Supply Chain Data Quality Communication Data Analysis Microsoft Azure Data Validation Health Advocacy Data Warehousing Stored Procedure Microsoft Fabric Relational Databases Business Intelligence Artificial Intelligence Discounts And Allowances Manufacturing Operations Microsoft Power Automate SQL (Programming Language) Critical Illness Insurance Employee Assistance Programs Troubleshooting (Problem Solving)
Requirements
- Strong working knowledge of SQL, including writing and understanding complex queries
- Experience or coursework involving data analysis, reporting, or business intelligence tools
- Familiarity with Power BI or similar reporting tools
- Understanding of relational databases and basic data modeling concepts
- Ability to communicate effectively with both technical and non-technical stakeholders
- Willingness to learn new tools, systems, and business processes
- Exposure to Microsoft Fabric, Azure data platforms, or data warehouse environments
- Experience working with manufacturing, operations, or supply chain data
- Familiarity with common operational metrics such as production output, yield, backlog, on-time delivery, or lead time
- Experience or interest in Power Apps and Power Automate
Benefits & conditions
This is a Contract position based out of Bethel, CT. Pay and Benefits
The pay range for this position is $31.00 - $45.00/hr.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
- Medical, dental & vision
- Critical Illness, Accident, and Hospital
- 401(k) Retirement Plan - Pre-tax and Roth post-tax contributions available
- Life Insurance (Voluntary Life & AD&D for the employee and dependents)
- Short and long-term disability
- Health Spending Account (HSA)
- Transportation benefits
- Employee Assistance Program
- Time Off/Leave (PTO, Vacation or Sick Leave) Workplace Type, Aerotek offers weekly pay, employee benefits including medical, dental & vision, life insurance, health advocacy and employee assistance programs, a 401(k) plan, and employee discounts.