Senior Azure Data Warehouse Migration Specialist/ Architect

NOTE: C2C cannot be considered || W2 ONLY Job Title: Azure Data Warehouse Migration Specialist Location: Kansas City, MO Duration: 6 months Industry: Insurance Job Description We are seeking an experienced Azure Data Warehouse Migration Specialist/ Architect with 10-15 years of experience to lead large-scale data and application migration initiatives to the Azure Cloud. The ideal candidate will have strong expertise in data warehousing, SQL, and lift-and-shift migration strategies, along with hands-on experience in end-to-end cloud transformation projects. Required Skills & Experience • 10-15 years of overall IT experience with strong focus on Data Warehousing and SQL. • Proven experience in Azure Cloud migrations, especially lift-and-shift approaches. • Hands-on experience with: • Azure Data Services (Azure Synapse, Azure SQL Database, Azure Data Factory) • Data warehouse design and optimization • Large-scale data migration projects • Strong expertise in SQL performance tuning and database management. • Experience migrating the following components: • Applications • Data Warehouse • SQL Databases • Solid understanding of cloud architecture, networking, and security. • Prior experience in the Insurance industry will be highly preferred. Key Responsibilities • Lead and execute end-to-end migration to Azure Cloud, including applications, data warehouse, and SQL databases. • Design and implement lift-and-shift migration strategies with minimal downtime and risk. • Assess existing on-premise systems and define migration roadmaps and architectures. • Migrate and modernize data warehouse solutions to Azure (e.g., Azure Synapse, Azure SQL). • Manage data migration, validation, and performance tuning post-migration. • Collaborate with cross-functional teams including application, infrastructure, and business stakeholders. • Ensure data integrity, security, and compliance throughout migration lifecycle. • Optimize cloud architecture for performance, scalability, and cost-efficiency. • Provide technical leadership and mentor junior team members. Preferred Qualifications • Experience with modernization beyond lift-and-shift (re-architecture, re-platforming). • Knowledge of ETL/ELT tools and data pipelines. • Azure certifications (e.g., Azure Solutions Architect, Azure Data Engineer). • Strong problem-solving and stakeholder management skills.