Staff Data Engineer, MAX Digital

ACV • Buffalo, NY

5d • $160,000 - $215,000

About The Position

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. Our network of brands include 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:
Multiple medical plans including a high deductible, low cost health plan
Company-sponsored (paid) Short-Term Disability, Long-Term Disability, and Life Insurance
Comprehensive optional benefits such as Dental, Vision, Supplemental Life/AD&D, Legal/ID Protection, and Accident and Critical Illness Insurance
Generous paid time off options, including uncapped vacation days, the greater of 3 paid sick days or in accordance with the applicable state or local paid sick leave law, 6 paid company holidays, 2 floating holidays, parental leave, bereavement leave, jury duty leave, voting leave, and other forms of paid leave as required by applicable law or regulation
Employee Stock Purchase Program with additional opportunities to earn stock in the Company
Retirement planning through the Company’s 401(k)

Requirements

• Ability to read, write, speak and understand English.
• BS in Computer Science or related technical discipline or equivalent practical experience required. Advanced degrees are a plus.
• 10+ years’ professional experience in software engineering with deep Microsoft SQL Serever expertise; experience with PostgreSQL and MongoDB is a plus
• Strong proficiency in database internals, query optimization, and performance tuning.
• Deep expertise in SQL/T-SQL programming, database design principles, and data modeling.
• Solid understanding of SaaS, distributed systems, scalability, and high availability concepts.
• Experience with Python, C/C++, C#, or other relevant programming languages.
• Proven track record of designing and implementing complex software features with a focus on quality, maintainability, and performance.
• Excellent problem-solving skills and the ability to navigate complex technical challenges.
• Strong communication skills and the ability to collaborate effectively in cross-functional teams.
• Previous experience in a technical leadership or mentoring role is highly desirable.
• Microsoft certifications related to SQL Server are a plus.
• Experience designing, implementing, or modernizing ETL/ELT workflows, batch processing, synchronization services, or application-integrated data pipelines.

Nice To Haves

• Advanced degrees are a plus.
• experience with PostgreSQL and MongoDB is a plus
• Microsoft certifications related to SQL Server are a plus.
• Previous experience in a technical leadership or mentoring role is highly desirable.

Responsibilities

• Lead the architectural design and technical decision-making process for core data platform components, including SQL Server systems, data models, synchronization patterns, and cross-system data workflows, ensuring alignment with product goals and engineering standards.
• Design, develop, and implement complex features and enhancements within SQL Server and MongoDB, considering performance, scalability, and security aspects.
• Collaborate with product managers, designers, and other engineers to define requirements and translate them into technical specifications.
• Mentor and guide junior engineers, providing technical expertise, code reviews, and best practices to foster professional growth.
• Evaluate SQL and MongoDB environments and produce/execute plans to evolve the data architecture/infrastructure of our platform, ensuring that development engineers can work easily and effectively.
• Lead the evaluation and modernization of legacy ETL-style, batch, and synchronization workflows that support core business operations.
• Define scalable approaches for data pipeline architecture and orchestration that improve observability, supportability, recoverability, and operational resilience.
• Partner with application, product, and analytics teams to improve how transactional systems, analytical systems, and downstream integrations exchange data, reducing reliance on tightly coupled legacy database-driven workflows where appropriate.
• Standardize patterns for data synchronization, transformation, validation, and downstream delivery across shared platform components.
• Drive performance optimization efforts across both operational and batch-oriented workloads, including query tuning, indexing strategy, workload analysis, and data lifecycle considerations.
• Investigate and resolve complex technical issues, applying a systematic approach to troubleshooting and debugging.
• Collaborate with quality assurance teams to ensure robust testing strategies, including unit, integration, and performance testing.
• Stay current with industry trends, emerging technologies, and best practices, and apply this knowledge to improve the SQL Server product.
• Participate in cross-functional collaboration with teams such as documentation, support, and customer engagement to address customer needs effectively.
• Contribute to the continuous improvement of development processes, tools, and methodologies.
• Perform additional duties as assigned.

Benefits

• Multiple medical plans including a high deductible, low cost health plan
• Company-sponsored (paid) Short-Term Disability, Long-Term Disability, and Life Insurance
• Comprehensive optional benefits such as Dental, Vision, Supplemental Life/AD&D, Legal/ID Protection, and Accident and Critical Illness Insurance
• Generous paid time off options, including uncapped vacation days, the greater of 3 paid sick days or in accordance with the applicable state or local paid sick leave law, 6 paid company holidays, 2 floating holidays, parental leave, bereavement leave, jury duty leave, voting leave, and other forms of paid leave as required by applicable law or regulation
• Employee Stock Purchase Program with additional opportunities to earn stock in the Company
• Retirement planning through the Company’s 401(k)

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Associate degree