Talent.com
Johnson Service Group
Intermediate Data EngineerJohnson Service Group • Edmonton, AB, CA
Intermediate Data Engineer

Intermediate Data Engineer

Johnson Service Group • Edmonton, AB, CA
1 day ago
Job type
  • Full-time
  • Quick Apply
Job description
Scope:
Modernization initiatives across the Government of Alberta are fundamentally changing how ministry users collect, manage, analyze, and use data as legacy systems are transformed into modern Data Management and Geospatial Platforms. This shift requires dedicated analytical capacity to ensure that the value of modernized data assets is fully realized.

DRAS is a Government of Alberta regulatory transformation initiative led by Environment and Protected Areas (EPA) to modernize, digitize, and streamline environmental and natural resource regulatory processes. DRAS supports the full regulatory lifecycle, from application and authorization to monitoring, compliance, remediation, and closure through a single, consolidated digital platform

As DRAS development continues, the volume, variety, and complexity of structured data continue to grow, creating a sustained need for dedicated data engineering and data product expertise. The Data Product Analyst role is critical to ensuring that modernization delivers tangible business value. This role will design, build, and operate reliable data pipelines that ingest and integrate data into the DMP, apply standardized transformations, enforce data quality and governance controls, and produce trusted, analytics ready datasets that support regulatory oversight, compliance monitoring, and evidence based decision making aligned with DRAS objectives.

This position will primarily support the Digital Regulatory Assurance System (DRAS) program, where high quality, timely analytics are essential to regulatory and compliance functions. As data and analytics maturity increases, the role may be expanded to support additional enterprise data initiatives.

Must Haves:
  • Post-Secondary degree, diploma or certificate in Computer Science or related field of study.
  • 1 year Use of AI-Experienced in using AI for code generation, data analysis, automation, and enhancing productivity in data engineering workflows.
  • 3 years 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.
  • 3 years 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
  • 2 years Experience in data governance, security, and metadata management within a Databricks-based platform.
  • 4 years Experience in Github/Git for version control, collaborative development, code management, and integration with data engineering workflows.
  • 3 years 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
  • 5 years 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 Haves:
  • 6 years Direct, hands-on experience performing business requirement analysis related to data manipulation/transformation, cleansing and wrangling.
  • 6 years Experience and strong technical knowledge of Microsoft SQL Server, including database design, optimization, and administration in enterprise environments.
  • 2 years Experience extending or integrating data solutions with Azure Synapse Analytics and Microsoft Fabric (Lakehouse, Warehouse, Semantic Models).
  • 1 year Direct experience building data products in Government of Alberta cloud environment
  • 2 years Experience building scalable ETL pipelines, data quality enforcement, and cloud integration using TALEND technologies.
  • 3 years Skilled in building secure, scalable RESTful APIs for data exchange, with robust auth, error handling, and support for real-time automation.
  • 5 years Experience working with cross-functional teams to create software applications and data products.
  • 1 year Experience working with ServiceNow- Azure based Data Management Platform Integrations.
  • 3 years Experience in Message Queueing Technologies, implementing message queuing using tools like ActiveMQ and Service Bus for scalable, asynchronous communication across distributed systems.

Responsibilities:
  • Design and implement scalable, secure, and high-performance data architecture on Microsoft Azure, supporting both cloud-native and hybrid environments.
  • Lead the development of data ingestion, transformation, and integration pipelines using Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.
  • Work with the Data Architect and manage data lakes and structured storage solutions using Azure Data Lake Storage Gen2, ensuring efficient access and governance.
  • Integrate data from diverse source systems including ServiceNow, and geospatial systems, using APIs, connectors, and custom scripts.
  • Develop and maintain robust data models and semantic layers to support operational reporting, analytics, and machine learning use cases.
  • Build and optimize data workflows using Python and SQL for data cleansing, enrichment, and advanced analytics within Azure Databricks.
  • Design and expose secure data services and APIs using Azure API Management for downstream systems.
  • Implement data governance practices, including metadata management, data classification, and lineage tracking.
  • Ensure compliance with privacy and regulatory standards (e.g., FOIP, GDPR) through role-based access controls, encryption, and data masking.
  • Monitor and troubleshoot data pipelines and integrations, ensuring reliability, scalability, and performance across the platform.
  • Utilize AI and automation tools to streamline data engineering workflows, including pipeline development, testing, monitoring, and documentation.
  • Leverage AI-assisted tools for code generation, optimization, and review to improve development efficiency and code quality.
  • Design and curate standardized, high quality datasets that are suitable for advanced analytics and future AI use cases.
  • Other duties as needed
#LI-KS1
Create a job alert for this search

Intermediate Data Engineer • Edmonton, AB, CA

Similar jobs

Data Engineer Role in Alberta’s Digital Division

PathlionEdmonton, Division No. 11, CA
Full-time

Be part of Alberta's digital transformation as a Data Engineer.Contribute to innovative projects by creating data pipelines and deriving insights that meet the needs of citizens.As a core member of... Show more

 • Promoted

Advanced Data Engineer for Large Datasets and ETL Pipelines

LumenaltaEdmonton, Division No. 11, CA
Full-time

Transform data into insights as an Advanced Data Engineer specializing in complex ETL pipelines.Embrace this remote opportunity to use your Python or Java and SQL skills effectively.This role invit... Show more

 • Promoted

Data Engineer

DS Technologies IncEdmonton, Division No. 11, CA
Full-time

Get AI-powered advice on this job and more exclusive features.About US: We are a company that provides innovative, transformative IT services and solutions.We are passionate about helping our clien... Show more

 • Promoted

Full-stack Data Engineer (Remote)

Chord StrategyEdmonton, Division No. 11, CA
Remote
Full-time

The Battle of Giants exists to answer a simple but important question:.Will a company’s strategy lead to growth?.We do this to help investors and corporate execs assess a company’s growth potential... Show more

 • Promoted

Data Engineer III - UGX (temporary)

Electronic Arts (EA)edmonton, division no. 11, Canada
Full-time

Electronic Arts creates next-level entertainment experiences that inspire players and fans around the world.Here, everyone is part of the story.Part of a community that connects across the globe.A ... Show more

 • Promoted

Senior Data Engineer - Data Governance & Platform Lead

XsollaEdmonton, Division No. 11, CA
Full-time

A global commerce company in Canada is seeking a Data Engineer to lead efforts in building and optimizing the User Platform and Recommendation Engine.The role involves ensuring data accuracy and pe... Show more

 • Promoted

Data Engineer – Remote-First ELT Pipelines & ML APIs

BorrowellEdmonton, Division No. 11, CA
Remote
Full-time

A financial technology company in Toronto is seeking a Data Engineer to build and maintain data infrastructure.You will create ELT pipelines, design data models, and collaborate with teams to deliv... Show more

 • Promoted

Oracle Data Warehouse Engineer | ETL & BI

StantecEdmonton, Division No. 11, CA
Full-time

A leading engineering firm is seeking a skilled data engineer to develop and maintain ETL processes and BI solutions.The ideal candidate will have extensive experience with Oracle Data Integrator a... Show more

 • Promoted

Senior Integrations Engineer: Cloud Data Pipelines

PlanHubEdmonton, Division No. 11, CA
Full-time

A leading pre-construction SaaS platform is looking for a developer to design and maintain cloud-native systems.The ideal candidate will have expertise in AWS services and experience building robus... Show more

 • Promoted

Senior Information Architect /Data Engineer (Remote Initially)

My RecruiterEdmonton, Division No. 11, CA
Remote
Full-time

Senior Information Architect /Data Engineer (Remote Initially).Job Openings Senior Information Architect /Data Engineer (Remote Initially).About the job Senior Information Architect /Data Engineer ... Show more

 • Promoted

Remote Data Engineer Role at HIVERY

HiveryEdmonton, Division No. 11, CA
Remote
Full-time

Enhance your career as a Data Engineer with HIVERY, focusing on advanced AI tools in a remote setting.Your expertise in Python or Go will drive improvements in our retail solutions.HIVERY, a startu... Show more

 • Promoted

Senior Data Engineer — Remote Canada (Snowflake DW)

Infostrux Solutions Inc.Edmonton, Division No. 11, CA
Remote
Full-time

A leading data consultancy in Canada seeks a Senior Data Engineer to guide customers in building cloud-based data warehouses using Snowflake.The role involves data ingestion, transformation, and op... Show more

 • Promoted

Remote Staff Data Engineer Architecting Health Data

Synthesis HealthEdmonton, Division No. 11, CA
Remote
Full-time

Join a healthcare technology company as a Staff Data Engineer.In this remote role, you will optimize data architecture, mentor senior engineers, and solve complex data challenges.The position requi... Show more

 • Promoted

Lead Data Engineer Innovating Healthcare Data Architecture

Synthesis HealthEdmonton, Division No. 11, CA
Full-time

Drive data engineering excellence as a Staff Data Engineer and help transform healthcare data practices.Spearhead architecture optimizations and educate teams in a fully remote role.As a leader in ... Show more

 • Promoted

Senior Cloud Data Architect & Engineer (Remote)

My RecruiterEdmonton, Division No. 11, CA
Remote
Full-time

A leading recruitment agency is seeking a Senior Information Architect / Data Engineer for a remote position.The role involves leading the architecture of a cloud data platform, requiring extensive... Show more

 • Promoted

Azure Data Engineer: Fabric Pipelines & Data Models

Symbiotic GroupEdmonton, Division No. 11, CA
Full-time

A leading IT consulting firm is looking for an experienced Azure Data Engineer to build and manage a scalable data integration platform.The successful candidate will work on Microsoft Fabric to des... Show more

 • Promoted

Lead Full-Stack Data Engineer — ETL & Insights

Chord StrategyEdmonton, Division No. 11, CA
Full-time

A dynamic growth strategy consultancy in Metro Vancouver is seeking a Data Engineer to improve and maintain ETL processes.The ideal candidate is a leader comfortable with ambiguity and able to work... Show more

 • Promoted

Data Engineer

BorrowellEdmonton, Division No. 11, CA
Full-time

At Borrowell, we're on a mission to help Canadians feel confident about their money.We empower individuals to take control of their financial futures by providing the tools and insights needed to u... Show more

 • Promoted

Senior Data Engineer - Analytics Pipelines (Remote)

TapMangoEdmonton, Division No. 11, CA
Remote
Full-time

A data-focused SaaS company in Canada seeks a Data Engineer to develop robust ETL pipelines, transform chaotic data into insights, and design effective data warehouse schemas.The role requires 5+ y... Show more

 • Promoted

Senior Data Engineer - Cloud ETL & BigQuery Expert (Remote)

ShyftLabsEdmonton, Division No. 11, CA
Remote
Full-time

A growing data product company in Canada is looking for an experienced Data Engineer to join its dynamic team.The candidate will design and maintain scalable ETL pipelines, oversee data infrastruct... Show more