Business Intelligence & Data Architect

OpenCircle Contractors Association; Edmonton; On-site; CAD 110,000 - 150,000; Full time

Job summary

OpenCircle Contractors Association in Edmonton is seeking a Data & BI Architect to lead data strategy, governance, and analytics. The role translates business needs into scalable data models, dashboards, and reporting standards, bridging business and technology.

This is a six-month, full-time contract based in the Edmonton office. The candidate will drive data integrity, security, and governance while collaborating with stakeholders across the organization.

Qualifications

• Bachelor's degree in a relevant field.
• 5–8 years of progressive experience in data architecture, BI, or governance.
• Experience designing enterprise data models, data warehouses, and BI platforms.
• Strong SQL, data modeling, ETL, and data integration skills.
• Extensive experience with Power BI or similar BI platforms.
• Knowledge of data governance, privacy, and security best practices.
• Familiarity with Azure, SQL Server, and cloud analytics.
• Ability to translate business needs into scalable data solutions.

Responsibilities

• Support the data strategy, architecture, and governance framework.
• Design and maintain enterprise data models, databases, and data warehouses.
• Establish data governance, privacy, security, retention, and access standards.
• Develop data anonymization and secure data-sharing practices.
• Design and implement BI solutions, dashboards, KPI frameworks, and visualization standards.
• Collaborate with stakeholders to gather requirements and translate them into data solutions.
• Oversee ETL processes, data quality, validation, migration, and integration.
• Develop metadata, data dictionaries, and lineage documentation.
• Evaluate systems and technologies to improve performance and scalability.
• Forecast storage and BI needs for organizational growth.
• Lead data projects with internal teams and vendors.
• Monitor costs of databases, cloud storage, and licenses.
• Provide leadership and mentorship on data governance.

Skills

SQL

Power BI

Data Governance

Data Modeling

ETL/ELT

Azure / Cloud

Education

Bachelor's degree in Computer Science or related

Tools

Microsoft Azure

Microsoft Fabric

SQL Server

Cloud data platforms

Job description

Organization Summary

Founded in 1986, OpenCircle Contractors Association is a member-driven organization that champions open competition, free enterprise, and a merit-based approach within the construction industry. Representing more than 1,500 member companies and 50,000 employees, OpenCircle Contractors Association supports people, strengthen businesses, and advances the industry through advocacy, training and development opportunities, tuition reimbursements, post-secondary scholarships, and an industry-leading benefits plan. Built on a strong foundation and continuously evolving to meet the needs of our members, OpenCircle Contractors Association remains firmly committed to supporting and growing the construction industry across Canada.

Position Overview

Reporting to the Director, Benefit Systems, the Data & Business Intelligence Architect will play a key role in developing and maintaining the organization's data strategy, architecture, governance framework, and business intelligence environment. The Position will analyze existing spreadsheets, databases, applications, and reporting processes to design scalable data structures, establish governance standards, define security and access controls, and create reliable reporting and analytics solutions.

The Position serves as the bridge between business operations and technology by translating organizational requirements into data models, dashboards, user stories, reporting standards, and application development requirements. The Position is accountable for ensuring data integrity, data security, regulatory compliance, system scalability, and effective data management practices across the organization.

Work Requirements

This posting is for one (1) full-time, six (6) month contractual position based in the Edmonton office. The regular hours of work for this position is Monday to Friday, 8:00 a.m. to 4:30 p.m.

Job Responsibilities

• Support the development and execution of the organization's data strategy, architecture, and governance framework, ensuring alignment with business objectives, scalability requirements, and future data growth.
• Assess, design, and maintain enterprise data models, database structures, data warehouses, integrations, and information architecture frameworks that support operational efficiency, reporting, analytics, and application development.
• Establish and maintain data governance, stewardship, privacy, security, classification, retention, lifecycle management, and access control standards, ensuring compliance with applicable legislation, organizational policies, and industry best practices.
• Develop and oversee data anonymization, de-identification, confidentiality, and secure data-sharing practices to protect sensitive information while supporting reporting, analytics, testing, and business operations.
• Design and implement business intelligence solutions, including dashboards, scorecards, KPI frameworks, reporting standards, and data visualization best practices that support data-driven decision-making.
• Partner with business stakeholders to gather requirements, define metrics, develop user stories and technical specifications, and translate business needs into scalable data, reporting, and technology solutions.
• Oversee data quality, validation, auditing, migration, integration, transformation, and ETL processes to ensure the accuracy, consistency, integrity, and reliability of organizational data.
• Develop and maintain data dictionaries, metadata repositories, business glossaries, data lineage documentation, technical standards, and system documentation.
• Evaluate existing systems, databases, reporting platforms, and technologies, recommending improvements that enhance performance, usability, scalability, maintainability, and long-term sustainability.
• Forecast future data storage, capacity, reporting, infrastructure, and business intelligence requirements, developing strategies that support organizational growth and evolving business needs.
• Lead data-related projects and collaborate with internal stakeholders, technical teams, and vendors to support reporting initiatives, system enhancements, digital transformation projects, and application and web development efforts.
• Monitor and optimize database, cloud storage, software licensing, and analytics platform costs, while supporting technology procurement, vendor management, and business case development.
• Provide leadership, guidance, and mentorship to technical teams and promote a culture of data governance, privacy, accountability, innovation, and continuous improvement.

*Please note that as part of our recruitment process, we require each shortlisted candidate to participate in a criminal record check.*

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Data Science, Business Intelligence, Information Management, Software Engineering, or a related discipline.
• Five (5) to eight (8) years of progressive experience in data architecture, database management, business intelligence, analytics, data governance, or a related field.
• Demonstrated experience designing and implementing enterprise data models, database structures, data warehouses, business intelligence platforms, and reporting solutions.
• Strong expertise in SQL, relational database management systems, data modelling, data architecture principles, ETL processes, data integration, migration, and automation.
• Extensive experience with Power BI or similar business intelligence platforms, including dashboard development, KPI reporting, analytics, and data visualization.
• Experience developing and administering data governance frameworks, stewardship models, policies, standards, controls, and best practices.
• Strong understanding of privacy legislation, information security, cybersecurity principles, data classification, role-based security, confidentiality requirements, and secure data-sharing practices.
• Experience implementing data anonymization, de-identification, masking methodologies, and privacy-preserving techniques used to protect sensitive information while supporting reporting and analytics.
• Knowledge of master data management, metadata management, data lineage, data quality management, retention practices, lifecycle management, capacity planning, and scalable data growth strategies.
• Experience gathering business requirements, developing user stories and technical specifications, and translating business needs into technology solutions.
• Familiarity with Microsoft Azure, Microsoft Fabric, Microsoft SQL Server, cloud data platforms, analytics environments, and enterprise reporting technologies.
• Strong analytical, strategic thinking, problem-solving, project management, communication, and stakeholder engagement skills.
• Proven ability to lead cross-functional initiatives and collaborate effectively.
• Experience with vendor management, software procurement, budget planning, and technology cost optimization is considered an asset.
• Commitment to continuous learning and staying current with emerging technologies, data architecture, governance, privacy, and business intelligence best practices.

Core Competencies

At OpenCircle Contractors Association, we are committed to fostering a workplace culture that reflects and supports the values of our employees. To thrive in this role and contribute positively to our organizational culture, the following core competencies are key:

• Agility
• Result-oriented
• Solution-based thinker
• Creative problem solving
• Self-motivation