Principal Data Analytics Engineer

Cargurus - Boston, MA

Full-time - Principal

Boston, MA

Motor Vehicle and Parts Dealers

About the position

At CarGurus, we are seeking a Principal Data Analytics Engineer to join our Data Engineering team. This role is pivotal as we scale out our data modeling framework using dbt. The Principal Data Analytics Engineer will be responsible for transforming raw data in our data warehouse into clean, reliable, and organized data models that empower our organization to make informed, data-driven decisions. Our current tech stack includes Snowflake, dbt, and Looker, along with an in-house built ETL pipeline utilizing Airflow. In this position, you will design, build, and maintain scalable and modularized data models for our core data marts. You will collaborate with analysts and non-technical stakeholders across the company to gather business requirements for various modeling projects. Additionally, you will create explores in Looker to surface data models for self-service, driving best practices and standards for data modeling, documentation, and testing. Mentoring junior team members on their modeling projects and assisting with code reviews will also be a key part of your responsibilities. As a Principal Data Analytics Engineer, you will lead architecture design and implement best practices within Snowflake. Engaging with key decision-makers across business functions to support complex initiatives will be essential. You will also contribute to platform ownership tasks such as permissioning, metadata management, and maintenance for both the data warehouse and Looker platform.

Responsibilities

• Design, build, and maintain scalable, modularized data models using dbt for core data marts.
• Partner with analysts and non-technical stakeholders to gather business requirements for modeling projects.
• Create explores in Looker to surface data models for self-service.
• Drive best practices and standards for data modeling, documentation, and testing.
• Mentor junior team members on their modeling projects and assist with code reviews.
• Lead architecture design and implement best practices within Snowflake.
• Engage key decision makers across business functions to support complex initiatives.
• Contribute to platform ownership tasks such as permissioning, metadata management, and maintenance for the data warehouse and Looker platform.

Requirements

• 7+ years of experience as an Analytics Engineer, Data Engineer, or similar role.
• 3+ years of experience with building complex data models in dbt or similar.
• Expert-level proficiency with SQL, including writing performant queries on large data sets.
• Experience working with Snowflake.
• Experience with Looker and other similar BI platforms (e.g., Tableau, PowerBI, Sigma).
• Experience with Data Observability Tools.
• Strong communication skills and ability to work effectively with both technical and non-technical stakeholders.
• Interest in coaching and mentoring junior engineers on the Analytics Engineering team.

Nice-to-haves

• Proficiency with Python is desired but not required.

Benefits

• Equity for all employees, both upon starting and as they continue to grow.
• Career development and corporate giving programs.
• Employee resource groups (ERGs) and communities to help build connections.
• Flexible hybrid work model.
• Robust time off policies to encourage work-life balance.
• Daily free lunch.
• New car discount.
• Meditation and fitness apps.
• Commuting cost coverage.