Software Engineer (Data Migration & Integration)

• Review existing CRM and legacy data structures and assist in designing target data models aligned with enterprise systems
• Develop and support ETL pipelines using SSIS and Azure services for data extraction, transformation, and loading
• Implement incremental data synchronization and change tracking processes
• Assist with data migration execution, validation, reconciliation, and post-migration stabilization
• Create and optimize SQL queries, stored procedures, and database objects
• Ensure data accuracy, consistency, and integrity throughout migration activities
• Prepare structured datasets for reporting and analytics teams
• Support integrations between enterprise systems and downstream platforms using APIs and event-driven workflows
• Participate in performance tuning and troubleshooting of data pipelines and databases
• Follow established best practices for version control, documentation, and deployment processes

Requirements

• 3–6+ years of experience in database development, data engineering, or data migration projects
• Solid understanding of data modeling concepts including ERDs, relationships, indexes, views, stored procedures, and functions
• Strong SQL development skills with basic performance optimization knowledge
• Hands-on experience with SSIS including data flows, packages, and scheduling
• Experience working with structured and semi-structured data formats such as CSV, XML, JSON, TXT, Parquet, and relational tables
• Knowledge of data warehousing concepts such as dimensions, facts, and metadata
• Exposure to Azure services including Data Lake, Function Apps, and Logic Apps
• Familiarity with APIs and scripting for data processing and automation
• Experience using GitHub or similar version control tools
• Strong analytical skills and ability to work collaboratively within technical teams

Nice to Have

• Exposure to enterprise CRM or ERP platforms
• Experience with Microsoft Dynamics or similar enterprise solutions
• Experience supporting reporting and analytics environments
• Background in financial or enterprise data environments requiring high accuracy