Senior Analytics Engineer

CDK Global, Inc. is a leading retail automotive technology company, has recently acquired a Calif.-based company called Roadster, Inc. ("Roadster"), a digital sales platform that modernizes the way consumers buy vehicles and the process in which dealers sell them. The integration of Roadster assets and capabilities positions CDK to bring the first fully integrated, end-to-end retail solution to the automotive market and deliver on the promise of Modern Retailing.The solution will help franchise automotive dealers compete with-and exceed the capabilities of-digital-first used vehicle marketplaces that have expanded rapidly in the past year. It will enable dealers to sell new and used vehicles completely online, while also giving consumers the option to begin and end the vehicle-buying process anywhere they choose-online or in-store.As our Analytics Engineer, you will be a key member of the Roadster Analytics team, reporting directly to our VP of Analytics.You will use your advanced SQL skills to assemble complex customer journeys in BigQuery and Postgres, then use our BI system (Mode Analytics) to help our customers and internal users visualize where people are getting stuck in the process.We're constantly building out new software features - much of your role will be working with our customers to understand how they're using the software and what's important to them. You'll then work with our Data Engineer to acquire and build a data model, then design and build unique ways to visualize and measure the new software. Your responsibilities will include: You'll own the content of our DataWarehouse and be accountable for consistent, accurate data. You'll own and build upon our Python stack, which powers our ML prediction models and our data-gathering crawlers. You'll help our BI and Data Visualization team optimize their queries for performance. You'll help build intuitive datasets enabling self-serve analysis across the entire company. You'll ensure our analysts follow software engineering standards. You'll work with our engineering team to build new ETLs and integrate APIs for new data feeds. Our Stack includes: BigQuery, Postgres, Airflow, Mode Analytics.You may be a fit for this role if you have:Expert SQL skillsComfortable using Python to manipulate and analyze dataAirflow experienceETL ExperienceHave worked in Analytics or with an Analytics team. Have experience with predictive algorithms.Solid Business Acumen, fluent in business analysis (revenue, gross margin, market share) You get Extra-Credit if you have any of the following:Have worked in a Software Engineering environmentJavaScript skillsAutomotive experienceExperience working in a startup or software companyCDK Global knows you have passions outside of work. You have family, friends, sporting events, and lots of things going on. That's why we offer a comprehensive benefits package to not only take care of you but your family as well. All of our benefits are effective the first day of employment including 401K matching, paid time off to re-energize, donate your time to volunteer in your community, and tuition reimbursement to name a few.At CDK, we pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different perspectives they provide. We offer equal opportunity employment regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, or protected veteran status.