Associate Data Analytics Engineer / Data Analyst

JOB DESCRIPTION

Vroom.com is seeking exceptional Analytics Engineers! As a valued member of our data team, you will be responsible for building the vroom data platform and empowering data analysts, product analysts, data scientists and embedded analysts across the organization. Within the analytics department, we carry each other forward. You will work closely with stakeholders and other analysts to understand the business needs and develop the data platform that will advance Vroom.  

Do you have a background in a variety of data systems including ETL pipelines, data warehouses, and BI tools? Are you proficient in software engineering best practices? Can you build and optimize data systems? Do you have a desire to keep up with the latest tools and techniques for data analytics? This is a high impact role that builds the foundation for the data organization. If these are the kinds of challenges that get you up in the morning, we want to hear from you!

We value your personal growth, and will gladly train you on any of our technologies that you don’t currently have. Ours is a culture where your voice will be heard, and you’ll be able to see the result of your work! We’re one of the few players in the e-commerce automotive space. As a member of our crew, you will become an industry expert.
 

Tools We Use:

• Python (Airflow)

• SQL (Redshift, Postgres, SQL Server, DBT)

• Looker

• Segment & Stitch

• AWS (Redshift, Glue, MWAA, S3, RDS)

• Gitlab

What You'll Do:

• Design, develop, and deploy reliable and scalable data solutions from data ingestion to ready-for-analysis datasets

• Maintain and optimize data pipelines, data models and data warehouse for performance and scalability

• Identify gaps in tech stack, generate architecture recommendations and implement them

• Guide, improve and implement best practices and standards for code maintainability and performance 

• Establish testing standards and design automated mechanisms to monitor and improve data integrity across all data systems

• Partner with product analysts, data analysts, data scientists, and the business to understand the underlying business needs to provide meaningful data solutions
   

What Skills We’re Looking For:

• Demonstrated hands-on experience in analytics engineering, data engineering, or a backend software development role building data processing systems w/ production quality code

• Experience architecting, designing and building robust and maintainable data systems

• Demonstrably deep understanding of SQL (dbt preferred) and analytical data warehouses (Redshift preferred)

• Must have hands-on experience with Python-based data pipeline tools (Airflow preferred)

• Strong analytical skills to QA data, identify gaps and determine the root cause of issues

• Proficiency in AWS tooling, ideally Redshift Administration, AWS Glue, S3, and RDS

• Bonus points for experience in Salesforce, Google Workspace, Docker, Luigi, Kafka, Spark
   

Who you are: 

• An initiative taker who’s able to solve ambiguous problems from inception to completion

• An open communicator who can speak to audiences of varying technical backgrounds

• A highly collaborative person with a mentorship mindset

• Someone who knows how to balance business and technical needs

• Someone who is excited about all things data and eager to learn 

#LI-NG1