Role overview

Data Engineer - Intermediate

Job ID: GOAPRDJP00000975

Rate: CAD 40 to 60 per our

Term: 6 Months + optional 6-months extension

Location: Work must be done within Canada (Primarily remote; occasional on‐site meetings in Edmonton with reasonable notice).

Job Summary

We are seeking an experienced Data Product Analyst / Azure Data Engineer to support a major Government of Alberta modernization initiative.

The role will primarily support the Digital Regulatory Assurance System (DRAS), which is modernizing environmental and natural resource regulatory processes. The successful candidate will design and maintain secure data pipelines, integrate data from multiple systems, and produce trusted datasets for reporting, compliance monitoring, analytics, and decision-making.

Responsibilities

Design secure and scalable data solutions in Microsoft Azure.
Build data pipelines using Azure Data Factory, Databricks, Synapse Analytics, and Data Lake Storage Gen2.
Integrate data from ServiceNow, geospatial systems, APIs, databases, and other sources.
Develop data models, semantic layers, and analytics-ready datasets.
Use Python and SQL for data cleansing, transformation, and enrichment.
Develop secure data services using Azure API Management.
Apply data governance, metadata, lineage, classification, and quality controls.
Implement privacy and security controls, including role-based access, encryption, and masking.
Monitor, troubleshoot, and optimize data pipelines.
Use AI-assisted tools to support coding, testing, monitoring, and documentation.
Maintain technical documentation and work with business and technical stakeholders.

Must have

Use of AI-Experienced in using AI for code generation, data analysis, automation, and enhancing productivity in data engineering workflows.
Experience building scalable data pipelines with Azure Databricks, Delta Lake, Workflows, Jobs, and Notebooks, plus cluster management. Extending solutions to Synapse Analytics and Microsoft Fabric is a plus.
Experience designing data solutions for analytics-ready, trusted datasets using tools like Power BI and Synapse, including semantic layers, data marts, and data products for self-service, data science, and reporting
Experience in data governance, security, and metadata management within a Databricks-based platform.
Experience in Github/Git for version control, collaborative development, code management, and integration with data engineering workflows.
Experience with Azure services (Storage, SQL, Synapse, networking) for scalable, secure solutions, and with authentication (Service Principals, Managed Identities) for secure access in pipelines and integrations
Experience in Python (including PySpark) and SQL, applied to developing, orchestrating, and optimizing enterprise-grade ETL/ELT workflows in a large-scale cloud environment.

Nice to Have

Direct, hands-on experience performing business requirement analysis related to data manipulation/transformation, cleansing and wrangling.
Experience and strong technical knowledge of Microsoft SQL Server, including database design, optimization, and administration in enterprise environments.
Experience extending or integrating data solutions with Azure Synapse Analytics and Microsoft Fabric (Lakehouse, Warehouse, Semantic Models).
Direct experience building data products in Government of Alberta cloud environment
Experience building scalable ETL pipelines, data quality enforcement, and cloud integration using TALEND technologies.
Skilled in building secure, scalable RESTful APIs for data exchange, with robust auth, error handling, and support for real-time automation.
Experience working with cross-functional teams to create software applications and data products.
Experience working with ServiceNow- Azure based Data Management Platform Integrations.
Experience in Message Queueing Technologies, implementing message queuing using tools like ActiveMQ and Service Bus for scalable, asynchronous communication across distributed systems.

Why Join

• Work on meaningful public-facing services used by thousands of Albertans.

• Highly collaborative, modern digital environment.

• Opportunity to influence large-scale service improvements across government.

How to Apply

Apply directly through the job board
Please include three professional references where similar work was performed.
List your most recent reference first.

Interested in more opportunities with us?

Visit our careers page: www.shabech.ca to browse current openings.

We thank all applicants for their interest. Only candidates selected for the next stage will be contacted.

Company DescriptionShabech Consulting specializes in Business and IT consulting, strategic staffing, and project management services. Our mission is to help organizations achieve efficiency, innovation, and measurable results by connecting them with exceptional talent and tailored solutions.

We take a collaborative approach to understanding each client’s unique challenges and delivering strategies that create real impact. Whether supporting complex digital projects, providing specialized resources, or optimizing operations, we are committed to excellence.

As a trusted partner across multiple industries, Shabech Consulting helps organizations turn strategy into action and achieve their goals with confidence.Company DescriptionShabech Consulting specializes in Business and IT consulting, strategic staffing, and project management services. Our mission is to help organizations achieve efficiency, innovation, and measurable results by connecting them with exceptional talent and tailored solutions.\r\n\r\nWe take a collaborative approach to understanding each client’s unique challenges and delivering strategies that create real impact. Whether supporting complex digital projects, providing specialized resources, or optimizing operations, we are committed to excellence.\r\n\r\nAs a trusted partner across multiple industries, Shabech Consulting helps organizations turn strategy into action and achieve their goals with confidence.