[Hiring] Staff Software Engineer @CDK Global

Role Description

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 ID” 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.

Qualifications

• Bachelor’s degree or foreign equivalent in Computer Science, Computer Engineering, or related field.
• 8 years of experience as a Software Developer, or related occupation.

Requirements

• Using Microsoft SQL Server and T-SQL to design, develop, and support relational database solutions.
• Using ETL and data integration tools such as AWS Glue, AWS Lambda, SQL Server Integration Services (SSIS) and Azure Data Factory.
• Using application development technologies such as ASP.NET, C#, VB, ADO.NET and Python.
• Using database administration tools such as SQL Server Management Studio (SSMS), SQL Server Agent, Maintenance Plans, and Azure SQL Managed Instance’s automated management features.
• Using application and system monitoring tools such as AppDynamics, New Relic, Logic Monitor, and Azure Monitor.
• Using reporting and analytics technologies such as SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), and cloud data platforms like Snowflake.
• Using source control and release management tools such as Git, Team Foundation Server (TFS), Azure DevOps, and Harness CI/CD.
• Working with CI/CD processes and tools, including Git, Azure DevOps, Bitbucket, Liquibase (DB Deployment), Terraform, and Harness.
• Working in Agile/Scrum environments using tools such as Jira and Confluence.
• Designing data models and supporting data warehouse environments, including dimensional modeling.
• Designing and supporting relational and NoSQL databases, including Microsoft SQL Server, PostgreSQL, MySQL, and MongoDB.
• Monitoring and troubleshooting databases and application performance using tools such as AppDynamics, New Relic, Redgate, AWS CloudWatch, SQL Profiler, and Azure Monitor.

Benefits

• Medical, dental, and vision benefits.
• Paid Time Off (PTO).
• 401K Matching Program.
• Tuition Reimbursement.