Business Intelligence & Data Architect

OpenCircle Contractors Association; Edmonton; In loco; CAD 110.000 - 150.000; Tempo pieno

Descrizione del lavoro

OpenCircle Contractors Association is seeking a Data & Business Intelligence Architect in Edmonton to lead data strategy, governance, and analytics initiatives. The role bridges business operations and technology, ensuring data integrity and scalable reporting across the organization.

The successful candidate will design enterprise data models, manage data warehouses, and implement BI solutions using Power BI and Azure-based platforms.

Competenze

• Bachelor's degree in a relevant data/IT field.
• 5–8 years in data architecture, BI, governance.
• Experience designing enterprise data models, data warehouses, BI platforms.
• Strong SQL and data integration, ETL.
• Extensive Power BI experience incl. dashboards and KPI reporting.
• Experience in data governance frameworks and privacy controls.
• Knowledge of data lineage, metadata, data quality, retention.
• Experience with Azure, Fabric, SQL Server, cloud analytics.
• Strong communication and stakeholder engagement.
• Ability to lead cross-functional data initiatives.

Mansioni

• Support the development and execution of the organization's data strategy, architecture, and governance framework.
• Assess, design, and maintain enterprise data models, database structures, data warehouses, integrations, and information architecture frameworks.
• Establish and maintain data governance, stewardship, privacy, security, classification, retention, lifecycle management, and access control standards.
• Develop and oversee data anonymization, de-identification, confidentiality, and secure data-sharing practices.
• Design and implement BI solutions including dashboards, KPI frameworks, reporting standards, and data visualization best practices.
• Partner with stakeholders to gather requirements, define metrics, and translate needs into scalable data and tech solutions.
• Oversee data quality, validation, auditing, migration, integration, transformation, and ETL processes.
• Develop and maintain data dictionaries, metadata repositories, glossaries, and data lineage docs.
• Evaluate systems, databases, reporting platforms, and technologies for performance and scalability.
• Forecast data storage, capacity, and BI requirements to support growth.
• Lead data-related projects with internal teams and vendors for reporting and digital transformation.
• Monitor and optimize costs for databases, cloud storage, and BI platforms.

Conoscenze

SQL

Data modelling

ETL

Data governance

Privacy & security

Power BI

Requirements gathering

Stakeholder engagement

Cross-functional leadership

Analytical thinking

Formazione

Bachelor's degree in Computer Science, Information Systems, Data Analytics, Data Science, Business Intelligence, Information Management, Software Engineering, or a related discipline

Strumenti

Microsoft Azure

Microsoft Fabric

Microsoft SQL Server

Cloud data platforms

Enterprise reporting

Descrizione del lavoro

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