Senior Analytics Engineer: Gold Data Models & Dashboards

The Chamberlain Group LLC; Oak Brook (IL); On-site; USD 103,000 - 193,000; Full time

Job summary

The Chamberlain Group LLC is seeking a senior analytics engineer to lead the design of curated Gold‑layer data models and enterprise metric views. This hands‑on technical leadership role defines standards, mentors engineers, and delivers self‑service analytics that BI tools and AI agents can trust.

You will partner with data engineers and business stakeholders to translate questions into durable models, build robust dashboards, and govern metric definitions while optimizing performance and cost.

Qualifications

• Bachelor's degree in CS or equivalent work experience.
• 4+ years in analytics engineering, data warehousing, or BI.
• Hands-on with Databricks (2+ years).
• Proven ability to set standards and mentor engineers.

Responsibilities

• Design and maintain Gold-layer data models and data marts.
• Define enterprise metrics as governed Unity Catalog views.
• Develop modular transformation logic in Databricks SQL and PySpark.
• Lead design reviews and mentor engineers across teams.

Skills

SQL mastery

Python / PySpark

Data modeling

Databricks platform

Dashboards/BI design

Mentoring engineers

Education

Bachelor's Degree in Computer Science or equivalent

Tools

Databricks

Unity Catalog

Delta Lake

Databricks SQL

PySpark

Job description

The Chamberlain Group LLC is seeking a senior analytics engineer to lead the design of curated Gold‑layer data models and enterprise metric views. This hands‑on technical leadership role defines standards, mentors engineers, and delivers self‑service analytics that BI tools and AI agents can trust.

You will partner with data engineers and business stakeholders to translate questions into durable models, build robust dashboards, and govern metric definitions while optimizing performance and cost.