Lead Data Architect

Cox Automotive is seeking a Lead Data Architect for a full-time employee position based in Carmel, IN office. This will be hybrid" work-from-home role requiring the selected candidate to come into our Carmel office approximately once a week, and potentially up to 10 times a month.
We are migrating from MS SQL Server to Snowflake and seeking a Lead Data Architect with extensive experience supporting enterprise data initiatives on DBT & Snowflake cloud platforms.
What you'll be doing :

• Work closely with product managers and engineers to design, implement, test, and continually improve scalable data solutions and services running on DBT & Snowflake cloud platforms.
• The selected candidate will have a robust background in software development, coding, and hands-on experience to steer our Infrastructure Automation practice. This role will be integral to transforming the way Cox Automotive designs, delivers, and manages infrastructure within our strategic on-premises data centers.
• Responsible for technical design, writing, support and operations of efficient, scalable, and extensible data integrations and ingestions.
• Lead and participate in architecture and design efforts.
• Implement enhancements for prioritized data integration and ingestions work efforts partnering with the business to ensure they meet the specified requirements.
• Create and own the technical product backlogs for products, help the team to close the backlogs in right time.
• Work closely with product managers and engineers to design, implement, test, and continually improve scalable data solutions and services running on DBT & Snowflake cloud platforms.
• Implement critical and non-critical system data integration and ingestion fixes for the data platform and environment. Ensuring root cause resolution to identified problems. Monitor and support the Data Solutions jobs and processes to meet the daily SLA.
• Recommend and code efficient and effective data integration and ingestion solutions for challenging problems for medium to large work efforts of medium to high complexity.
• Translate business requirements, data mappings into data integrations and ingestions code solutions.
• Design and maintain data pipelines and databases.
• Lead data curation efforts and ensure the quality of datasets.
• Manage data-related software systems.
• Work effectively with Technology Operations/Infrastructure teams to ensure continued operations and maintenance of the data integrations and ingestions as well as the data platform and environment.
• Full lifecycle application development related to middleware and enterprise data movement.
• Advance the cloud architecture for data stores.
• Mentor and assist other engineers in or out of your areas of ownership and expertise.
• Investigate, evaluate, and present new emerging technologies for use with data solutions and integrations.
• Develop scalable production ready data integration and processing solutions.
• Convert large volumes of structured and unstructured customer data.
• Choose and use the right analytical libraries, programming languages, and frameworks for each task.

What we require from you:

• Bachelor's degree in Computer Science or related field plus 7+ years of relevant work experience; or a Master's degree plus 5+ years of relevant work experience; or a PhD plus 5+ years of relevant experience
• In lieu of a degree, qualified candidates would require 14+ years of relevant professional experience
• Solid experience supporting Snowflake Data Warehouse
• Previous experience with DBT
• Solid MS SQL Server skills including reporting experience using SSIS/SSRS
• Good to have AWS and Azure cloud implementation experience.
• Good to have Reporting development and Production support.

About Cox Automotive
At Cox Automotive, people of every background are driven by their passion for mobility, innovation and community. We transform the way the world buys, sells, owns and uses cars, accelerating the industry with global powerhouse brands like Autotrader, Kelley Blue Book, Manheim and more. What's more, we do it all with an emphasis on employee growth and happiness. Drive your future forward and join Cox Automotive today!
About Cox
Cox empowers employees to build a better future and has been doing so for over 120 years. With exciting investments and innovations across transportation, communications, cleantech and healthcare, our family of businesses - which includes Cox Automotive and Cox Communications - is forging a better future for us all. Ready to make your mark? Join us today!
Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k)), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page .
Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individual's age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.
Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.