Principal Data Analytics Engineer



Data Science
Cambridge, MA, USA
Posted on Saturday, May 4, 2024

Who we are

At CarGurus (NASDAQ: CARG), our mission is to give people the power to reach their destination. We started as a small team of developers determined to bring trust and transparency to car shopping. Since then, our history of innovation and go-to-market acceleration has driven industry-leading growth. In fact, we’re the largest and fastest-growing automotive marketplace, and we’ve been profitable for over 15 years.

What we do

The market is evolving, and we are too, moving the entire automotive journey online and guiding our customers through every step. That includes everything from the sale of an old car to the financing, purchase, and delivery of a new one. Today, tens of millions of consumers visit each month, and ~30,000 dealerships use our products. But they're not the only ones who love CarGurus—our employees do, too. We have a people-first culture that fosters kindness, collaboration, and innovation, and empowers our Gurus with tools to fuel their career growth. Disrupting a trillion-dollar industry requires fresh and diverse perspectives. Come join us for the ride!

Role overview

We are looking for a Principal Data Analytics Engineer with experience in data modeling to join the Data Engineering team at CarGurus as we scale out our data modeling framework in dbt. As a Principal Data Analytics Engineer at CarGurus, you will be responsible for transforming raw data in the data warehouse into clean, reliable, organized data models that allow our organization to make informed data-driven decisions. Our tech stack currently consists of Snowflake, dbt, and Looker, along with an in-house built ETL pipeline using Airflow.

What you'll do

  • Design, build, and maintain scalable, modularized data models using dbt for our core data marts
  • Partner with analysts and non-technical stakeholders across the company 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

What you'll bring

  • 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 cloud data warehouses (Snowflake, BigQuery, and/or Redshift)
  • Experience with Looker or a similar BI platform (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
  • Bonus: Proficient with Python

Working at CarGurus

We reward our Gurus’ curiosity and passion with best-in-class benefits and compensation, including equity for all employees, both when they start and as they continue to grow with us. Our career development and corporate giving programs, as well as our employee resource groups (ERGs) and communities, help people build connections while making an impact in personally meaningful ways. A flexible hybrid model and robust time off policies encourage work-life balance and individual well-being. Thoughtful perks like daily free lunch, a new car discount, meditation and fitness apps, commuting cost coverage, and more help our people create space for what matters most in their personal and professional lives.

We welcome all

CarGurus strives to be a place to which people can bring the ultimate expression of themselves and their potential—starting with our hiring process. We do not discriminate based on race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation. We foster an inclusive environment that values people for their skills, experiences, and unique perspectives. That’s why we hope you’ll apply even if you don’t check every box listed in the job description. We also encourage you to tell your recruiter if you require accommodations to participate in our hiring process due to a disability so we can provide the appropriate support. We want to know what only you can bring to CarGurus. #LI-Hybrid