#CABCARUS5932786EXTERNALENUS
rst 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 Snowflake
Experience with Looker and other similar BI platforms (ex. 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
Proficiency with Python is desired but not required
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