Senior Data Engineer

emergiTEL is hiring a Senior Data Engineer for our client in the public sector / government services industry. This is a 12-month contract role.

Duration: 12 months

Pay: $90/hr - $115/hr INC
Location: Edmonton Alberta Remote
Work Arrangement: Remote within Canada with occasional meetings/work sessions in Edmonton
Industry: Public Sector / Government Digital Services

Our client is seeking a Senior Data Engineer to support modern digital transformation initiatives. The successful candidate will work within multidisciplinary Agile teams to design develop and maintain modern data solutions that improve data quality accessibility analytics and decision-making.

The role combines data engineering cloud platforms data integration analytics reporting and data governance.

• Design build and maintain scalable data pipelines across on-premises and cloud environments.
• Develop data solutions using Azure Databricks Microsoft Fabric GCP and AWS.
• Develop and optimize ETL/ELT processes using SSIS Azure/Fabric Data Factory Dataflows and Notebooks.
• Build and maintain dimensional data models including star and snowflake schemas.
• Integrate data from relational databases NoSQL platforms APIs and files.
• Implement data validation error handling logging monitoring and scheduling.
• Optimize high-volume data processing and improve pipeline performance.
• Implement CI/CD practices for automated data pipeline deployment and operations.
• Support data lakes data warehouses security controls access management and data governance.
• Develop Power BI dashboards and reports using DAX.
• Analyze datasets to identify trends patterns and anomalies.
• Use Python and/or R for statistical analysis and predictive/descriptive modeling.
• Prepare curated data marts fact tables and dimension tables for analytics.
• Collaborate with architects developers business stakeholders and product teams.
• Present complex data findings in a clear and actionable manner.
• Support Agile delivery and mentor teams on analytics and data practices.

• Senior-level experience in Data Engineering.
• Strong experience with data pipelines and ETL/ELT.
• Experience with Azure Databricks Microsoft Fabric or similar cloud platforms.
• Strong SQL and data modeling skills.
• Experience with Azure Data Factory/Fabric Data Factory SSIS Dataflows or Notebooks.
• Strong understanding of data warehouses data lakes star/snowflake schemas fact and dimension tables.
• Strong Power BI and DAX experience.
• Experience with Python and/or R.
• Experience with CI/CD and automated deployment.
• Experience integrating APIs databases NoSQL platforms and files.
• Knowledge of data quality governance security and access management.
• Strong communication and stakeholder-management skills.
• Experience working in Agile/multidisciplinary environments.

• The position is remote within Canada.
• The resource may occasionally be required to attend meetings or work sessions in Edmonton Alberta with reasonable notice.
• Some travel within Alberta may be required for field research or user interviews.
• Work must be performed within Canada.