Overview
Imbibe is a dynamic, high-growth food and beverage development company based in Niles, Illinois. We specialize in developing, creating, and manufacturing beverage flavors, ingredient systems, and finished food and beverage products. Our mission is to design ingredients with impact for the food and beverage industry. Since 1963, Imbibe has been at the forefront of flavor innovation and product development. We offer full product development, taste modulation, and finished product solutions. Our Innovation Center and Pilot Plant enable us to tackle industry-wide taste and texture challenges while delivering high-quality products. We value collaboration, accountability, and entrepreneurship, and we support initiatives to combat food insecurity in the Chicagoland area by donating ingredients and time.
Summary Of Position
The Data Analyst focuses on building scalable and effective business intelligence solutions, supporting a modern data architecture using Microsoft Fabric, OneLake, and Power BI. The role emphasizes data modeling with SQL, clear communication with diverse stakeholders, data quality, performance, and user experience. The analyst will work with enterprise-wide datasets, contribute to automation and reporting improvements, and help lay the groundwork for future self-service analytics.
Responsibilities
- Design, build, and maintain Power BI dashboards and reports using curated, governed datasets from Microsoft Fabric.
- Follow Imbibe’s SQL-first, minimal-DAX development standards to promote consistency and transparency.
- Iterate on reports based on stakeholder feedback using a structured enhancement cycle.
- Write and optimize SQL queries, views, and stored procedures to transform data in the Silver and Gold layers of Fabric.
- Support the migration of legacy SQL views to modern Fabric-based pipelines and Lakehouse structures.
- Maintain awareness of source systems, including Nav, Formulator, Salesforce, and SharePoint.
- Collaborate with department leads to define metrics and translate business questions into analytical solutions.
- Align all work with data governance principles and standardized metric definitions.
- Document dataset logic, data source dependencies, and business rules for scalability and self-service use.
- Contribute to automation efforts using Power Automate, Power Apps, and Fabric pipelines.
- Support the transition from a centralized BI model to a hybrid model that empowers business users.
Minimum Qualifications
- Bachelor’s degree in Computer Science, Data Analytics, or related field.
- 3–5 years of experience with relational databases, SQL development, and BI/reporting platforms.
- Expertise in Power BI with a proven track record of building performant dashboards.
- Experience with Microsoft Fabric/OneLake and cloud data platforms.
- Strong understanding of ETL/ELT best practices and source-to-report workflows.
- Excellent communication and collaboration skills.
- Self-starter with time management and attention to detail.
Preferred Qualifications
- Experience with Microsoft Dynamics NAV, Salesforce, or Formulator.
- Familiarity with SharePoint.
- Prior experience in a CPG or process manufacturing environment.
- Master’s degree in a relevant discipline.
Working Conditions
- Primarily office-based; hybrid work environment may be considered.
- Must be able to remain in a stationary seated position approximately 75% of the time.
- Regular interaction via digital communication tools; must be detail-oriented and responsive.
Compensation & Benefits
Base pay range: $75,000.00/yr - $95,000.00/yr
- Salary range reflects expected earnings; high end for extensive experience or specialized skills.
- Comprehensive benefits package including medical, dental, vision; 401k with company contribution and match; FSA/HSA; holidays, PTO, and sick time; onsite gym and wellness opportunities; paid parental leave; life and disability insurance; and professional development opportunities.
Seniority level
- Mid-Senior level
Employment type
- Full-time
Job function
- Information Technology
Industries
- Food and Beverage Services