Data Analyst

About Imbibe 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 our founding in 1963, Imbibe has been at the forefront of flavor innovation and product development. We offer a comprehensive range of services, including full product development, taste modulation, and finished product solutions. Our state-of-the-art campus features an Innovation Center and Pilot Plant that enable us to tackle industry-wide taste and texture challenges, ensuring that our clients receive the highest quality products. At Imbibe, we pride ourselves on our entrepreneurial spirit and commitment to continuous improvement. Our values of collaboration, accountability, and entrepreneurship drive us to deliver exceptional results for our clients. We also believe in giving back to the community. Through various initiatives we support efforts to combat food insecurity in the Chicagoland area by donating ingredients and our time. If you're passionate about the food and beverage industry and eager to make a meaningful impact, Imbibe is the place for you. Let's create something extraordinary together! Summary of Position The Data Analyst focuses on building scalable and effective business intelligence solutions, particularly as the company moves to a modern data architecture utilizing Microsoft Fabric, OneLake, and Power BI. This role emphasizes data modeling with SQL, clear communication with diverse stakeholders, and a commitment to 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. Essential Job Duties Power BI & Reporting • 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. Data Modeling & Integration • 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 (ImbibeTools) to modern Fabric-based pipelines and Lakehouse structures. • Maintain awareness of source systems, including Nav, Formulator, Salesforce, and SharePoint. Collaboration & Governance • Collaborate with department leads to define metrics and translate business questions into analytical solutions. • Align all work with Imbibe's data governance principles and standardized metric definitions. • Document dataset logic, data source dependencies, and business rules for scalability and self-service use. Enablement & Automation • Contribute to ongoing automation efforts using Power Automate, Power Apps, and Fabric pipelines. • Help drive 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 history 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 ~75% of the time. • Regular interaction via digital communication tools; must be detail-oriented and responsive. Compensation & Benefits The salary range listed represents the expected earnings for this role. The low end of the range reflects the starting salary for candidates with less experience or qualifications that meet the basic requirements for the position. The high end of the range reflects potential earnings for candidates with extensive experience, specialized skills, or qualifications above the standard requirements for the role. Imbibe supports employee well-being and professional growth by offering a comprehensive benefits package that includes the following: • Comprehensive medical, dental, and vision care • 401k retirement plan with company contribution and match • FSA and HSA account • Generous company holidays, PTO, and sick time • Onsite gym and wellness opportunities • Paid parental leave • Life and disability insurance • Learning and professional development opportunities