Data​/Information Architect

Job Description Overview

The Dataand Information Architect 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 datasets,including but not limited toproject cost, timesheets, accounts payable, and financial summaries,are accurate, performant, and usable for business reporting and analytics. The Dataand Information Architect 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.

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 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 performance.
• Author andmaintainenterprise 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 ofcorporatedatasets.
• Prioritize and sequence dataset deployments across pre-production, UAT, and production environments.
• Ensure source to platform data accuracy and alignment withcorporatereporting requirements.

Technical Leadership & Delivery Coordination:

• Create and manage Azure Dev Ops 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.

Stakeholder Support & Data Enablement:

• Serve as the primary technical expert for business usersseekingto understand dataset structure, column definitions, and correct usage ofcurateddatasets.
• Guide stakeholders 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…