Lead Software Engineer (Data Migration & Integration)

• Define end-to-end technical approaches for data migration and integration delivery
• Establish standards for data modeling, SQL development, ETL design, and Azure-based integrations
• Review ERDs, source-to-target mappings, ETL designs, and data transformation logic
• Ensure solutions meet performance, scalability, reliability, and security requirements
• Lead technical design discussions and act as the primary escalation point for complex technical issues
• Lead execution of CRM data migration and integration strategies
• Define entity mappings, relationships, and incremental migration approaches
• Oversee API-driven and event-based integrations between enterprise platforms
• Support cutover planning, parallel runs, and post-migration stabilization activities
• Drive reconciliation, validation, and data quality assurance processes
• Design and implement data ingestion and staging workflows using Azure Data Lake (ADLS)
• Define logical data layers for ingestion, transformation, and consumption
• Implement orchestration workflows using Azure Logic Apps
• Develop and govern Azure Function Apps for data processing and system integrations
• Ensure monitoring, logging, and operational alerting mechanisms are implemented
• Guide dimensional modeling approaches for reporting and analytics
• Define SSIS architecture standards, package design, and scheduling practices
• Review and optimize SQL queries and high-volume data processing workflows
• Troubleshoot complex performance, reconciliation, and data integrity issues
• Ensure migration and integration processes meet operational SLAs
• Define GitHub workflows, branching strategies, and code review standards
• Support CI/CD pipeline implementation and environment promotion processes
• Enforce documentation standards and maintain technical design artifacts
• Ensure governance, auditability, and compliance requirements are embedded into solutions
• Support UAT readiness and production deployment activities
• Mentor engineers and support capability development within the team
• Lead technical reviews, design sessions, and solution walkthroughs
• Collaborate with business analysts, QA teams, CRM specialists, and infrastructure teams
• Communicate technical risks, dependencies, and mitigation strategies to stakeholders

Requirements

• Strong expertise in data modeling including ERDs, primary and foreign key relationships, and cardinality concepts
• Advanced SQL development skills with performance optimization experience
• Proven experience in enterprise ETL design and development using SSIS
• Experience working with multiple data formats including CSV, JSON, XML, and Parquet
• Strong understanding of data warehousing concepts and reporting data structures
• Hands-on experience with Azure Data Lake (ADLS) and data staging architectures
• Experience developing solutions using Azure Logic Apps and Azure Function Apps
• Experience with API-based integrations and event-driven data processing patterns
• Understanding of cloud performance, monitoring, and security best practices
• Experience with GitHub version control workflows and code review practices
• Experience implementing CI/CD pipelines and environment promotion strategies
• Experience with production support, monitoring, and incident management
• 5-7+ years of experience in data engineering, ETL development, or system integration roles
• Proven experience leading technical delivery in medium to large-scale data migration initiatives
• Strong hands-on development background combined with team leadership experience
• Ability to balance technical execution with coordination and stakeholder engagement
• Excellent analytical, problem-solving, and communication skills
• Experience working in CRM transformation or enterprise integration programs is highly desirable