Senior Data Engineer
- Temps plein
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