Cox Automotive is seeking a Lead Data Engineer (Finance Technology) to join our Enterprise Finance Technology team. Internally, this position is classified as a Lead Enterprise Applications Engineer. This role is responsible for designing, building, and optimizing data architecture, pipelines, and enterprise applications that power strategic decision-making across the organization.
The Lead Enterprise Applications Engineer architects, develops, implements and supports secure, compliant, resilient, cost-effective and high-performing enterprise application and data solutions for the Enterprise Finance Technology organization, including the data architecture, pipelines and applications that support financial consolidation, planning, forecasting and reporting.
The role collaborates across Architecture, Engineering, Technical Operations and Quality, and with Finance, Accounting and FP&A partners, to translate business and technical requirements into scalable implementations, design data models and integrations, configure and extend applications, optimize performance, and resolve complex production, pipeline and integration issues.
This position is accountable for making financial data accessible, trusted and actionable through sound data modeling, governance and quality practices. It also evaluates emerging technologies and uses infrastructure, platform cost, utilization and performance insights to guide design and scaling recommendations.
Primary Responsibilities:
- Collaborates with Architecture, Engineering, Technical Operations and Quality teams to develop detailed application implementation solutions.
- Architects, develops, builds and implements highly secure, compliant, resilient, cost-effective and high-performing solutions for assigned groups or disciplines.
- Performs application configuration, extension, integration and performance tuning, including query, pipeline and warehouse workload optimization.
- Designs, builds and maintains scalable data pipelines and ETL/ELT workflows that integrate enterprise financial applications with data warehouses, relational databases and business intelligence platforms.
- Designs and maintains data models, warehouse structures and semantic layers that support financial consolidation, planning, forecasting, reporting and self-service analytics.
- Ensures data integrity through automated quality checks, regression testing, validation frameworks and anomaly monitoring, and customizes data feeds and mappings with internal and external data providers.
- Orchestrates, schedules and monitors production data workloads, establishing observability, alerting and recovery procedures that meet data availability and freshness commitments.
- Applies data governance, access control, lineage and retention standards to financial data, ensuring solutions satisfy security, privacy, audit and compliance requirements.
- Develops, builds, configures, customizes, integrates and tests solutions.
- Investigates opportunities to use new and emerging technologies, including advances in AI, machine learning, data science and CPM platforms.
- Applies AI-assisted development tools to accelerate solution development, data validation and analysis workflows.
- Develops and delivers key reporting metrics and insights related to the cost and utilization of infrastructure services, and supports dashboard and KPI reporting development using Power BI, Tableau or similar business intelligence tools.
- Ensures team-wide application of standard operating procedures for development, deployment, support, break-fix and systems management, and contributes to application and data design standards, code and pipeline review practices, and technical mentoring across the team.
- Assesses usage and utilization trends and recommends design and implementation changes to scale infrastructure architecture.
- Collaborates with others to troubleshoot and resolve escalated production, integration or application issues.
- Applies analytical thinking, requirements analysis, software installation and support, system and technology integration, and technical troubleshooting capabilities at the higher end of the Skilled proficiency level.
- Demonstrates Collaborates with Intent, Drives Innovation, Focuses on Execution, Influences Positive Outcomes and Strives for Excellence at the higher end of the Skilled proficiency level.
Minimum Requirements:
- Bachelor’s degree in related discipline and 6+ years of experience in data engineering or architecture. The right candidate could also have a different combination, such as a master’s degree and 4 years’ experience; a Ph.D. and up to 2 year of experience; or 18 years’ experience in a related field.
- 6+ years of hands-on experience in data engineering, business intelligence, and/or enterprise analytics across multiple functional areas (reporting, dashboards, data pipelines, and data modeling).
- Advanced SQL proficiency and experience with data integration tools (e.g., MS SQL Developer, dbt, Informatica).
- Must have strong working experience with data modeling, data access, schemas, and data storage techniques within Snowflake.
- Working experience in design, development, and implementation of scalable data pipelines in cloud environments (AWS, Snowflake).
- Working experience with ETL/ELT patterns, data warehousing concepts, and data orchestration tools.
- Working experience working with relational databases such as SQL, MySQL, Postgres/PostgreSQL.
- Working experience with business intelligence tools and platforms (Power BI, Tableau, or similar).
- Working experience with data quality tools.
- Working experience with application lifecycle methodologies (e.g. waterfall, agile, iterative).
- Demonstrated project management experience with complex system implementations.
- Experience working with Git.
- Experience working with AI related tools such as GitHub Copilot, Snowflake Cortex, or M365 Copilot.
- Experience implementing new tools into environments.
- Excellent analytical, problem-solving, and communication skills with the ability to present technical concepts to non-technical stakeholders.
- Availability for rotational on-call duties outside of standard business hours may be required.
Preferred Qualifications:
- Experience architecting, configuring, integrating and performance-tuning enterprise applications in complex technology environments.
- Experience designing and implementing secure, compliant, resilient and highly available application solutions.
- Experience leading complex application implementations and resolving escalated production or integration issues across multiple technical teams.
- Experience using operational, cost and utilization metrics to recommend application or infrastructure improvements.
- Working knowledge of automation, software deployment practices, emerging technologies and standard operating procedures for application support and systems management.
Drug Testing:
To be employed in this role, you'll need to clear a pre-employment drug test. Cox Automotive does not currently administer a pre-employment drug test for marijuana for this position. However, we are a drug-free workplace, so the possession, use or being under the influence of drugs illegal under federal or state law during work hours, on company property and/or in company vehicles is prohibited.
Compensation:
Compensation includes a base salary in the range of $111,500.00 - $185,900.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate’s knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program.
Benefits:
The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company’s needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave.
EOE, including disability/vets
