Senior Data Architect to enabling the ingestion, transformation, and delivery of business-consumable data as part of a decommissioning initiative for our p

Our public sector client is seeking a Senior Data Architect to enabling the ingestion, transformation, and delivery of business-consumable data as part of a decommissioning initiative

Candidates can be 100% remote in Canada (working CST)

Must-haves:

• 7+ years of experience as a Data Architect or Technical Architect with a focus on Data Pipelines, Data Warehousing, Data Lakes and Python
• Hands-on experience with Microsoft Fabric workloads (Data Factory, Lakehouse, Warehouse, Real Time Analytics, Semantic Models, Data Activator)
• Experience with OneLake and Lakehouse Architecture with the ability to design scalable medallion-style (bronze, silver, gold) data models.
• Experience with Power BI and semantic models, DAX fundamentals and performance tuning
• Experience in DevOps/DataOps and Git with experience in AzureDevOps deployment and CI/CD automation
• Fabric DP-700 (Microsoft Certified, Fabric Data Engineer Associate)

Strong Nice to haves:

• Excellent written and verbal communication skills
• Excellent Problem-solving skills
• Manage conflicting priorities
• Interact with all levels of staff and management SQL Skills (T-SQL) and KQL for real-time Analytics and log/event analytics

Responsibilities:

• The Technical Architect will be responsible for enabling the ingestion, transformation, and delivery of business-consumable data as part of the project decommissioning initiative.
• Enabling end-to-end data ingestion and transformation pipeline for project application data
• Delivering business-ready datasets to meet reporting and operational requirements post-application shutdown
• Supporting or establishing medallion data architecture (bronze silver gold layers)
• Mitigating risks associated with data usability and reporting readiness, which is identified as the highest risk area in the program
• Designs and delivers end-to-end data products in Microsoft Fabric using repeatable patterns that support key business flows.
• Builds and optimizes Fabric Data Factory pipelines and notebook-based, Spark Job based transformations to populate OneLake/Lakehouse and/or Warehouse layers and downstream data marts.
• Defines technical requirements and delivers solutions that meet service level agreements through efficient modeling, partitioning, caching, and query optimization across Fabric compute engines.
• Implements monitoring and observability for pipelines and models (refreshes, failures, data drift) and proactively resolves performance, reliability, and cost and/or capacity issues.
• Designs, integrates, and documents technical components (data contracts, lineage, definitions) for seamless data extraction, governance, and analysis.
• Presents insights on data and its quality via presentations, and visualizations.
• Defines and develops automation within Microsoft Fabric.
• Supports the corporation’s broader technical and operational requirements by adopting best practices in our data systems.