The Data and Information Architect is a senior technical role responsible for the design, governance, and delivery of corporate certified datasets within the corporate data platformThis role combines deep data modelling expertise with strong delivery ownership, ensuring that complex datasets, including but not limited to project cost, timesheets, accounts payable, and financial summaries, are accurate, performant, and usable for business reporting and analyticsThe Data and Information Architect serves as the primary point of accountability for data architecture decisions, dataset standards, and cross-functional data enablement across the organizationThis position sits at the intersection of technical architecture, data delivery, and business stakeholder enablement, and requires both a solid technical foundation and excellent collaboration skillsData Architecture & Modelling:Design, document, and maintain enterprise data models including star schema, fact/dimension structures, and normalized dataset architecturesLead transformation from denormalized to normalized/star schema designs to improve data platform performance and end-user usabilityDefine and maintain metadata, column naming conventions, mapping documents, and dataset structures for Orb datasets (e.G., Project Cost Detail, Time Sheet Posted Detail, Project Financial Summary By Period, Project Non Labour Cost Detail)Establish data filtering logic, global rules, and architectural standards to control dataset scope and platform performanceAuthor and maintain enterprise data governance documents including Database Naming Conventions and Objects Naming Conventions (maintained since 2020, updated through 2025)Data Product Ownership Curated Datasets:Own and drive the delivery of corporate datasetsPrioritize and sequence dataset deployments across pre-production, UAT, and production environmentsEnsure source to platform data accuracy and alignment with corporate reporting requirementsTechnical Leadership & Delivery Coordination:Create and manage Azure DevOps work items, QA tasks, sprint planning, and release activitiesCoordinate development, QA, and deployment across data engineers, analysts, and BI developersGuide the team on data fixes, release readiness, and testing prioritiesAct as a central point for resolving blockers and accelerating delivery across cross‐functional teamsParticipate actively in daily scrum ceremonies, sprint reviews, and delivery planningData Quality,



Validation & Issue Resolution:Guide the Data team to investigate and resolve data quality issues including mismatches, missing records, schema changes impacting pipelines, and large‐volume data failuresDrive sanity checks, validation strategies, and QA alignment across the teamEnsure production data accuracy and consistency for business reporting and analyticsRespond to and resolve production incidents, refresh failures, and stakeholder‐reported data issuesStakeholder Support & Data Enablement:Serve as the primary technical expert for business users seeking to understand dataset structure, column definitions, and correct usage of curated datasetsGuide stakeholders in selecting between raw and curated data layers based on their requirementsSupport integration requests from downstream applications by providing dataset scoping, documentation, and accessTranslate business requirements into actionable data architecture decisions and dataset deliverablesData Governance & Security:Implement and advise on enterprise data access controls, Row‐Level Security (RLS) models, and security rules applied via dimension tables and Power BI semantic layersManage dataset access provisioning for users and service accountsMaintain and evolve standardized security models, governance practices, and the Orb security toolkitDocumentation & Standards:Author and maintain enterprise‐wide technical documentation including database naming conventions, data architecture diagrams, and dataset mapping documentsDefine and enforce object naming conventions for databases, schemas, tables, views, columns, indexes, and foreign keys across the Orb platformEnsure documentation is kept current through active revision cyclesData Platform & Architecture:Microsoft Azure - Azure Data Factory (ADF), Azure Synapse Analytics, Azure Data LakeMicrosoft Fabric - Lakehouse, Data Warehouse, shortcuts, capacity planning, One Lake securityData Platform Concepts - medallion architecture (raw, integrated/ODS, curated layers), delta mode processingStar Schema/Dimensional Modelling - fact/dimension design, foreign key normalization, partition strategiesSQL Server/Azure SQL Database - schema design, views, stored procedures, indexes,



constraintsBusiness Intelligence & Reporting:Microsoft Power BI – semantic model design, Row‐Level Security (RLS), DAX, Direct Query, shared datasets, Power BI ServiceAzure Analysis Services – tabular models, semantic layersData Engineering & Integration:Azure Data Factory (ADF) – ETL/ELT pipelines, data flows, triggers, CI/CDProfisee – Master Data Management (MDM) tooling, data mastering workflowsDelta Lake – medallion architecture (bronze/silver/gold layers)Source‐to‐Raw (R2I) Mapping – data mapping, profiling, transformation rulesDevOps & Project Management:Azure DevOps – work item management, sprint planning, release pipelines, repository management, Git integrationData Governance & Modelling Tools:Profisee – MDM governance workflowsTOAD – database development and SQL queryingJSON – configuration files, rule‐based filtering logic in Power BICollaboration & Communication:Microsoft Teams – daily stand‐ups, cross‐functional coordination, stakeholder communicationsMicrosoft Outlook/M365 – enterprise communication and documentationDemonstrated experience delivering enterprise data platforms in a cloud‐based environment (Azure preferred). 15+ years of progressive experience in data architecture, data modelling, or a senior data analyst role. Proactive problem‐solving with a focus on data quality and accuracy. Proven track record of leading data governance and documentation initiatives. Strong organizational and delivery management skills. Excellent SQL skills and ability to design efficient views, joins, and indexing strategies. Member of the Canadian or Global Leadership Team: This position requires knowledge of a language other than French, namely English, as it involves collaboration with members of the Canadian or global leadership team located outside Québec. Bachelor's degree in computer science, Information Systems, Data Engineering, or a related technical field. Experience with financial and project management data domains (ERP systems such as Oracle EBS is a strong asset). Experience working in Agile/Scrum delivery environments with Azure DevOps. Bilingual (English/French). Strong expertise in dimensional modelling, star schema design, and database normalization. Ability to communicate technical concepts clearly to non‐technical business stakeholders. Deep understanding of ETL/ELT pipeline architecture and data lake medallion patterns. Master's degree is an asset. #J-18808-Ljbffr

📌 Data Information Architect (Toronto)
🏢 AtkinsRéalis
📍 Toronto