CareerPlan

Analytics and Intelligence Engineer

USA-Illinois-ChicagoFull-time$119k–$164k2026-10-27 → 2026-11-10
On-site

Core

Design, develop, and enhance reporting, semantic modelling, and intelligence capabilities for the Mars Accelerator division by building data models and dashboards.

Role type

Analytics and Intelligence Engineer

Builds

KPI dashboards, reliable data assets, high-impact reporting tools, and semantic layers

Domain

Consumer Packaged Goods (CPG) / Retail / Data Engineering

Deliverable

dashboards & analysis

Required skills

SQL, dbt, Databricks, Power BI, Tableau, Python, Git, automated testing, data modeling (Star Schemas)

Preferred skills

CPG/retail/manufacturing domain experience, workflow orchestration (Airflow, Azure Data Factory), data cataloguing (Unity Catalog)

Technologies

dbt, Databricks, Snowflake, Azure Data Services, Power BI, Tableau, Git, Unity Catalog, Airflow, Azure Data Factory

Responsibilities

Partner with stakeholders to build consistent KPI dashboards and data assets; Build and maintain scalable data models and semantic layers; Integrate predictive models and forecasting into dashboards; Implement software engineering best practices (CI/CD, code reviews); Create certified datasets and support business users; Maintain data accuracy, testing, and cataloguing standards; Develop performant BI dashboards; Participate in agile planning and sprint execution.

Seniority

Mid-level (3–6+ years experience)