Location:Canada, RemoteSeniority:SeniorEstimated Duration:12 months with possible extension for another 6 monthsWork authorization:any (candidate must be authorized to work in CA)Job Title Senior Data ArchitectJob Summary We are seeking a senior Data Architect to lead the data strategy for a high-impact legacy system replacement within the Alberta Public Sector. This critical role ensures that the transition from a legacy trust administration system to a modern Microsoft Dynamics (CRM & Finance) ecosystem meets all strategic, security, and technical objectives.ResponsibilitiesLead solution architecture and design on cloud and key data platforms. Ensure alignment with business requirementsLead design and governance of schemas, tables, relationships, security roles and data access patternsPromote data models and practices to reduce redundancyGuide platform/infrastructure teams to configure data platform services to meet solution requirements.Participate in planning on implementation strategy, technology stack, design patterns and processAdvise on configuration vs customization to support long term sustainabilityReview/approve vendor delivered data designs, strategies and implementationsAdvise and coach teams throughout project. Provide knowledge transferDefine end to end data architecture, including all integrated applications and systems; develop conceptual, logical and data models aligned with platform standards, enterprise data policies, including Dataverse data modelingEnsure architectural alignment across system modules, integrated applications, Power Platform components, Azure and downstream reporting environmentsEstablish data architecture principles and standards consistent with GoA architecture frameworksArchitect integrations between solution and external systems, including legacy platforms, document repositories, etcEnsure data exchanges meet security, privacy and auditability standardsWork with Microsoft Dynamics to design how data is organized, stored, integrated and managed across Dynamics 365 ecosystem and broader Microsoft cloud environment (Power Platform, Azure, Fabric)Work with Microsoft Dynamics’ Finance & Operations for managing financial dataData MigrationServe as GoA lead in data mapping from legacy platform to the new application, ensuring accurate lineage, transformations and alignment with new data modelsCollaborate with vendor to validate mapping logic, support build activities, and ensure mappings are technically feasibleWork with business areas to define/confirm data rules, resolve data gaps, and ensure mappings support functional, operational, and reporting needsLead data migration strategy. Define extraction, transformation, cleansing, and validation approaches aligned with business rules. Ensure data integrity, traceability, and reconciliation throughout migration activitiesSupport parallel-run and cutover strategies to minimize business disruptionData Lakehouse – Architecture & DesignDefine data warehouse/lakehouse approach and architecture and related requirementsDefine storage, archival and retrieval approach for legacy data and target data structures and storage solutions for new system data to ensure performance and long term maintainabilityUse Microsoft tools to create a modern data warehouse/lakehouse (e.g. Azure Services - Azure Data Lake Storage, Azure Synapse Analytics and Azure Databricks for big data processing, analytics, data warehousing)Design data mesh/lakehouse architectures using Microsoft Azure technology stack to unify data management and analytics.Data Quality & ReadinessDefine data quality standards, validation rules and acceptance criteria for migrated and operational dataSupport business validation activities, including sampling, reconciliation and exception managementEnsure data readiness across project stages (e.g. user acceptance testing, training, go-live)Identify and mitigate data-related risks earlyData Governance & ComplianceEnsure compliance with GoA policies - privacy, records management, data retention, access control, etcDefine and enforce data classification, retention schedules, and information lifecycle management within platform and integrated platformsCollaborate with security, privacy, records management teams to implement data governance practices/controls. Support audits, compliance reviews, architectural assurance processesReportingEnsure new solution and data architecture enable effective reporting/analytics, including in solution dashboards and Power BI reportsDefine data flows into reporting platforms and downstream analytics environmentsEnsure consistency between operational and analytical data modelsEnsure architecture security, enforcing data/reports are only accessible to certain individuals/groupsImplement anonymization, restricting access to sensitive data from certain individuals/groupsDelivery OversightOversight across Agile delivery cycles, ensuring data considerations are embedded early in design and backlog refinementParticipate in sprint planning, backlog grooming and design reviews from an architecture perspectiveIdentify dependencies, risks, constraints impacting timelines. Support realistic sequencing/release planning for data-related workDevelop project plans/schedules and estimates for data activities. Develop task lists and resource assignments to ensure completion of data activitiesVendor & Stakeholder CollaborationCollaborate/consult effectively with project stakeholders. Review vendor deliverables for compliance/qualityTranslate technical data concepts, risks, options and recommendations into clear, actionable guidance for business stakeholders. Provide strategic guidance. Support executive decision-makingDocument technical recommendationsRequirementsExperience as a Data Architect planning, designing, documenting and implementing enterprise data architectures for large complex cloud-based application development projects in an environment equivalent in size and complexity to the Government of Alberta.Experience designing solutions that enable complex reporting and analytics in Power BIExperience developing and presenting complex data concepts, recommendations and decisions in an easy-to-understand manner to non‑technical stakeholders and senior leadership.Experience developing conceptual, logical, and physical data models aligned with enterprise data policies including within Microsoft Dataverse.Experience implementing data management platforms/solutions and applying enterprise architecture principles, methods, standards, tools and best practices.Experience leading the definition of detailed data mapping and data migration activities for large enterprise implementations.Experience with data transformation and data orchestration techniquesExperience working with Microsoft Dynamics 365, including how data is managed across the Dynamics platform and in the Microsoft Cloud ecosystemCertification in The Open Group Architecture Framework (TOGAF).Active Azure certificates: AZ-305. Please attach to the bottom of the resumeExperience applying enterprise data architecture principles, methods, standards, tools and best practices.Experience as a Data Architect planning, designing, documenting and implementing enterprise data architectures for large complex cloud-based application development projects in an environment equivalent in size and complexity to the Government of Alberta.Experience defining data architecture for large/complex Financial enterprise solutions/systems.Experience developing and presenting complex data concepts, recommendations and decisions in an easy-to-understand manner to non‑technical stakeholders and senior leadershipExperience developing conceptual, logical, and physical data models aligned with enterprise data policies including within Microsoft Dataverse.Experience in Agile ProjectsExperience in performing security, threat and risk assessments including defining mitigations.Experience leading and coaching data and project teams through large-scale implementations including data readiness, data quality, data storage.Experience leading and designing data migration activities for large-scale implementations from legacy application to cloud in Azure.Experience with data transformation and data orchestration techniques and tools, including ETL/ELT, data quality and metadata managementExperience with enterprise business intelligence products such as Microsoft Power BIExperience with Microsoft tools to create a modern data warehouse (e.g. Azure Services such as Azure Data Lake Storage, Azure Synapse Analytics, and Azure Databricks, Microsoft Fabric for big data processing, analytics, and data warehousing)Experience working in or for the public sector.Experience working with implementing a SQL data warehouse.Experience working with Microsoft Dynamics 365, including how data is structured, stored, integrated and managed across the Dynamics platform and in the Microsoft Cloud ecosystem (Power Platform, Azure, Microsoft Fabric).Company Information Mindtris, a minority women-owned enterprise, is at the forefront of digital transformation, technology excellence, and business growth solutions. Specializing in talent mobilization and innovation, we are dedicated to enhancing customer experiences across diverse sectors such as Information Technology, Telecommunications, Healthcare, Engineering, and the Public sector. With a focus on deploying top-tier talent and fostering innovation, we empower businesses to thrive and excel in a rapidly evolving digital landscape, helping them reach new heights of success.EEO Statement Mindtris is committed to fostering workforce diversity and is proud to be an equal opportunity employer.#J-18808-Ljbffr