Cambridgemobiletelematics
Principal Analytics Engineer
Cambridge, MA. Posted a month ago
The role
This person will build and operate relational data marts, dbt data products, and a reusable semantic layer. They will partner with various teams to deliver scalable, well-documented data products for BI, data science, and AI.
What you will do
- Architect relational data marts and high-scale dbt models in Databricks and Delta Lake
- Own data products end to end from discovery through deployment and support
- Design and productionize a modular semantic layer and shared data services
- Operate high-availability data and reporting products through SLAs
- Align metric definitions, governance, and domain ownership
- Raise team standards through reusable dbt frameworks, technical reviews, and mentoring
- Complete any additional tasks as they arise
Required 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
Nice to have
- Experience with semantic layers, embeddings, semantic search, and vector databases
- Exposure to AI/LLM tools as data consumers
Benefits
- Medical, Dental, Vision and Life Insurance
- Matching 401k
- Short-term & long-term disability
- Parental leave
- Unlimited Paid Time Off including vacation, sick days & public holidays
- Summer Fridays provide team members with half days
About the company
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.