Staff Engineering - Vehicle Intelligence - Data

Who we are looking for:

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

As part of the Data Engineering team you will be responsible for maintaining and extending our database options, optimizing SQL queries, collaboration with teams on database support, and designing scalable data services.   You will solve complex database challenges, be a key player in continually improving our databases, and work well in a rapidly growing changing engineering workplace.

What you will do:

As a Staff Data Engineer at ACV Auctions you will design, develop, write, and modify code.  You will work alongside and mentor 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 are a technical leader who is 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.

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

• Develop and implement 2-3 year lifecycle plans for database or infrastructure tools to ensure business risk and liability are accounted for.

• Lead team discussions to define requirements on new and current products.

• Manage third-party consulting resources, as needed.

• 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.

• Design, implement, and maintain scalable and high-performance data infrastructure solutions, with a primary focus on data.

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

• 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 software and DevOps engineers to design scalable services, plan feature roll-out, and ensure high reliability and performance of our products.

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

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

• Lead and own the overall performance of products and services within a defined area of focus.

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

• Mentor junior data engineers.

• 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.  

• 8+ years of experience building & supporting the database tier of SaaS web applications

• 4+ years of experience with Cloud platforms preferably in AWS

• In-depth knowledge of database architecture, infrastructure, performance tuning, and optimization techniques.

• Hands-on experience with database replication, clustering, and high availability solutions.

• Strong proficiency in SQL query writing and optimization.

• Familiarity with database security principles and best practices.

• Experience with database monitoring and diagnostic tools, preferably Data Dog.

• Strong hands-on skills and the ability to drill deep into the complex system design and implementation.

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

• ETL workflow implementation (Airflow, Python)

• Experience working with:

  • SQL data-layer development experience; OLTP schema design

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

  • Github, Jenkins, BigQuery, Redis, Python, Redis, Airflow, Docker

Nice to Have Qualifications:

• Experience with Visual Studio, Pycharm

• Experience with database management/administration with Postgres and/or MySQL

• Knowledge of data warehousing concepts and technologies, including dimensional modeling and ETL frameworks