Business Intelligence & Data Analyst

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 Business Intelligence & Data Analyst is responsible for supporting the organization's data management, reporting, analytics, and business intelligence initiatives by transforming complex data into actionable insights that support operational efficiency and decision-making.

Working closely with leadership, business stakeholders, and technical teams, the Position develops and maintains reporting solutions, dashboards, data models, and documentation while ensuring data quality, integrity, security, privacy, and consistency across the organization. The role serves as a data custodian, working to establish and maintain standards for data governance, data management, data anonymization, privacy protection, and business intelligence practices.

Work Requirements

This posting is for one (1) full-time 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

- Develop a comprehensive understanding of the organization's data ecosystem, including data sources, database structures, business applications, reporting processes, data definitions, and data ownership.

- Utilize advanced Excel, SQL, and reporting tools to collect, analyze, validate, and interpret data from multiple systems and sources, including converting and migrating spreadsheet-based data into structured database environments.

- Design, develop, and maintain Power BI dashboards, reports, scorecards, and data visualizations that provide meaningful insights and support operational, tactical, and strategic decision-making.

- Collaborate closely with departments across the organization to gather business requirements, document reporting needs, and translate operational objectives into functional specifications, requirements documentation, user stories, and acceptance criteria.

- Serve as a data custodian by promoting data integrity, consistency, and governance standards while supporting cross-functional initiatives involving reporting, analytics, systems, and process improvement.

- Identify data inconsistencies, duplicate records, structural inefficiencies, and opportunities for optimization within databases, spreadsheets, applications, and reporting processes.

- Support the maintenance and ongoing enhancement of data models, database structures, and reporting environments while applying a foundational understanding of data architecture principles and best practices.

- Develop and maintain standard report templates, data definitions, business rules, technical documentation, user guides, and process documentation to support knowledge transfer and consistency across the organization.

- Support data migration, transformation, integration, and cleansing activities involving both structured and unstructured data to improve data quality and usability.

- Build, maintain, and monitor ETL processes, automations, and scheduled data workflows to improve reporting accuracy, efficiency, and scalability.

- Perform regular data audits, validation processes, reconciliation activities, and data quality assessments to ensure information accuracy, integrity, completeness, and compliance with established business rules and standards.

- Analyze datasets to identify trends, patterns, risks, and opportunities, and provide actionable recommendations that support organizational goals, business outcomes, and continuous improvement initiatives.

- Streamline and standardize data collection, reporting, and analytics processes by identifying efficiencies, reducing manual effort, and improving data accessibility across the organization.

- Monitor and troubleshoot reporting, dashboard, and data issues, investigating root causes and implementing appropriate corrective actions.

- Communicate findings effectively through reports, dashboards, presentations, and stakeholder discussions, providing regular updates on key performance indicators (KPIs), performance metrics, and business insights.

- Collaborate with technical resources and business stakeholders to support system enhancements, application development initiatives, and reporting requirements.

- Provide training, coaching, and ongoing support to internal users, including executives, managers, and frontline staff, on the effective use of dashboards, business intelligence tools, data visualizations, and analytics solutions.

- Support the adoption of data governance, data quality methodologies, and reporting standards by promoting best practices and fostering a culture of data-informed decision-making.

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

Qualifications

- Degree or diploma in Business Analytics, Computer Science, Information Systems, Data Analytics, Statistics, Mathematics, Business Administration, or a related discipline.

- Three (3) to five (5) years of experience in business intelligence, data analysis, reporting, database management, or a related field.

- Demonstrated experience developing dashboards, reports, and data visualizations using Power BI or similar business intelligence platforms.

- Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, data modelling, analysis, and reporting.

- Strong SQL skills with experience extracting, transforming, validating, and analyzing data from relational databases.

- Experience supporting data migration, integration, transformation, cleansing, and ETL processes.

- Working knowledge of database structures, data modelling, and data architecture principles.

- Experience gathering and documenting business requirements, creating user stories, acceptance criteria, process maps, and technical documentation.

- Knowledge of data governance, data quality methodologies, metadata management, and data stewardship practices.

- Experience conducting data audits, reconciliations, data validation, and quality assurance activities.

- Understanding of data privacy, confidentiality, information security principles, and data anonymization or de-identification techniques.

- Experience working with sensitive and confidential information while ensuring compliance with privacy legislation, organizational policies, and data governance requirements.

- Strong analytical, critical thinking, problem-solving, and decision-making skills.

- Excellent verbal and written communication skills with the ability to present technical concepts and data insights to technical and non-technical audiences.

- Strong organizational skills with the ability to manage multiple priorities and deadlines.

- Proven ability to build effective working relationships and collaborate with stakeholders across all levels of the organization.

- Experience providing training, coaching, and user support related to reporting tools, dashboards, and data analytics is considered an asset.

- Experience with Microsoft Azure, Microsoft Fabric, SharePoint, application integrations, or web-based reporting solutions is considered an asset.

- Professional certifications in Power BI, Microsoft Data Analytics, Azure Data Fundamentals, or related disciplines are considered an asset.

Core Competencies

At OpenCircle Contractors Association we strive to provide a workplace culture that aligns with our employees’ personal values. Core competencies for this role, to align well with our workplace culture, are:

- Agility

- Result-oriented

- Solution-based thinker

- Creative problem solving

- Self-motivation