Data - Engineer II, Data

The data engineering team's mission is to enhance the vehicle decoding accuracy, and provide high availability and high resiliency as a core service to our ACV applications. Additionally, the team is responsible for database to database ETL’s using different ingestion techniques.  We are responsible for a range of critical tasks aimed at ensuring smooth and efficient functioning and high availability of ACVs data platforms.  We are a crucial bridge between Infrastructure Operations, Data Infrastructure, Analytics, and Development teams providing valuable feedback and insights to continuously improve platform reliability, functionality, and overall performance.

As we expand our platform, we’re offering a wide range of exciting opportunities across various roles. At ACV, we put people first and believe in the principles of trust and transparency. If you are looking for an opportunity to work with the best minds in the industry and solve unique business and technology problems? Look no further!  Join us in shaping the future of the automotive marketplace!

Who we are looking for:

We are seeking a talented data professional as a Data Engineer to join our Data Engineering team. This role requires a strong focus and experience in software development, multi-cloud based technologies, in memory data stores, and a strong desire to learn complex systems and new technologies.  It requires a sound foundation in database and infrastructure architecture, deep technical knowledge, software development, excellent communication skills, and an action-based philosophy to solve hard software engineering problems.  

What you will do:

As part of the Data Engineering team you will be responsible for Python development for API and ETLs, application architecture, optimizing SQL queries, collaboration with teams on database and development support, and designing and developing scalable data services.   

As a Data Engineer at ACV Auctions you will design, develop, write, and modify code.  You will work alongside other data engineers and data scientists in the design and development of solutions to ACV’s most complex software problems.  It is expected that you will be able to operate in a high performing team, that you can balance high quality delivery with customer focus, and that you will have a record of delivering and guiding team members in a fast-paced environment.

• Actively and consistently support all efforts to simplify and enhance the customer experience.

• Design, develop, maintain code, and support for our web-based applications and ETLs using Python Fastapi and Python.

• Support multi-cloud application development.

• Design and build complex systems that can scale rapidly with little maintenance.

• Design and implement effective service/product interfaces.

• Contribute, influence, and set standards for all technical aspects of a product or service including but not limited to, testing, debugging, performance, and languages.

• Support development stages for application development and data science teams, emphasizing in Postgres database development.

• Be an influencer of the team designs and direction of our owned applications

• Actively seek new or additional technologies to improve the data layer of our application

• Influence company wide engineering standards for tooling, languages, and build systems.

• Leverage monitoring tools to ensure high performance and availability; work with operations and engineering to improve as required.

• Ensure that data development meets company standards for readability, reliability, and performance. 

• Collaborate with internal teams on transactional and analytical schema design.

• Conduct code reviews, develop high-quality documentation, and build robust test suites.

• Respond-to and troubleshoot highly complex problems quickly, efficiently, and effectively. This may include being part of the emergency after-hours on-call rotation.

• Perform additional duties as assigned

What you will need:

• Bachelor’s degree in computer science, Information Technology, or a related field (or 

• equivalent work experience)

• Ability to read, write, speak, and understand English.  

• 1+ years of experience programming, building & supporting SaaS web applications

• 1+ years of experience programming in Python Fastapi

• 1+ years of experience with ETL workflow implementation (Airflow, Python)

• Knowledge of database architecture, infrastructure, performance tuning, and optimization techniques.

• Familiarity with database security principles and best practices.

• Strong communication and collaboration skills, with the ability to work effectively in a fast paced global team environment.

• Some experience working with:

  • Cloud platforms preferably in AWS or GCP

  • SQL query writing and optimization

  • SQL data-layer development experience; OLTP schema design

  • Using and integrating with cloud services, specifically: AWS RDS, Aurora, S3, GCP

  • Github, Jenkins, Python #LI-NX1