8901 - Corp Office West Crk - 12800 Tuckahoe Creek Parkway, Richmond, Virginia, 23238CarMax, the way your career should be!About this jobThe bulk of the data engineer's work would be in building, managing and optimizing data pipelines and then moving these data pipelines effectively into production for key data and analytics consumers (like business/data analysts, data scientists or any persona that needs curated data for operational and analytical data use cases.Data engineers also need to guarantee compliance with data governance and data security requirements while creating, improving and operationalizing these integrated and reusable data pipelines. This would enable faster data access, integrated data reuse and vastly improved time-to-solution for CarMax's operational and analytical initiativesAbout this jobCarMax is disrupting the industry by empowering customers to buy a car on their own terms, providing an iconic customer experience. As a Data Engineer you will support this by being involved in the data integration and analysis ofthis process. The Carmax Master Data Management team is looking for a Data Engineer to provide hands on data integration development data analysis expertise for an MDM team that is building data products that will enable trusted operational master data across the enterprise. Overall, you will have a direct impact on improving the performance of our business and ensuring customers can buy the vehicles they want in a way that's right for them.The Data Engineer will be responsible for understanding the business value requests and requirements provided by the Product Manager, and will use a technical, analytical and critical thinking skillset to develop ETL and Data Integration programs, and analyze data for the MDM team. Additionally, you will partner with integration partners to understand source system application data, and assist with reconciliation and remediation.The candidate is a proven team player, highly proficient in SQL development, strong critical thinker, well versed in ETL, data integration and data analysis in a wide range of applications.This position involves a high degree of independence and broad exposure to all aspects of development including configuration, maintenance, analysis, design, implementation and documentation.The individual provides on-time and accurate estimation of work, ensures a high level of quality of team solutions, and is driven to meet commitments.What you will do - Essential ResponsibilitiesPartner with Product Manager and Sr Analyst to understand business and functional requirementsDevelop ETL and data integration programs, using a variety of technologies, including Informatica, SQL and scriptingAnalyze and troubleshoot data integrations to identify and resolve missing or incorrect or inconsistent data due to ETL issues.Assist the team in performing analysis required for UAT testing and validationAssist the team with analysis required for post implementation testing, validation and monitoringQualifications and RequirementsExtensive experience with hands on development of complex SQL programs to enable analysis of application data Extensive experience with ETL and data integration development using multiple tools, including Informatica and other technologiesExtensive experience using DBMS technologies, including TeradataExperience with Data Engineering in a cloud technology, preferably AzureExperience with agile methodologiesStrong communication both written and verbalPreferred QualificationsMDM ExperiencePython Scripting ExperienceAbout CarMaxCarMax disrupted the auto industry by delivering the honest, transparent and high-integrity experience customers want and deserve. This innovative thinkingaround the way cars are bought and soldhas helped us become the nation's largest retailer of used cars, with over 200 locations nationwide.Ouramazing team of more than 25,000 associates work together to deliver iconic customer experiences.Along the way,we help every associate grow their career and achieve their best, at work and in their community. We are recognized for our commitment to training and diversity and areone of the FORTUNE 100 Best Companies to Work For®.CarMax is an equal opportunity employer, and all qualified candidates will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, genetic information, national origin, protected veteran status, disability status, or any other characteristic protected by law.Upon an applicant's request, CarMax will consider reasonable accommodation to complete the CarMax Job Application.