DataInformation Architect

Job Description

Overview

The Dataand InformationArchitect is a senior technical role responsible for the design governance and delivery ofcorporatecertifieddatasets within thecorporatedata platform. This role combines deep datamodellingexpertisewith strong delivery ownership ensuring that complex datasetsincludingbut not limited toproject cost timesheets accounts payable and financial summariesareaccurate performant and usable for business reporting and analytics. The Dataand InformationArchitect serves as the primary point of accountability for data architecture decisions dataset standards and cross-functional data enablement across the organization.

This position sits at the intersection of technical architecture data delivery and business stakeholder enablement and requires both a strong technical foundation and excellent collaboration skills.

Your role

Data Architecture &Modelling:

• Design document andmaintainenterprise data models including star schema fact/dimension structures and normalized dataset architectures.
• Lead transformation from denormalized to normalized/star schema designs to improve data platform performance and end-user usability.
• Define andmaintainmetadata column naming conventions mapping documents and dataset structures for Orb datasets (e.g. Project Cost DetailTime Sheet Posted DetailProject Financial Summary By PeriodProject Non Labour Cost Detail).
• Establish data filtering logic global rules and architectural standards to control dataset scope and platform performance.
• Author andmaintainenterprise data governance documents including Database Naming Conventions and Objects Naming Conventions (maintainedsince 2020 updated through 2025).

Data Product OwnershipCuratedDatasets:

• Own and drive the delivery ofcorporatedatasets.
• Prioritize and sequence dataset deployments across pre-production UAT and production environments.
• Ensuresource to platformdata accuracy and alignment withcorporatereporting requirements.

Technical Leadership & Delivery Coordination:

• Create and manage Azure DevOps work items QA tasks sprint planning and release activities.
• Coordinate development QA and deployment across data engineers analysts and BI developers.
• Guide the team on data fixes release readiness and testing priorities.
• Act asa central pointfor resolving blockers and accelerating delivery across cross-functional teams.
• Participate actively in daily scrum ceremonies sprint reviews and delivery planning.

Data Quality Validation & Issue Resolution:

• Guide the Data team to investigate and resolve data quality issues including mismatches missing records schema changesimpactingpipelines and large-volume data failures.
• Drive sanity checks validation strategies and QA alignment across the team.
• Ensure production data accuracy and consistency for business reporting and analytics.
• Respond to and resolve production incidents refresh failures and stakeholder-reported data issues.

Stakeholder Support & Data Enablement:

• Serve as the primary technical expert for business usersseekingto understand dataset structure column definitions and correct usage ofcurateddatasets.
• Guidestakeholders in selecting between raw and curated data layers based on their requirements.
• Support integration requests from downstream applications by providing dataset scoping documentation and access.
• Translate business requirements into actionable data architecture decisions and dataset deliverables.

Data 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 layers.
• Manage dataset access provisioning for users and service accounts.
• Maintain and evolve standardized security models governance practices and the Orb security toolkit.

Documentation & Standards:

• Author andmaintainenterprise-wide technical documentation including database naming conventions data architecture diagrams and dataset mapping documents.
• Define and enforce object naming conventions for databases schemas tables views columns indexes and foreign keys across the Orb platform.
• Ensure documentation is kept current through active revision cycles.

Data Platform & Architecture:

• Microsoft Azure- Azure Data Factory (ADF) Azure Synapse Analytics Azure Data Lake.
• Microsoft Fabric- Lakehouse Data Warehouse shortcuts capacity planningOne Lakesecurity.
• Data PlatformConcepts-medallion architecture(raw integrated/ODS curated layers) delta mode processing.
• Star Schema/DimensionalModelling- fact/dimension design foreign key normalization partition strategies.
• SQL Server/Azure SQL Database- schema design views stored procedures indexes constraints.

Business Intelligence & Reporting:

• Microsoft Power BI semantic model design Row-Level Security (RLS) DAX Direct Query shared datasets Power BI Service.
• Azure Analysis Services tabular models semantic layers.

Data Engineering & Integration:

• Azure Data Factory (ADF) ETL/ELT pipelines data flows triggers CI/CD.
• Profisee Master Data Management (MDM) tooling data mastering workflows.
• Delta Lake medallion architecture (bronze/silver/gold layers).
• Source-to-Raw (R2I) Mapping data mapping profiling transformation rules.

DevOps & Project Management:

• Azure DevOps work item management sprint planning release pipelines repository management Git integration.

Data Governance &ModellingTools:

• Profisee MDM governance workflows.
• TOAD database development and SQL querying.
• JSON configuration files rule-based filtering logic in Power BI.

Collaboration & Communication:

• Microsoft Teams daily stand-ups cross-functional coordination stakeholder communications.
• Microsoft Outlook/M365 enterprise communication and documentation.

About you

• Bachelors degree in computer science Information Systems Data Engineering or a related technical field.
• Mastersdegree is an asset.
• 15 years of progressive experience in data architecture datamodelling or a senior data analyst role.
• Demonstrated experience delivering enterprise data platforms in a cloud-based environment (Azure preferred).
• Experience with financial and project management data domains (ERP systems such as Oracle EBSisa strong asset).
• Experience working in Agile/Scrum delivery environments with Azure DevOps.
• Proventrack recordof leading data governance and documentation initiatives.
• Strongexpertisein dimensionalmodelling star schema design and database normalization.
• Deep understanding of ETL/ELT pipeline architecture and data lake medallion patterns.
• Ability to communicate technical concepts clearly to non-technical business stakeholders.
• Excellent SQL skills and ability to design efficient views joins and indexing strategies.
• Proactive problem-solving with a focus on data quality and accuracy.
• Strong organizational and delivery management skills.
• Bilingual (English/French) *
• * 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.

Rewards & benefits

Explore the rewards and benefits that help you thrive at every stage of your life and your career at AtkinsRéalis in Canada.

Enjoy competitive compensation employee recognition and a brilliant range of flexible benefits you can tailor to your health wellbeing financial and lifestyle needs.

Make the most of diverse opportunities for training and professional development to grow your skills and expertise.

And take advantage of our hybrid working culture and generous time-off policies to balance a fulfilling career with your personal life.

Be rewarded. Find out more.

About AtkinsRéalis

Were AtkinsRéalis a world-class engineering services and nuclear organization. We connect people data and technology to transform the worlds infrastructure and energy systems. Together with our industry partners and clients and our global team of consultants designers engineers and project managers we can change the world. Were committed to leading our clients across our various end markets to engineer a better future for our planet and its people.

Find out more.

Additional information

AtkinsRéalis cares about your privacy. AtkinsRéalis and other subsidiary or affiliated companies of AtkinsRéalis (referred to throughout as AtkinsRéalis) are committed to protecting your privacy. Please consult ourPrivacy Noticeon our Careers site to know more about how we collect use and transfer your Personal Data.

By submitting your personal information to AtkinsRéalis you confirm that you have read and accept our Privacy Notice.

Appropriate accommodation will be provided upon request throughout the recruitment and hiring process as required by Company policy and the Accessibility for Ontarians with Disabilities Act (AODA).

Successful applicants will be notified about AtkinsRéalis accommodation policies at the time the employment offer is extended and the information will be shared with new personnel during the onboarding process.

Expected compensation for this role is (between Pay Range $110000 - $150 000 annually) (Only Applicable to Ontario). Base salaries are determined according to several parameters like skills experience and potential impact on the role. Internal and external competitiveness are also taken into account in our offers.

Worker Type

Job Type

At AtkinsRéalis we seek to hire individuals with diverse characteristics backgrounds and perspectives. We strongly believe that world-class talent makes no distinctions based on gender ethnic or national origin sexual identity and orientation age religion or disability but enriches itself through these differences.