Analytics Engineer II Infrastructure

If you are looking for a career at a dynamic company with a people-first mindset and a deep culture of growth and autonomy, ACV is the right place for you! Competitive compensation packages and learning and development opportunities, ACV has what you need to advance to the next level in your career. We will continue to raise the bar every day by investing in our people and technology to help our customers succeed. We hire people who share our passion, bring innovative ideas to the table, and enjoy a collaborative atmosphere. 
 
Who we are: 

ACV is a technology company that has revolutionized how dealers buy and sell cars online. We are transforming the automotive industry. ACV Auctions Inc. (ACV), has applied innovation and user-designed, data driven applications and solutions. We are building the most trusted and efficient digital marketplace with data solutions for sourcing, selling and managing used vehicles with transparency and comprehensive insights that were once unimaginable. We are disruptors of the industry and we want you to join us on our journey. ACV’s network of brands includes ACV Auctions, ACV Transportation, ClearCar, MAX Digital and ACV Capital within its Marketplace Products, as well as, True360 and Data Services.

 At ACV we focus on the Health, Physical, Financial, Social and Emotional Wellness of our Teammates and to support this we offer: 

• Company Sponsored (paid) Healthcare, Dental, Vision, Life/AD&D, Short-Term and Long-Term Disability
  
• Comprehensive additional optional benefits such Critical Illness and Supplemental Life/AD&D. 
• All insurance benefits go into effect on your date of hire
• Generous Parental Leave Top-Up Pay and Vacation Programs
  
• Employee Stock Purchase Program with additional opportunities to earn stock in the company
  
• Retirement planning through the Company’s RRSP

Core Mandate:

The Analytics Engineer’s primary objective is to guide ACV in identifying and meeting the needs of its customers. This role is focused primarily on optimizing our existing Analytics Infrastructure and helping drive any future technological migrations.

What you will do (Responsibilities):

• Monitor our Analytics Infrastructure vendors (BigQuery, Airflow, Tableau Cloud, Fivetran, Kubernetes, etc) resource usage and optimize usage/costs accordingly

• Be a research partner and consultant in selecting vendors for future projects, such as embedded reporting and semantic data layers

• Assist and train our Analytics Engineers when onboarding or migrating to new infrastructure platforms

• Focus on the fundamentals of great questions, good process, competent analysis, clear communication, team wins, and focused contribution to the company’s needs

• With leadership guidance, be able to present analysis of a business area to stakeholders and support follow on questions, converting business questions into technical requirements

What you will need (Skills, Experience, Education):

• BA/BS in Statistics, Business Administration, Operations Research, or similar computationally intensive degree -or- college/university degree in Computer Science or relevant field.

• 2+ years of relevant, professional work experience related to various Cloud Technology Vendors such as Tableau, GCP, dbt

• Strong Professional Experience with SQL

• Experience analyzing complex queries and transformations on large data sets

• Experience with data visualization / dashboarding tools like Tableau 

• Functional competency in Python or similar scripting language

No immigration or work visa sponsorship will be provided for this position.