Develops scalable Power BI and Microsoft Fabric solutions, including dashboards, semantic models, data pipelines, and lakehouse architectures. Partners with stakeholders to define metrics, gather requirements, improve data quality, and deliver governed analytics. Uses SQL, Python, PySpark, DAX, and Power Query to transform and visualize enterprise data. Supports deployment, automation, user training, troubleshooting, and adoption. The role requires experience with Dynamics 365 Finance and Operations, corporate reporting, and preferably CPG or food manufacturing environments.
Job Summary & Responsibilities
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.
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.
Work Location: Schaumburg, IL
Essential Functions:
- 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.
- Regular, predictable attendance during core business hours in a remote work environment is an essential function of this position. Employees are expected to be responsive, accessible, and actively engaged throughout the workday.
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
- 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.
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.
- 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.
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
- A full range of 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 are also available.
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.
#LI-SM1
Mizkan America, Inc. Mount Prospect, Illinois, USA Office
Mount Prospect, United States, 0
Similar Jobs
18 Days Ago
Digital Media • Information Technology • News + Entertainment
Develops and operates centralized cybersecurity data pipelines, ETL processes, dashboards, and compliance reporting. Administers Splunk Enterprise and Enterprise Security, integrates cloud, application, vulnerability, asset, and AI security data, and defines risk prioritization models and remediation SLAs. The role monitors remediation performance, improves data quality, automates audit evidence collection, supports AWS security analytics, and communicates actionable risk insights to technical and executive stakeholders.
Top Skills:
AWSBusiness IntelligenceCyber Asset Attack Surface Management (Caasm)ETLSecurity Data PipelinesSplunk EnterpriseSplunk Enterprise SecuritySplunk Smartstore
Legal Tech
Develops business intelligence products and analytics supporting strategic decision-making across the firm. Responsibilities include client profitability and segmentation analysis, growth and margin analysis, reusable data models, KPI governance, executive dashboards, automated reporting, and self-service analytics. Partners with Finance, Revenue, Business Development, Pricing, Technology, and other stakeholders to translate financial, market, operational, and client data into actionable insights while maintaining reporting quality and consistency.
Top Skills:
Data ModelingData VisualizationExcelPower BIReporting AutomationSQL
Healthtech
Lead complex BI projects to define KPIs, build internal and client-facing Tableau/Power BI dashboards, enforce documentation and metric consistency, perform data analysis and profiling, create BI strategy and roadmaps, mentor junior analysts, and present insights to cross-functional and executive stakeholders.
Top Skills:
JIRAPower BIPythonRSnowflakeSQLTableau
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
