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 assetResponsibilities :
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.