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.
