Senior BI Analyst

Position Overview

Job Title: Sr. BI Analyst

Location: Schaumburg, Illinois, U.S.A

Department: Information Technology

Reports to: Reporting & Analytics Manager

Position Summary

The Senior BI Analyst plays a critical role in translating business data into trusted actionable insights that improve visibility, support decision-making, and business outcomes. This role partners with business and IT stakeholders to define reporting needs, standardize metrics, and deliver secure, scalable analytics solutions. This position combines business intelligence, data modeling, and analytics expertise with modern data platform capabilities, leveraging Power BI, Microsoft Fabric, Azure analytics services, and related tools. The role also supports data engineering and modern lakehouse practices, including scalable data pipelines, governed data models, and reusable reporting solutions aligned to business priorities.

About Mizkan America

Based in our Corporate Headquarters in Schaumburg, IL, Mizkan America is a subsidiary of the Mizkan Group, a global, family-owned company that has been Bringing Flavor to Life™ for over 220 years. As one of the leading makers of vinegars, condiments, and sauces in the United States, Mizkan America maintains 12 manufacturing facilities that serve the retail, foodservice, specialty-Asian and food-ingredient trade channels. We are committed to following our two core principles: continuously challenging the status quo and delivering only the finest products for our customers. Our leadership seeks out, embraces, and implements ideas for improvement from all of its employees. Transparency and accountability are two key factors that drive our company’s overall management approach.

Why Join Mizkan America?

We combine the resources and brand power of a major food company with the speed and agility of a smaller company. That means fewer layers, faster decisions and real ownership of work you can see on store shelves. Two principles guide everything we do: offer customers only the finest products and continuously challenge the status quo. We're investing in what's next, including tools and training to use AI responsibly so it strengthens human judgment rather than replacing it. Whether you work in operations, innovation, commercial or a corporate function, your work makes an impact, and we're invested in your growth.

Location & Schedule

Work Location: Mizkan America’s corporate office in Schaumburg, Illinois.

Work Arrangement: Hybrid schedule that combines in-person collaboration with remote work on other scheduled days, based on business needs and company guidelines.

Schedule: This role is scheduled for at least eight (8) hours per day and 40 or more hours per week. Core hours are 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., helping employees balance flexibility with team collaboration, business needs, and deadlines.

In-Office Days: Employees work onsite Tuesday through Thursday, creating dedicated time for connection and collaboration. On these days, employees are expected to work at least eight (8) hours in the office, including core hours.

Additional Requirements: From time to time, additional onsite attendance, schedule flexibility, or business travel may be needed to support meetings, projects, and other business priorities.

What You'll Do

• 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.
• Perform other duties assigned that support the overall success of the team, department, or organization. This may include participating in cross-functional initiatives, contributing to process improvements, or assisting with special projects as needed.
• This list is intended to describe the general nature and level of work performed. This is not an exhaustive list of all responsibilities required for this role.

What You'll Bring

• 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.
• 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.

Key Performance Indicators

• Timely delivery of high-quality reporting, dashboard, semantic model, and analytics work aligned to agreed priorities.
• Adoption and usage of BI reports, dashboards, scorecards, and self-service analytics capabilities.
• Improved reporting accuracy, data quality, metric consistency, and stakeholder confidence.
• Reduced manual reporting through automation, standardization, reusable models, and scalable practices.
• Stakeholder satisfaction with reporting support, responsiveness, insight quality, and delivery value.

Required

Education, Certifications, Experience, Qualifications

• 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.
• Ability to view computer screens and read printed materials for prolonged periods.
• Occasional standing, walking, and reaching within the office environment.
• Ability to lift and carry office supplies or equipment weighing up to 10–15 lbs.
• Adequate hearing and speech to communicate effectively in person and via phone/video.
• Regular, predictable, in-person attendance on the business days the Company requires in-person attendance at this facility. (In-person attendance is optional on the other workdays.) For non-required-in-person attendance days, employees are expected to be present and engaged during the designated work hours for this role.

Compensation & Benefits

Compensation: The annual salary range for this position is $120,000 - $160,000 per year. This position is not eligible for overtime pay.

Actual compensation may vary based on relevant experience, skills, education, internal equity, market data, and geographic location, and other job-related factors permitted by law.

Bonus Eligibility: This position is eligible to participate in Mizkan’s Short-Term Incentive Plan (STIP) with a target bonus opportunity of 10%.

Benefits: Mizkan offers a comprehensive benefits package including medical, dental, vision, paid time off and company holidays, life and disability insurance, 401(k) with up to 4% company match, profit sharing, wellness programs, education assistance, and employee referral bonuses. Benefits eligibility and plan provisions are subject to the terms of the applicable benefit plans.

Work Authorization

Applicants must be legally authorized to work in the United States. Mizkan America, Inc. is unable to provide or assume sponsorship for an employment visa now or in the future.

Equal Employment Opportunity & Accessibility

Mizkan America, Inc. is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment. Employment decisions are based on job-related qualifications and business needs. Mizkan America, Inc. does not discriminate against individuals on the basis of race, ethnicity, national origin, religion, gender identity, sexual orientation, disability or protected veteran status or any other protected characteristic under applicable federal, state, or local law. Applicants who need a reasonable accommodation to participate in the application or interview process should contact [email protected].