Intermediate Lean Warehouse Developer to help implement a Datawarehouse solution for business reporting purposes for a Government client

Our client is looking for a Intermediate Lean Warehouse Developer to help implement a Datawarehouse solution for business reporting purposes for a Government client.

Overview:

The role supports continuous delivery, enterprise system modernization, and data integrity across complex platforms.

Must Have's:

• 3+ years of experience as a Data Warehouse developer
• 5+ years of experience building virtual models with Synapse Serverless
• 3+ years of experience creating unified fact/dimension views across clusters, harmonizing schema differences, and implementing the analytical semantic layer
• 2+ years of experience using Github for source control in collaborative environments
• 1+ years of experience working with CI/CD pipelines
• Agile

Nice to Have's:

• Experience replacing systems of record (registries, banking, insurance, taxation, financial or billing systems) is a valuable asset

Responsibilities:

• Build virtual data models using Synapse Serverless and harmonize schema differences across cluster.
• Create unified fact/dimension views for analytics and reporting Implement analytical semantic layers to support business intelligence and planning Integrate internal and external data sources, focusing on SQL Server and cloud-based platforms Use source control (Git) in collaborative software development environments.
• Participate in agile ceremonies (stand-ups, sprint planning, reviews, retrospectives).
• Collaborate with product owners, service designers, and other team members to deliver user-centered solutions.
• Ensure compliance with customer standards, policies, and security requirements.
• Document planned and unplanned changes, and support problem resolution as required by the Province.