Lead Software Engineer – Data Migration & Integration (Contract)

We are seeking a Lead Software Engineer to drive the technical delivery of data migration and integration solutions for a CRM transformation initiative. This role provides hands-on technical leadership across architecture implementation, ETL development, Azure integrations, and data platform stabilization. The Lead will work closely with business stakeholders, CRM teams, and engineers to ensure scalable, secure, and high-performing data solutions while guiding teams through complex migration and post-transition challenges.

Key Responsibilities

Technical Leadership & Solution Design

• 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 expectations.
• Lead technical design discussions and act as the primary escalation point for complex issues.

Data Migration & Integration Delivery

• 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 stabilisation activities.
• Drive reconciliation, validation, and data quality assurance processes.

Azure Data Platform Implementation

• Design 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 integrations.
• Ensure monitoring, logging, and operational alerting are implemented.

Data Engineering & Performance Optimization

• 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 challenges.
• Ensure migration and integration processes meet operational SLAs.

Governance, DevOps & Delivery Excellence

• Define GitHub workflows, branching strategies, and code review standards.
• Support CI/CD implementation and environment promotion processes.
• Enforce documentation standards and maintain technical design artifacts.
• Ensure governance, auditability, and compliance considerations are embedded in solutions.
• Support UAT readiness and production deployment activities.

Team Leadership & Collaboration

• Mentor engineers and support capability development within the team.
• Lead technical reviews, design sessions, and solution walkthroughs.
• Collaborate closely with business analysts, QA teams, CRM specialists, and infrastructure teams.
• Communicate technical risks, dependencies, and mitigation strategies to stakeholders.

Required Technical Skills

Data Engineering & Integration

• Strong expertise in data modeling — ERDs, PK–FK relationships, and cardinality concepts.
• Advanced SQL and performance optimization experience.
• Enterprise ETL design and development using SSIS.
• Experience handling multiple data formats such as CSV, JSON, XML, and Parquet.
• Strong understanding of data warehousing and reporting data structures.

Azure & Cloud Platforms

• Hands-on experience with Azure Data Lake (ADLS) and data staging architectures.
• Development using Azure Logic Apps and Function Apps.
• API-based integrations and event-driven data processing patterns.
• Understanding of cloud performance, monitoring, and security best practices.

DevOps & Delivery

• GitHub version control workflows and code review practices.
• CI/CD pipelines and environment promotion strategies.
• Production support, monitoring, and incident management experience.

Experience & Qualifications

• 5–7+ years of experience in data engineering, ETL development, or system integration roles.
• Proven experience leading technical delivery within 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 thinking, problem-solving ability, and communication skills.

Contract Duration: 12 Months

Working hours – 1 pm to 10 pm IST

Work mode - Remote