Senior Data Architect guiding data architecture during regulatory platform development. Collaborating across teams for scalable, secure data solutions aligned with enterprise standards.
Responsibilities
Lead data architecture and data modelling efforts for regulatory platform solutions, collaborating with Product Owners, Solution Architects, and delivery teams to design scalable, secure, and high-performing systems aligned with enterprise standards and business objectives.
Translate business and system requirements into conceptual, logical, and physical data models supporting transactional, integration, and analytical workloads.
Collaborate with the Enterprise Data Modeller to align platform data models with enterprise business information models and oversee physical data model implementation.
Define and implement data architecture patterns supporting Entity Framework and database-as-code approaches, ensuring alignment between application domain models, APIs, and physical database design.
Partner with the Data Engineering Practice Lead and Data Engineering teams to enable seamless integration of regulatory platform data into the Databricks-based medallion architecture (Bronze and Silver layers), supporting governed and reusable data products for analytics, reporting, AI, and data sharing.
Design secure and performant data access mechanisms, including APIs, views, materialized views, and data-sharing patterns for internal and external consumers.
Provide architectural leadership and guidance to Data Architects, Solution Architects, and Data Engineers to ensure consistency, interoperability, reusability, and adherence to enterprise standards.
Support modernization initiatives including legacy system transformation, cloud migration, master/reference data alignment, and integration of operational and analytical platforms.
Establish and promote best practices for data architecture, modelling, governance, security, resiliency, metadata, and performance optimization.
Ensure solutions support regulatory traceability, auditability, lineage, governance, and compliance requirements.
Maintain architecture artifacts and documentation including data models, integration mappings, lineage, data flows, and architectural decision records.
Participate in solution and platform architecture reviews, contributing to technology selection, implementation strategy, and long-term evolution of enterprise data capabilities.
Requirements
Bachelor’s degree in Computer Science, Information Systems, or a related field.
7+ years of progressive experience in enterprise data architecture and engineering, data modelling, and solution design for large-scale custom application platforms.
Proven expertise designing conceptual, logical, and physical data models for operational, integration, and analytical systems.
Strong experience implementing Entity Framework and database-as-code approaches, including alignment between domain models, APIs, relational schemas, and application development practices.
Experience supporting modern software delivery practices including source control, pull request reviews, CI/CD pipelines, automated deployments, and Agile delivery models.
Hands-on experience designing and implementing cloud-based data platforms and medallion architecture patterns (Bronze, Silver, Gold), preferably using Databricks and Delta Lake technologies.
Experience enabling enterprise analytics, AI, reporting, and data-sharing capabilities through governed and scalable data hub architectures.
Strong expertise with relational and distributed data platforms, including Microsoft SQL Server, Databricks, and cloud-native data architecture patterns.
Strong SQL and data modelling capabilities, including experience with enterprise modelling tools such as IDERA ER/Studio or equivalent.
Experience with data integration, ETL/ELT pipelines, API-based integration, event-driven architectures, and data-sharing patterns.
Experience establishing enterprise data standards, metadata practices, naming conventions, lineage, and data governance processes.
Experience designing secure, scalable, resilient, and auditable data solutions within regulated industries such as government, energy, or oil and gas.
Strong leadership, communication, and stakeholder engagement skills, with the ability to guide cross-functional technical teams and align architecture decisions with business objectives.
Ability to balance strategic architecture planning with hands-on technical leadership in fast-paced and evolving delivery environments.
Benefits
Great benefits from your first day of work
Flexible Work Program - hybrid work and flexible hours
Hybrid work - employees may work remotely up to five days per calendar month, with a limit of two remote days per week.
Defined benefit pension plans
Flexible benefits program options, including Personal & Health spending account(s)
Data Engineering Developer building scalable Azure data pipelines for an agile tech development firm. Advising clients, implementing governance, and improving cloud data engineering standards.
Ingénieur(e) données concevant des pipelines et architectures analytiques Azure. Collaboration client et amélioration des standards de gouvernance, qualité et performance des données.
Junior Data Engineer building reliable ETL pipelines and data solutions for PLATO, Canada’s Indigenous - owned technology services company. Improving data quality, accessibility, governance, and pipeline performance.
Senior Data Engineer building scalable, AI - powered data infrastructure for CloudBlue, HostPapa’s cloud commerce platform. Developing real - time pipelines, APIs, and production analytics systems.
Senior Fabric Data Engineer modernizing enterprise data for Canadian IT consulting clients. Building Microsoft Fabric pipelines, curated datasets, security controls, and analytics - ready models.
Staff Data Engineer building scalable pipelines and lakehouse architecture for Sonatype, a software supply chain security company. Driving trusted analytics, ML, and business intelligence data with Databricks, Spark, and modern cloud technologies.
Senior Fabric Data Engineer modernizing learning - platform data for Cornerstone Galaxy. Building Microsoft Fabric pipelines, curated datasets, governance, and analytics - ready integrations.
GCP Data Platform Engineer maintaining and optimizing production data platforms for Innodata, a global data engineering and AI services company. Supporting Airflow pipelines, GCP infrastructure, reliability, and troubleshooting.
Senior Data Engineer building finance data pipelines and models for Instacart’s grocery delivery platform. Owning financial data infrastructure supporting accounting, billing, invoicing, and reporting.
Senior Data Architect modernizing Alberta justice data marts into an integrated enterprise data warehouse. Designing ETL, Power BI testing, data models, governance, and reporting architecture.