Talent.com
Financial Services Regulatory Authority of Ontario
Senior Data EngineerFinancial Services Regulatory Authority of Ontario • Toronto, ON
Rechercher d'autres offres
Senior Data Engineer

Senior Data Engineer

Financial Services Regulatory Authority of Ontario • Toronto, ON
Il y a 4 heures
Salaire
86 379,00 $CA – 127 288,00 $CA par an
Type de contrat
  • Temps plein
Description de poste

Description

:

PURPOSE OF POSITION


Provides senior-level data-engineering expertise and technical leadership for the design, development and operation of FSRA’s enterprise data platform. Leads the planning and delivery of complex, cross-functional data initiatives and provides authoritative technical advice to management, Data Architects, business stakeholders and delivery partners on data-platform design, integration, governance, security and operational risks. In collaboration with Data Architects, Business Stakeholders, and delivery partners, contributes to a modern, governed data platform that enables regulatory reporting, analytics, and future AI initiatives.


KEY RESPONSIBILITIES


  • Leads the technical design of complex Microsoft Fabric solutions and provides senior-level recommendations on Lakehouse, Warehouse, OneLake, pipeline, semantic-model and integration architecture; provides technical leadership for the development and operation of the enterprise data platform.
  • Designs and develop scalable Microsoft Fabric solutions using OneLake, Lakehouse, Warehouse, Pipelines, Notebooks, and Dataflows Gen2.
  • Establishes and directs implementation of enterprise engineering patterns and standards for Medallion Architecture (Bronze, Silver, Gold) and Delta Lake best practices to deliver scalable, maintainable, and analytics-ready data solutions.
  • Evaluates solution options, identifies enterprise impacts and risks, and recommends technical approaches to management and architecture governance bodies.
  • Build and maintain reliable, scalable enterprise ETL/ELT pipelines and integrations using SQL, Python, PySpark, Fabric Data Factory, Azure Data Factory, SSIS, and Dataiku.
  • Integrate SQL Server, Dynamics 365, Dataverse, APIs, files, and other enterprise systems to deliver reliable, scalable data integrations.
  • Develop automated data-quality, validation, reconciliation, monitoring, and error-handling solutions that support reliable data processing and operational support.
  • Provides senior technical advice and leads implementation of governance, lineage, security and compliance controls by developing governed, analytics-ready data products.
  • Provides technical ownership and ensures the quality, reliability and operational readiness for curated datasets, Power BI Semantic Models, and reporting-ready data products that meet business and reporting needs.
  • Develop and maintain Power BI dashboards in collaboration with business and technical teams to support reporting and analytical needs.
  • Leads design and code reviews and provides technical direction and quality oversight in CI/CD deployment processes, and operational support activities, supported by documented deployment procedures and operational runbooks.
  • Serves as a senior data-engineering subject-matter expert and provides consultative advice to management and stakeholders on platform capabilities, solution options, delivery risks, data quality, security, governance and operational sustainability.
  • Translates complex technical issues into options, implications and recommendations to support management decisions and enterprise priorities.
  • Ensures solutions support regulatory reporting, business analytics and strategic priorities while meeting agreed performance, security, governance and service requirements.
  • Acts as technical lead for project teams and oversees the integration of work completed by internal resources and external service providers.
  • Creates and maintains technical documentation, source-to-target mappings, deployment procedures, and operational runbooks that support code reviews, CI/CD deployments, and ongoing operations; Establishes documentation and operational-readiness standards and ensures adherence across delivery teams.
  • Leads cross-functional technical delivery and coordinates work across internal and external teams with business and technical teams to deliver reliable, scalable, governed, and analytics-ready data solutions.

QUALIFICATIONS

Education and Experience


  • Postsecondary degree in computer science, software engineering, data engineering, information systems, or a related discipline, or an equivalent combination of education and relevant professional experience.
  • Microsoft Fabric ((DP-700 or DP-600) or Azure Data Engineering (DP-203) certification, an asset.
  • 7+ years of experience in Data Engineering, Data Integration, or Data Warehousing.
  • Hands-on experience with Microsoft Fabric or Azure Data Platforms
  • Strong knowledge of Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, Dataflows Gen2, Notebooks, and Delta Lake.
  • Experience with Dynamics 365, Dataverse, Power BI, and Power Platform.
  • Experience in financial services, government, or another regulated industry, an asset.

Knowledge and Skills


  • Strong knowledge of Microsoft Fabric, including OneLake, Lakehouse, Warehouse, Data Factory, Dataflows Gen2, Notebooks, and Delta Lake.
  • Strong knowledge of Power BI, including the development and management of semantic models.
  • Advanced SQL/T-SQL skills, including hands-on experience, with Python or PySpark.
  • Experience developing enterprise ETL/ELT pipelines and data integration solutions.
  • Strong understanding of dimensional modeling, star schemas, and analytics data structures.
  • Experience with SQL Server, SSIS, SSAS, Git, Azure DevOps, and CI/CD.
  • Strong analytical, troubleshooting/problem-solving skills with the ability to diagnose data-quality and technical issues, assess alternatives and recommend practical solutions.
  • Strong stakeholder-management and consultation skills with the ability to explain technical concepts clearly, gather requirements and work effectively with technical and non-technical partners.
  • Enterprise Microsoft Fabric implementation experience with Microsoft Fabric.
  • Microsoft Fabric ((DP-700 or DP-600) or Azure Data Engineering (DP-203) certification.
  • Experience migrating SSIS, Synapse, Azure Data Factory, or legacy data warehouses to Fabric.
  • Knowledge of Direct Lake, Semantic Models, OneLake Shortcuts, and Fabric Capacity Management.

Compensation Grade:

Grade 06-AMAPCEO

Compensation Range:

$86,379.00

-

$127,288.00

Bargaining Unit:

AMAPCEO

Job Code:

Job Code: 6A001F

Employment Type:

Regular

Scheduled Weekly Hours:

36.25

FSRA is committed to ensuring equity in employment. Our goal is to create a diverse, inclusive workforce that reflects the communities we serve and to ensure our services and communications are accessible to all individuals. Accommodation is available under the Ontario Human Rights Code.

NOTE: ONLY QUALIFIED CANDIDATES WILL BE CONSIDERED

Créer une alerte emploi pour cette recherche

Senior Data Engineer • Toronto, ON