Remote Chicago‑Based BI Analyst: Semantic Layer

Cars Commerce; Chicago (IL); On-site; USD 104,000 - 130,000; Full time

Benefits offered by this job

Medical, Dental & Vision

Home Office stipend

Generous PTO

Paid holidays

Job summary

Cars Commerce is seeking a BI Analyst - Semantic Layer to own governance of metrics, definitions, and the semantic layer across our BI ecosystem. You will codify metric definitions, collaborate with analytics, data engineering, and business stakeholders, and ensure consistency across platforms.

This hands-on role emphasizes building from the ground up, maintaining the glossary, and driving adoption of governed data throughout the organization.

Qualifications

• Bachelor's degree in Computer Science, Engineering, or a related field, or equivalent practical experience.
• 5+ years of experience in analytics engineering, business intelligence, or data governance, with hands-on SQL experience.
• Direct, hands-on experience authoring and maintaining models in a semantic layer or metrics layer tool.
• Strong dimensional modeling fundamentals — star schema design, slowly changing dimensions, and an understanding of how join fan-out silently corrupts aggregate results.
• Experience running a metric or glossary governance process with real business stakeholders outside the data team — not just internal data-team documentation.
• Experience with a data catalog tool for glossary and business-term content management — Atlan, Collibra, Alation, or similar.
• Excellent stakeholder management, facilitation, and training/enablement skills — comfortable adjudicating disagreements between business stakeholders and running literacy programs for non-technical audiences.

Responsibilities

• Author and maintain semantic layer definitions, hands-on. Write and maintain the actual metric, dimension, and hierarchy definitions as code.
• Run the metric definition lifecycle — from request to publication with versioned change control.
• Own the Atlan glossary content, including ownership tagging and context.
• Keep definitions in sync across tools and enforce certification across the enterprise.
• Partner with department heads and analysts to define new metrics and resolve definitional disagreements.
• Drive data literacy through office hours and enablement content.

Skills

SQL

Semantic Layer

Data Governance

LookML

dbt Semantic Layer

Stakeholder Management

Analytics Engineering

Education

Bachelor's degree in Computer Science/Engineering or related field

Tools

dbt Semantic Layer

LookML (Looker)

AtScale

Job description

Cars Commerce is seeking a BI Analyst - Semantic Layer to own governance of metrics, definitions, and the semantic layer across our BI ecosystem. You will codify metric definitions, collaborate with analytics, data engineering, and business stakeholders, and ensure consistency across platforms.

This hands-on role emphasizes building from the ground up, maintaining the glossary, and driving adoption of governed data throughout the organization.