Contractor Data Warehouse Data Engineer

White Plains, New York
AutoNation
Auto TechLabs Inc.

Position Summary:

The role of Data Warehouse Data Engineer is to design, develop and maintain AutoNation’s enterprise data warehouse platform and enterprise data marts. The position is responsible for designing and developing data pipelines to extract data from various source systems and load to data marts and reporting tables. This work includes analyzing, cleansing, and transforming and data to support reporting and analytical needs. The developer will leverage technologies such as Python, PySpark, SQL, AWS Glue, Airflow, DBT, Meltano, Snowflake and notebook applications. The Data Warehouse Data Engineer will work with a team of warehouse developers. This includes working with the team on design, implementation planning, development, testing and operational support. We are seeking a talented individual with experience working in a matrix IT organization to deliver enterprise class software projects in a fast-paced environment.

Organizational Relationships:

• IT Leadership: Director and Sr. Director positions in IT organization
• IT Teams: BI, QA, Security, DevOps, DBA, Architecture, Infrastructure, PMO
• Product owners
• Product stakeholders
• Scrum team members: Developers, QA testers, Business Analysts, Data Analysts, Project Manager

Job Responsibilities:

• Develop new data pipeline solutions to meet functional and non-functional requirements
• Monitor, maintain and tune existing pipelines, ELT, and orchestration of those pipelines
• Analyze data in RDBMS and big data platforms
• Respond to pipeline failure incidents, participate in any alerts, escalations and/or recovery procedures necessary to ensure system functionality is restored in a timely manner
• Assist with the establishment and adherence to development standards and release promotion procedures that reduce maintain effort and drive improvements in system stability

Qualifications:

• BA/BS degree in Information Technology or equivalent combination of education and experience
• 3-5 years of experience developing in python
• 3-5 years of experience developing in SQL
• 3-5 years of experience developing ELT solutions such as DBT
• Experience deploying ELT processes to an enterprise environment
• Experience in Performance Tuning and Optimization, using native monitoring and troubleshooting tools
• Experience in implementing operational automation using scripts
• Excellent communication and documentation skills appropriate for senior technology leadership
• Experience with cloud-based (AWS and Azure) database systems and environments
• Strong analytical and problem-solving skills
• Must meet company’s requirements for employment
• Valid in-state driver’s license and have and maintain an acceptable, safe driving record

Physical Requirements

• Work with computers and other common office equipment
• Work location is in a corporate office environment with no special physical requirements beyond what is normally expected in a typical modern corporate office.

Company Overview

As America’s largest and most recognized automotive retailer, AutoNation is transforming the automotive industry through its bold leadership, innovation, and comprehensive brand extensions. We are committed to hiring driven, diverse Associates and supporting them in growing their career within AutoNation. We offer paid training, competitive pay & benefits and a culture that believes in investing in our Associates’ professional futures. With over 315 locations from coast to coast, AutoNation has an opportunity for you. We’ve sold over 13 million vehicles, the first automotive retailer to reach this milestone. Our success is driven by our commitment to delivering a peerless Customer experience through customer-focused sales and service processes. We believe deeply in giving back, and every car we sell helps to raise cancer research and treatment awareness with a Pink Plate. We have proudly raised over $25 million dollars to drive out cancer, create awareness, and support critical research.

Join us as we pave the way to moving our company, our communities and our industry forward. Apply today at a location near you or wherever you dream the road will take you.