Senior BI Analyst

Mizkan America•Schaumburg, IL

41d•$120,000 - $160,000•Hybrid

About The Position

The Senior BI Analyst translates business data into trusted, actionable insights that improve visibility, decision-making, and business outcomes. The role partners with business and IT stakeholders to define reporting needs, standardize metrics, and deliver secure, scalable analytics solutions. It combines business intelligence, data modeling, analytics, and modern data platform capabilities, using Power BI, Microsoft Fabric, Azure analytics services, and related tools. The position also supports data engineering and modern lakehouse practices, including scalable pipelines, governed data models, and reusable reporting solutions aligned with business priorities. The role is based at Mizkan America’s corporate office in Schaumburg, Illinois, with a hybrid schedule. Employees work onsite Tuesday through Thursday and remotely on other scheduled days, subject to business needs and company guidelines. The schedule is at least eight hours per day and 40 or more hours per week, with core hours from 9:00 a.m. to 3:00 p.m. Central Time, Monday through Friday. Start and end times may be flexible between 6:00 a.m. and 9:00 p.m. Additional onsite attendance, schedule flexibility, or business travel may occasionally be needed. The position requires a bachelor’s degree in a related field or an equivalent combination of education and experience; at least three years of experience in CPG or food manufacturing; three to five years of experience in Microsoft Fabric, BI, analytics, reporting, or a related discipline; and strong experience with ERP systems, specifically Dynamics 365 Finance and Operations. The annual salary range is $120,000–$160,000, and the role is eligible for a 10% target bonus through the Short-Term Incentive Plan. It is not eligible for overtime pay.

Requirements

Bachelor’s degree in Information Technology, Data Analytics, Computer Science, Business Analytics, Finance, Statistics, or a related field; an equivalent combination of education and experience may be considered.
At least 3 years of experience working in CPG or food manufacturing.
3–5 years of experience in Microsoft Fabric, business intelligence, analytics, reporting, or a related discipline.
Strong experience with ERP, specifically Dynamics 365 Finance and Operations.
Experience supporting business reporting, analytics, or data solutions in a corporate environment.
Experience building reports, dashboards, semantic models, or data solutions using Power BI.
Strong expertise in data engineering, business intelligence, reporting, dashboard development, and data visualization.
Advanced proficiency with Power BI, Microsoft Fabric, and Azure analytics services.
Experience with data modeling, semantic modeling, DAX, Power Query, SQL, and data transformation.
Knowledge of modern data architecture concepts, including lakehouse, pipelines, and data integration.
Understanding of data governance, data quality, and reporting best practices.
Ability to translate complex data into clear insights and business recommendations.
Strong stakeholder engagement, communication, requirements-gathering, and cross-functional collaboration skills, including communication with technical and non-technical stakeholders.
Continuous improvement mindset focused on automation and scalability.
Knowledge of Microsoft Fabric architecture, including Lakehouse, Warehouse, pipelines, capacity management, error handling, and integration concepts.
Applicants must be legally authorized to work in the United States; the employer cannot provide or assume employment visa sponsorship now or in the future.

Nice To Haves

Experience with Microsoft Fabric, Azure analytics services, SQL, DAX, Power Query, or lakehouse and warehouse concepts.
Experience with Dynamics 365 Finance and Operations, CPG, food manufacturing, finance, supply chain, or cross-functional enterprise data.
Experience with Python and PySpark for data engineering or analytics workflows.
Experience with Fabric capacity management, Azure data services, DevOps, Synapse Analytics, Synapse Link, or Power Platform.
Experience with VS Code, GitHub Copilot, agents, or MCPs.
Relevant Microsoft certification, such as Power BI Data Analyst Associate, Fabric Analytics Engineer Associate, DP-600, or DP-700.

Responsibilities

Design, develop, and maintain scalable BI solutions, including dashboards, reports, scorecards, and semantic models using Power BI and Microsoft analytics tools.
Partner with stakeholders to gather requirements, define metrics, and translate business needs into scalable analytics solutions.
Analyze, model, transform, and visualize data from multiple business systems to provide clear, consistent insights for decision-making.
Build and maintain data pipelines and transformations in Microsoft Fabric using SQL, Python, PySpark, notebooks, and pipelines.
Contribute to the design and optimization of lakehouse architecture, including Bronze, Silver, and Gold layers and scalable data structures.
Support Microsoft Fabric capabilities, including Lakehouse, Warehouse, pipelines, Dataflows Gen2, notebooks, semantic models, and Power BI integration.
Apply reporting governance, data quality, access control, documentation, and lifecycle practices to support accurate and secure analytics delivery.
Develop business requirements documentation in partnership with technical and non-technical stakeholders.
Support deployment practices, including version control and CI/CD pipelines where applicable.
Drive automation and standardization to reduce manual reporting and improve efficiency.
Provide user support, training, troubleshooting, and adoption assistance for BI tools, reports, dashboards, and analytics processes.
Collaborate across IT and business teams to improve reporting processes and data solutions.
Perform other assigned duties that support the team, department, or organization, including cross-functional initiatives, process improvements, and special projects.