Analytics and Intelligence Engineer

Mars • Chicago, IL

8d • $119,040 - $163,680 • Onsite

About The Position

As an Analytics and Intelligence Engineer, you will be a key member of Mars Accelerator’s Data and Analytics team, contributing to the design, development, and enhancement of divisional reporting, semantic modelling, and intelligence capabilities. You will work with fellow engineers, data scientists, and business stakeholders across sales, marketing, supply chain, and finance to translate complex business requirements into dependable analytical data models and actionable dashboards.

The role bridges business needs with robust data engineering practices. You will build high-quality data products, integrate predictive and automated intelligence into analytical workflows, and help continuously improve the modern analytics stack. You will also support business users in self-serving governed data and contribute to reliable, performant BI tools and reporting solutions.

Requirements

• 3–6+ years of hands-on experience in analytics engineering, business intelligence, or data analytics, delivering reliable data models and production dashboards.
• Bachelor’s or Master’s degree in Computer Science, Engineering, Mathematics, Statistics, Information Systems, Business Analytics, or a related field, or equivalent practical experience.
• Strong proficiency in SQL.
• Experience building and optimizing dimensional models, including Star Schemas, and analytical tables.
• Practical experience with modern data transformation and lakehouse tools such as dbt, Databricks, Snowflake, or Azure Data Services.
• Hands-on experience developing intuitive, performant dashboards using platforms such as Power BI or Tableau.
• Working knowledge of Python or R for exploratory analysis, data transformation, or automation.
• Familiarity with Git workflows, pull requests, and automated testing frameworks such as dbt test.
• Exposure to data cataloguing or governance tools such as Unity Catalog and workflow orchestration tools such as Databricks Workflows, Airflow, or Azure Data Factory.
• Ability to collaborate in an agile team, share knowledge, participate in constructive code reviews, and adapt to evolving business needs.

Nice To Haves

• Experience working within CPG, retail, DTC, or manufacturing environments.

Responsibilities

• Partner with cross-functional business stakeholders and engineering peers to build consistent KPI dashboards, reliable data assets, and high-impact reporting tools.
• Build, test, and maintain scalable data models and semantic layers, including Star Schemas, dbt, and Databricks, as a dependable single source of truth for the Mars Accelerator Division.
• Collaborate with data scientists and analytics peers to incorporate predictive models, statistical forecasting algorithms, and anomaly detection into business-facing dashboards and semantic layers.
• Apply data software engineering practices, including Git version control, collaborative code reviews, automated testing, data quality validation, and CI/CD.
• Create documented, certified datasets and provide guidance and technical support to business users so they can self-serve data confidently.
• Maintain data accuracy, testing, and cataloguing standards, including use of Databricks Unity Catalog, to keep enterprise data governed, accessible, and compliant.
• Develop performant, intuitive dashboards in BI platforms such as Power BI and Tableau, and participate in peer reviews to maintain visual and performance standards.
• Participate in agile planning, sprint execution, and backlog refinement, delivering well-scoped analytics solutions on time.

Benefits

• Learning and development support from day one, including access to Mars University.
• Industry-competitive salary and benefits package, including company bonus.
• Variable pay.
• Medical and dental benefits.
• Participation in a 401(k) plan.
• Paid time off benefits.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level