Help us improve RVC
We use optional analytics cookies to understand how RVC is used. Allow analytics also enables a fully masked diagnostic recording on public vacancy pages. It stops before Apply and excludes page text, form fields, console, and network contents. We do not use advertising cookies. Cookie policy
RVC
JobsFor Employers
Use AILog in
  1. Jobs
  2. /
  3. Senior Data Engineer

Senior Data Engineer

FSRA | Financial services regulation
1h 23m ago
On-site
Full Time
IC
Canada
86.3k - 127.2k CAD/yr≈ $60.4k - $89.1k USD/yr

At FSRA, our vision is to ensure financial safety, fairness, and choice for Ontarians. As a financial services regulator, we’re passionate about protecting consumers. Our principles-based approach means we can quickly and effectively respond to the changing needs of consumers and the industry.

Our team combines industry expertise with commitment to public service. We attract individuals who are interested in meaningful work and who measure success through outcomes, not inputs.

At FSRA, we invest in the personal and professional growth of our team.  We offer a competitive compensation package that includes an employer-matched defined benefit pension plan, and a comprehensive and competitive benefits plan. We prioritize learning and development, wellbeing, diversity, equity, inclusion and belonging, and community giving.

Join FSRA and help us shape the future of regulation for generations to come!

Job 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  

Required Skills

microsoft_fabricpower_biazuressispysparkpythonmssqldynamics

Required Languages

🇬🇧 English

Related searches

  • Jobs in Canada
  • Senior Jobs
1 jobs
Sort by
1h 23m ago

Senior Data Engineer

FSRA·Financial services regulation
86.3k - 127.2k CAD/yr≈ $60.4k - $89.1k USD/yr
microsoft_fabricpower_biazuressispyspark+3
On-site
|Canada
General Data Engineering
No similar jobs match these filters. Try changing or clearing a filter.
Popular job searches ▸
Roles
Python JobsJava JobsReact JobsTypeScript JobsGo JobsDevOps JobsNode.js JobsRemote C# and .NET JobsData Science JobsProduct Manager JobsDesign Jobs
Countries
United StatesUnited KingdomCanadaUS & EMEAGermanyPolandSpainNetherlandsPortugal
Experience
Senior JobsMid-Level JobsJunior Jobs
R© 2026 RVC Globalbuild 2a22a184
AboutJobs in Claude & ChatGPTPricingContactPrivacyCookiesRefundsTerms & ConditionsFor Employers