Sr BI Analyst

About Mizkan America

Based in Schaumburg, IL, Mizkan America is a subsidiary of the Mizkan Group, a global, family-owned company with over 220 years of experience in flavor creation. We are dedicated to serving the retail, foodservice, Asian specialty, and food ingredient trade channels with our range of vinegars, condiments, and sauces.

Senior BI Analyst Role

The Senior BI Analyst plays a crucial role in transforming business data into actionable insights that enhance visibility, support decision-making, and drive business outcomes. This role involves partnering with business and IT stakeholders to define reporting needs, standardize metrics, and deliver secure, scalable analytics solutions. The ideal candidate will leverage Power BI, Microsoft Fabric, Azure analytics services, and related tools to design, develop, and maintain scalable BI solutions.

• 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 present clear, consistent insights that support decision making.
• Build and maintain data pipelines and transformations within Microsoft Fabric using SQL, Python, PySpark, notebooks, and pipelines.
• Contribute to the design and optimization of lakehouse architecture (Bronze/Silver/Gold layers) to support scalable analytics and reporting.
• Support Microsoft Fabric capabilities, including Lakehouse, Warehouse, pipelines, Dataflows Gen2, notebooks, semantic models, and Power BI integration.
• Contribute to lakehouse design, including Bronze/Silver/Gold layers and scalable data structures.
• Apply reporting governance, data quality, access control, documentation, and lifecycle practices to support accurate, secure analytics delivery.
• Develop business requirements documentation (BRD) in partnership with technical and non-technical stakeholders.
• Support deployment practices, including version control and CI/CD pipelines where applicable.
• Drive automation and standardization efforts 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 continuously improve reporting processes and data solutions.

Key Skills/Competencies

• 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.
• Strong communication skills with technical and non-technical stakeholders.
• Continuous improvement mindset with focus on automation and scalability.
• Experience with Microsoft Fabric architecture, including Lakehouse, Warehouse, pipelines, capacity management, error handling, and integration concepts.
• Experience with ERP systems (preferably Dynamics 365 Finance & Operations), finance, or supply chain data environments preferred.

Education/Experience/Qualifications/Certifications

• Bachelor’s degree in Information Technology, Data Analytics, Computer Science, Business Analytics, Finance, Statistics, or a related field (equivalent combination of education and experience may be considered).
• 3+ years of experience working in CPG or food manufacturing.
• 3 - 5 years of experience in Microsoft Fabric, business intelligence (BI), analytics, reporting, or 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.
• Preferred hands-on experience with Microsoft Fabric, Azure analytics services, SQL, DAX, Power Query, or lakehouse/warehouse concepts.
• Experience with Dynamics 365 Finance & 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.

Physical Requirements And Work Conditions

• Ability to remain seated at a workstation for extended periods (up to 8 hours per day).
• Frequent use of hands and fingers for typing, writing, and handling office equipment.
• Adequate hearing and speech to communicate effectively in person and via phone/video.

Compensation & Benefits

Annual salary for this position ranges from $120,000 - $160,000. Note: Compensation is based on a number of factors including market location and may vary depending on job-related knowledge, skills and experience. This role is eligible for a Short-Term Incentive Bonus. Mizkan America, Inc. offers a full range of benefits including medical, dental, vision, 401K plus up to four percent (4%) match, profit sharing, wellness program, paid parental leave, long-term-care insurance, critical accident insurance, short- and long-term disability, and education assistance.

Mizkan America, Inc. is an Equal Opportunity Employer and considers all qualified applicants without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability, protected veteran status, or any other protected characteristic under applicable federal, state, or local law.