Senior Software Engineer (Data Migration & Integration)

• Analyze CRM and legacy data models and design target schemas aligned with enterprise platforms
• Design, develop, and enhance ETL pipelines using SSIS and Azure integration services
• Implement robust incremental data migration and change data capture mechanisms
• Lead data migration execution, validation, reconciliation, and stabilization activities
• Develop and optimize complex SQL queries, stored procedures, and database objects
• Enforce data quality, consistency, and governance standards throughout migration processes
• Support reporting and analytics teams with reliable and structured data sets
• Design and manage API-based and event-driven integrations between enterprise systems
• Perform advanced performance tuning and troubleshoot complex data and pipeline issues
• Contribute to CI/CD, version control strategies, and deployment automation
• Maintain technical documentation and support knowledge transfer activities
• Provide guidance and mentoring to Software Engineers within the team

Requirements

• 5–8+ years of experience in data engineering, ETL development, or large-scale data migration initiatives
• Strong expertise in data modeling including ERDs, relationships, indexes, views, stored procedures, and functions
• Advanced SQL development skills with strong performance tuning and optimization experience
• Extensive hands-on experience with SSIS including package design, scheduling, and source-to-target mappings
• Experience working with structured and semi-structured data formats such as CSV, XML, JSON, TXT, Parquet, and relational databases
• Strong understanding of data warehousing concepts including dimensions, facts, metadata, and change data capture
• Practical experience with Azure services such as Data Lake, Function Apps, Logic Apps, and event-based integrations
• Experience with APIs and scripting for automation and enterprise integrations
• Proficiency with GitHub and modern development workflows
• Strong problem-solving skills and ability to work independently and lead technical tasks

Nice to Have

• Experience with enterprise CRM or ERP platforms
• Exposure to Microsoft Dynamics or similar enterprise solutions
• Experience supporting business intelligence, reporting, and analytics environments
• Background in financial or regulated enterprise data environments