Skills

Communication SQL CI/CD Analytics and Reporting git SQL Server Software Development Agile Analytics CI/CD Pipelines

Job Specifications

Role: Lean Warehouse Developer

Location: Remote

Duration: 12 months

Contract Role

Top 3 Skills:

Building virtual models with Synapse Serverless

Creating unified fact/dimension views across clusters

Harmonizing schema differences, and implementing the analytical semantic layer.

Working hrs. 8:15am - 4:30pm Alberta Time (MT)

Criminal Record Check needed

This role is responsible for implementing the data warehouse solution for business reporting purposes.

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

Key Responsibilities:

Build virtual data models using Synapse Serverless and harmonize schema differences across clusters
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

Required Qualifications:

Minimum 3 years: Building virtual data models with Synapse Serverless
Minimum 5 years: Creating unified fact/dimension views across clusters
Minimum 3 years: Harmonizing schema differences and implementing analytical semantic layers
Minimum 2 years: Using Git for source control in collaborative environments
Minimum 1 year: Working with CI/CD pipelines
Experience in Agile development environments
Experience replacing systems of record (registries, banking, insurance, taxation, financial or billing systems) is a valuable asset
Strong communication and documentation skills
Ability to work independently and as part of a cross-functional team
Work Conditions Availability to work full-time during standard Alberta business hours (Monday to Friday, 8:154:30)

Ability to provide a current criminal record check upon request.

About the Company

The Corporate | Driving Innovation through Software Development At The Corporate, we are passionate about creating powerful software solutions that propel businesses into the future. Our team of skilled developers, designers, and technology experts work tirelessly to deliver custom software, web and mobile applications, and cloud solutions that enhance business performance and foster growth. We specialize in providing personalized solutions tailored to meet the unique needs of each client. Whether you're a startup, a growing... Know more