Sr Data Engineer

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 datasolutions for sourcing, selling and managing used vehicles with transparency and comprehensive insights that were once unimaginable. We are disruptors of the industry and we wantyou 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: Multiple medical plans including a high deductible health plan that costs $0 out of your paycheck 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 vacation time, sick days, Company holidays, 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) Who we are looking for: We are seeking a talented data/database professional as a Senior 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: Actively and consistently support all efforts to simplify and enhance the customer experience. Maintain and extend (as required) existing database operations solutions for backups, index defragmentation, data retention, etc. 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. Troubleshoot any Web Service or ETL stack (Python, Web APIs) outages during our operational support window. Leverage monitoring tools to ensure high performance and availability; work with operations and engineering to improve as required. Ensure existing HADR (availability groups) solution is functional and meets requirements. Support development stages for application development and data science teams, emphasizing in Postgres database development. Ensure that data development meets company standards for readability, reliability, and performance. Collaborate with software and DevOps engineers to design scalable services, plan ature 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. 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: Ability to read, write, speak and understand English. Bachelor's degree in computer science, Information Technology, or a related field (or equivalent work experience) 5 years of experience building & supporting the database tier of SaaS web applications 2 years of experience with Cloud platforms preferably in AWS In-depth knowledge of database architecture, 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 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 Nice to Have Qualifications: Experience with Airflow, Docker, 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 Compensation : $122,000.00 - $160,000.00 annually. Please note that final compensation will be determined based upon the applicant's relevant experience, skillset, location, business needs, market demands, and other factors as permitted by law. No immigration or work visa sponsorship will be provided for this position.LI-AM3 Our Values Trust & Transparency | People First | Positive Experiences | Calm Persistence | Never Settling At ACV, we are committed to an inclusive culture in which every individual is welcomed and empowered to celebrate their true selves. We achieve this by fostering a work environment of acceptance and understanding that is free from discrimination. ACV is committed to being an equal opportunity employer regardless of sex, race, creed, color, religion, marital status, national origin, age, pregnancy, sexual orientation, gender, gender identity, gender expression, genetic information, disability, military status, status as a veteran, or any other protected characteristic. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. If you have a disability or special need that requires reasonable accommodation, please let us know. For information on our collection and use of your personal information, please see our Privacy Notice. Other details Job Family Product & Technology Job Function Data Science Pay Type Salary Apply Now