Job description

The Principal Analytics Engineer - Data Architecture is a principal individual contributor and technical leader on the Customer Analytics team. This role builds and operates CMT's relational data marts, dbt data products, and reusable semantic layer for BI, data science, and AI. The position partners with Customer Solutions, Data Engineering, Product, and Customer Success to resolve ambiguous needs, align definitions and governance, and deliver scalable, well-documented data products with clear ownership and customer impact. Responsibilities: Use independent judgment and discretion to architect relational data marts and high-scale dbt models in Databricks and Delta Lake, using dimensional modeling and software engineering practices for scale, maintainability, and cost efficiency Own data products end to end, from discovery and contracts through automated testing, CI/CD deployment, documentation, monitoring, support, and controlled change Design and productionize a modular semantic layer and shared data services that deliver governed metrics, dimensions, metadata, approved access paths, and vector-enabled retrieval across BI, data science, and AI Operate high-availability data and reporting products to agreed SLAs through freshness and quality alerts, lineage, observability, proactive issue detection, and urgent resolution Align metric definitions, governance, and domain ownership; resolve ambiguity with internal and external stakeholders, and raise team standards through reusable dbt frameworks, technical reviews, mentoring, and AI-assisted development Complete any additional tasks as they arise Qualifications: Bachelor’s degree or equivalent years of experience and/or certification in a related field 7+ years of experience in analytics engineering, data engineering, or data architecture with a bachelor's degree, or 5+ years with a graduate degree Expert SQL and dimensional modeling, including grain, star and snowflake schemas, conformed facts and dimensions, SCD Type 2, snapshots, event models, and incremental processing Extensive dbt experience with modular models, macros, packages, custom tests, documentation, and source freshness; hands-on Databricks, Delta Lake, and Spark experience Production engineering experience with Git, CI/CD, automated testing, observability, SLA support, performance tuning, data catalogs, lineage, and policy-aware access Experience with semantic layers, embeddings, semantic search, and vector databases, plus exposure to AI/LLM tools as data consumers; proven product-oriented ownership and cross-functional influence Compensation and Benefits: Fair and competitive salary based on skills and experience, and annual performance bonus Equity may be awarded in the form of Restricted Stock Units (RSUs) Medical, Dental, Vision and Life Insurance, matching 401k, short-term & long-term disability and parental leave Unlimited Paid Time Off including vacation, sick days & public holidays Flexible scheduling and work from home policy depending on role and responsibilities Base Salary Range The base salary range for this position is: $169,700 to $212,100. This range is specifically for Cambridge, MA A dditional Perks: Work on a mission with real impact: crashes prevented, injuries avoided, lives protected around the world Join an industry leader — 65 million drivers protected, powering 140+ programs across 25 countries Recognized innovator in mobility AI, earning top honors including the TIME Industry Leader in AI, a Gold Edison Award, and the Artificial Intelligence Excellence Award for AI for Social Good. CMT is also Great Place to Work Certified Be part of the team inventing the future of mobility and road safety Move fast, own outcomes, do work that matters High ownership, small teams, and direct access to leadership — no layers between your work and its impact Unlimited PTO, flexible scheduling, competitive salary, annual performance bonus, RSUs, and full benefits including medical, dental, vision, and 401k match Summer Fridays provide team members with half days to recharge Join one of our employee resource groups: Black, AAPI, LGBTQIA+, Women, Book Club, and Health & Wellness Comprehensive wellness, education, and employee assistance programs Commitment to Diversity and Inclusion: At CMT, we believe the best ideas come from a mix of backgrounds and perspectives. We are an equal-opportunity employer committed to creating a workplace and culture where everyone feels valued, respected, and empowered to bring their unique talents and perspectives. Diversity is essential to our success, and we actively seek candidates from all backgrounds to join our growing team. We do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status or disability state. CMT is headquartered in Cambridge, MA. To learn more, visit www.cmtelematics.com and follow us on Instagram @cmt.ai A bout Cambridge Mobile Telematics: Cambridge Mobile Telematics (CMT) is the world’s largest telematics and AI company for safer mobility. Its mission is to make the world’s roads and drivers safer. The company’s AI-driven platform, DriveWell Fusion®, proactively identifies and reduces driving risk, leading to fewer crashes and injuries. To date, CMT’s technology has helped prevent over 126,000 crashes worldwide. CMT enables partners to measure risk, detect crashes, provide life-saving assistance, and streamline claims. Headquartered in Cambridge, MA, CMT operates globally with offices in Budapest, Hungary; Chennai, India; Seattle, Washington; Tokyo, Japan; and Zagreb, Croatia. Learn more at www.cmt.ai.

Requirements

Must-haves

Own data products end to end, from discovery and contracts through automated testing, CI/CD deployment, documentation, monitoring, support, and controlled change
Design and productionize a modular semantic layer and shared data services that deliver governed metrics, dimensions, metadata, approved access paths, and vector-enabled retrieval across BI, data science, and AI
Operate high-availability data and reporting products to agreed SLAs through freshness and quality alerts, lineage, observability, proactive issue detection, and urgent resolution
Complete any additional tasks as they arise
Bachelor’s degree or equivalent years of experience and/or certification in a related field
7+ years of experience in analytics engineering, data engineering, or data architecture with a bachelor's degree, or 5+ years with a graduate degree
Expert SQL and dimensional modeling, including grain, star and snowflake schemas, conformed facts and dimensions, SCD Type 2, snapshots, event models, and incremental processing
Extensive dbt experience with modular models, macros, packages, custom tests, documentation, and source freshness; hands-on Databricks, Delta Lake, and Spark experience
Production engineering experience with Git, CI/CD, automated testing, observability, SLA support, performance tuning, data catalogs, lineage, and policy-aware access
Experience with semantic layers, embeddings, semantic search, and vector databases, plus exposure to AI/LLM tools as data consumers; proven product-oriented ownership and cross-functional influence
Work on a mission with real impact: crashes prevented, injuries avoided, lives protected around the world
Join an industry leader — 65 million drivers protected, powering 140+ programs across 25 countries
Be part of the team inventing the future of mobility and road safety
Move fast, own outcomes, do work that matters
High ownership, small teams, and direct access to leadership — no layers between your work and its impact
Summer Fridays provide team members with half days to recharge
Join one of our employee resource groups: Black, AAPI, LGBTQIA+, Women, Book Club, and Health & Wellness
At CMT, we believe the best ideas come from a mix of backgrounds and perspectives.

Nice-to-haves

None flagged.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

aici/cdsqlllm

Platform: greenhouse
Effort: quick

Benefits

Benefits detected in the listing.

Dental

Vision

401k

Pto

Paid Time Off

Parental Leave

Wellness