Data Warehouse Developer (W2)

We are seeking a skilled Data Warehouse Developer with strong experience in designing, developing, and optimizing enterprise data warehouse solutions, along with hands-on expertise in SQL Server migrations. The ideal candidate will support data integration, ETL development, database modernization initiatives, and migration projects from legacy SQL Server environments to modern platforms.
Key Responsibilities
Design, develop, maintain, and optimize enterprise data warehouse solutions.
Build and support ETL/ELT pipelines for structured and semi-structured data.
Perform SQL Server database migrations, upgrades, and consolidation projects.
Analyze existing database architectures and recommend modernization strategies.
Develop and maintain dimensional data models, fact tables, and star/snowflake schemas.
Optimize SQL queries, stored procedures, indexes, and database performance.
Collaborate with business analysts, data engineers, and application teams to gather requirements.
Ensure data quality, integrity, security, and governance standards are maintained.
Support cloud migration initiatives involving Azure SQL, Synapse, or hybrid environments.
Create technical documentation, migration runbooks, and deployment procedures.
Troubleshoot production issues and provide ongoing operational support.
 
Preferred Qualifications
Experience with cloud platforms such as:
Microsoft Azure
Azure Data Factory
Azure Synapse Analytics
Power BI
Knowledge of CI/CD pipelines and DevOps practices.
Experience with scripting languages such as PowerShell or Python.
Familiarity with data governance and security compliance standards.
Certification in Microsoft SQL Server, Azure Data Engineering, or related technologies.