Engineering Evergreen Template
hace 8 días
Tempe
Job Description About Carvana "We believe CVNA is in the early stages of becoming the next U.S. retail category killer." – Stephens Investment Bank, Analyst Report, Sept. 2024 Building leading-edge technology has been at the core of Carvana's strategy since our founding, driving us to become the 3rd fastest company in history to organically reach the Fortune 500 following only Amazon and Google. Today, we remain founder-lead and as ambitious as ever. In 2024, we have not only emerged as the fastest growing automotive retailer, but also the most profitable thanks to our deep vertical integration across retail, lending, vehicle transportation, wholesale auctions, and more. If you want to grow not just as an Engineer but as a leader and business-builder, Carvana is the place for you. Our technology teams build: • End-to-end ecommerce for both selling and buying cars, including everything you see on Carvana.com and in our mobile apps., • AI-driven customer support across chat, email, SMS, and voice, as well as a proprietary CRM platform to ensure the most efficient and highest quality customer experience., • 360°ree; vehicle photography and interactive merchandising using cutting edge computer vision and AI techniques., • The most sophisticated and self-service automotive lending platform in the world., • Systems and tools behind a nationwide logistics network that has delivered and picked up over 3 million cars via our fully owned and operated fleet of automotive haulers, efficiently managing distribution of our massive inventory to 85% of US driveways., • Enterprise grade systems for operating the largest vehicle reconditioning facilities in the US, with workflow and automation to guide the work for everything mechanical, electrical, and cosmetic needed to bring each car to our high standards. THIS IS A 100% ON-SITE POSITION FROM OUR HQ IN TEMPE (Monday through Friday) About the team and position Join the Engineering Database team, a vital part of Carvana.com. Be part of a team that guides the development of scalable, reliable, and efficient data-driven applications, ensuring accurate and timely analytics and business process development. We're disrupting the car buying status quo, and you can be a part of that, making an immediate and significant impact on peoples car buying experience. We're searching for a talented and professionally curious individual ready to make a significant impact by driving the evolution of our cloud-based data infrastructure. You'll apply your strong foundation in T-SQL (preferably Azure) to build and optimize database objects, author complex stored procedures, functions, and triggers that power Carvana.com applications. Your primary focus will be at the forefront of cloud administration for our SQL and Elastic environments, where you'll be instrumental in building and maintaining scalable and reliable data solutions. Experience with ETL processes (Databricks or SSIS is a definite plus) is highly valued as we continuously enhance our data pipelines and push the boundaries of what's possible. What you'll be doing Be the connection between our systems and our data. You will have the opportunity to learn and grow, working alongside a highly skilled and supportive team on exciting projects that will help shape Carvana. • Design & Implement: Scalable, secure, and highly available database solutions that meet business and technical objectives., • Database Development: Engineer and optimize SQL objects, including stored procedures, user-defined functions, triggers, and views to support application logic and data transformation., • Cloud Administration: Maintain our SQL and Cosmos databases in Azure in addition to Elastic Cloud resources. Additionally maintain a system of alerts providing system status and environment health., • Performance Optimization: Proactively identify, diagnose, and resolve database performance bottlenecks. Perform query tuning, index management, and execution plan analysis to ensure optimal application responsiveness., • Data Integration: Develop, and maintain ETL/ELT pipelines and data integration workflows using tools (e.g., Databricks or SSIS) to populate data warehouses and data marts., • Technical Leadership & Mentorship: Provide subject matter expertise to software engineering teams on database best practices. Mentor junior developers, conduct thorough code reviews, and establish and enforce database development standards., • 5+ years of progressive experience in database development, with at least 2 years in a senior or lead role, • Database Systems: Administration of cloud technologies, preferably on Azure (e.g. Azure SQL Database, Cosmos DB, etc.) or Elastic Cloud., • Procedural Language: Strong foundation of T-SQL including DDL & DML and authoring complex stored procedures, functions and triggers, • Performance Tuning: Ability to perform query optimization, index management, and execution plan analysis., • ETL/ELT Development: Hands-on experience building and managing data integration pipelines using tools such as SSIS, Databricks or similar technologies., • Notifications: Maintain a system of alerts for the cloud environment ensuring stability and performance, • SDLC & CI/CD: Proficiency with modern development practices, including source control (e.g., Git), database project management, and participating in CI/CD pipelines., • Leadership & Mentorship: Proven ability to provide technical leadership, mentor junior developers, and enforce development standards through constructive code reviews., • Problem-Solving: Exceptional analytical and troubleshooting skills with the ability to diagnose and resolve complex data-related issues., • Communication: Excellent verbal and written communication skills, capable of creating detailed technical documentation and explaining complex concepts to diverse audiences., • AI Familiarity: Experience using generative AI coding assistants to improve development velocity and code quality., • Competitive salary and Carvana stock compensation, • Medical, Dental, and Vision benefits, • 401K with company match, • A multitude of perks including student loan payments, discounts on vehicles, benefits for your pets, and much more, • A great wellness program to keep you healthy and happy both physically and mentally, • Access to opportunities to expand your skill set and share your knowledge with others across the organization To be able to do your job at Carvana, there are some basic requirements we want to share with you. Legal Stuff Hiring is contingent on passing a complete background check. This role is not eligible for visa sponsorship. Carvana is an equal employment opportunity employer. All applicants receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, marital status, national origin, age, mental or physical disability, protected veteran status, or genetic information, or any other basis protected by applicable law. Carvana also prohibits harassment of applicants or employees based on any of these protected categories. Please note this job description is not designed to contain a comprehensive listing of activities, duties, or responsibilities that are required of the employee for this job. Duties, responsibilities, and activities may change at any time with or without notice.