Data Engineer - Senior JP992

Project Name:Digital Regulatory Assurance SystemScope:

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 requires seamless data integration across multiple legacy and modern platforms to create a trusted, unified source of information.

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 integration expertise. The Talend Integration Analyst designs, builds, operates, and supports data integration solutions on the Government of Alberta's Talend Integration Platform, to move, transform, and consolidate data across ministry systems, cloud services, and analytics environments, and operational systems.

This is a hands-on technical role for someone who combines strong Talend and SQL development skills with a disciplined, service-oriented approach to platform operations including job scheduling, monitoring, error handling, and incident resolution; while collaborating with data engineers, platform administrators, ministry stakeholders, and vendor support partners.

This position will primarily support the Digital Regulatory Assurance System (DRAS) program, the role may be expanded to support additional enterprise data initiatives.

Duties:

• Demonstrated hands-on experience developing data integration solutions with Talend (Data Integration / Data Fabric / Talend Studio)
• Strong SQL skills and experience working with relational databases (e.g., Oracle, SQL Server, PostgreSQL).
• Proven experience designing ETL/ELT processes, data mappings, and transformation logic for enterprise data.
• Experience operating and supporting integration a production environment, including scheduling, monitoring, and incident resolution.
• Translate business and data requirements into robust technical designs, applying data-mapping, transformation, and reconciliation logic
• Build parameterized, reusable, and context-aware jobs that promote cleanly across development, test, and production environments.
• Implement performance-tuned, scalable integration patterns for both batch and near-real-time data movement.
• 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., POPA) through role-based access controls, encryption, and data masking.
• Design, develop, and unit-test Talend integration jobs, routes, and reusable components to extract, transform, and load data between source systems, databases, files, APIs, and cloud storage
• Schedule, orchestrate, deploy, and monitor Talend jobs; proactively track execution, throughput, and failures.
• Provide day-to-day operational support including triage, troubleshooting, and resolve integration incidents and data-load failures within agreed service levels.
• 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.
• Other duties as needed