Software Engineer, Data Engineering, AWS

CDK Global, LLC seeks Staff Software Engineer at its facility located at 11809 Domain Drive, Suite 200, Austin, TX 78758.

Apply specialized expertise in large-scale data engineering, ETL architecture, database design, and cloud migration across Azure and AWS platforms.

Architect and implement enterprise ETL and data processing systems using Azure Data Factory, SSIS, AWS Glue, and cloud storage platforms such as Azure Data Lake and AWS S3.

Design and maintain data models, ingestion frameworks, and transformation logic supporting CRM workflows and enterprise data services.

Lead the design and buildout of new ETL environments for cloud readiness, including migration from on premise SQL Server and SSIS workloads to Azure Data Factory.

Lead cross-functional engineering efforts involving data platform teams, cloud engineering, CRM engineering, security, and infrastructure.

Lead the ETL engineering team in migrating the full on prem ETL environment to Azure Data Factory, including technical planning, dependency management, pipeline conversion, and QA validation.

Coordinate delivery for core CRM processing systems including dealer data ingestion (DMSSOR), reference data processing, customer access databases, and pod migration workflows.

Solve complex technical challenges involving large-scale data ingestion, cloud integration, ETL optimization, and legacy system modernization.

Redesign legacy ETL pipelines to operate efficiently in Azure, including conversion of SSIS packages into ADF pipelines.

Modernize multiple legacy VB6-based systems by converting logic to C# (SSIS) and decommissioning outdated components.

Implement enterprise-wide data retention, archiving, and purging processes to improve system performance and ensure compliance.

Provide architectural leadership and technical direction for cloud migration and enterprise data initiatives.

Develop system architecture diagrams, migration strategies, and cloud transition plans for ETL workloads.

Define data integration approaches for the Connected Communications Platform (CCP) migration from on prem SQL to AWS S3 and AWS Glue.

Lead design and implementation of the Master Data Management (MDM) "Golden " solution to provide unified customer identity across dealership platforms.

Mentor engineers and provide specialized technical guidance on cloud ETL, data modeling, SQL optimization, and cloud migration processes.

Provide technical direction on ADF pipeline development, data architecture, SQL Server and PostgreSQL optimization, and cloud transformation.

Conduct code reviews, data model reviews, and architectural evaluations.

Partner with functional leadership to influence platform modernization priorities and architectural decisions.

Collaborate with product leaders, cloud engineers, and CRM stakeholders to determine migration timelines, resource requirements, and technical prioritization.

Support roadmap discussions related to decommissioning legacy systems and migrating to DMSSOR/Gen SOR.

Support cross-functional teams with technical expertise related to cloud systems, data integration, and ETL performance.

Assist CRM engineering, infrastructure, and security teams with data flow design, cloud ingestion patterns, ADF/SSIS processing logic, and ETL optimization.

Maintain compliance with CDK policies, security standards, and data governance requirements.

Ensure adherence to cloud security, IAM configuration, data encryption, retention policies, and regulatory requirements across ETL and CRM systems.

Meet expected deliverables for cloud migration, data platform modernization, and enterprise integration projects.

Deliver migration milestones for Azure ETL, CCP cloud transition, MDM implementation, Sunset Legacy DMS systems and DMS system modernization.

100% Telecommuting.

• This position requires a Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, or related field and 8 years of experience as a Software Developer, or related occupation.
• Using Microsoft SQL Server and T-SQL to design, develop, and support relational database solutions, including creating tables, views, stored procedures, and functions, as well as…