Manufacturing BI Analyst - Real-Time Dashboards

Baker Group; Ankeny (IA); On-site; USD 70,000 - 100,000; Full time

Job summary

The Baker Group in Ankeny, IA is seeking a Data Analyst to transform curated data into reports, dashboards, and analyses that support decision-making across the organization. You will partner with the Data Engineer and Data Scientist to surface insights for manufacturing operations and executives.

Responsibilities include designing Power BI dashboards, building paginated reports, and automating data distribution while ensuring data quality and governance across Fabric semantic models and SQL

Qualifications

• Bachelor’s degree in a quantitative field such as Business Analytics, Data Science, Information Systems, Statistics, or Engineering.
• 2–4 years of experience in business intelligence, reporting, or data analysis.
• 2–4 years of experience with manufacturing data and decision-support systems is preferred.
• Proficiency with Power BI (report design, DAX, Power Query) and SQL.
• Experience with Power Automate or similar workflow automation tools.
• Strong Excel skills for data manipulation and ad hoc analysis.
• Experience gathering requirements from and presenting findings to business stakeholders.
• Familiarity with Fabric semantic models and paginated reporting.

Responsibilities

• Designs, builds, and maintains Power BI dashboards and reports for departmental, operational, and executive consumption.
• Works with manufacturing operations leaders to deliver real-time or near real-time reporting on productivity metrics and project status.
• Partners with the Software Development team to embed Power BI reports and visuals within in-house developed applications.
• Builds and maintains paginated reports for structured, print-ready, and scheduled reporting needs.
• Automates report generation and data distribution to stakeholder inboxes using Power Automate.
• Writes and maintains SQL queries and DAX expressions to support ad hoc analysis and reporting requests.
• Prepares and exports data in Excel to support independent ad hoc analysis.
• Gathers reporting requirements directly from stakeholders across departments, including executives.

Skills

Power BI

SQL

DAX

Power Automate

Excel

Data analysis

Requirements gathering

Presentation skills

Self-service BI

Education

Bachelor's degree in Business Analytics/Data Science

Tools

Power BI Fabric

Power Query

Microsoft Fabric

Job description

The Baker Group in Ankeny, IA is seeking a Data Analyst to transform curated data into reports, dashboards, and analyses that support decision-making across the organization. You will partner with the Data Engineer and Data Scientist to surface insights for manufacturing operations and executives.

Responsibilities include designing Power BI dashboards, building paginated reports, and automating data distribution while ensuring data quality and governance across Fabric semantic models and SQL