Business Intelligence & Data Analyst

About the Position

Business Intelligence & Data Analyst

OpenCircle Contractors Association is seeking a Business Intelligence & Data Analyst to join our Benefit Systems team in Edmonton, Alberta.

---

About the Company

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, we support people, strengthen businesses, and advance 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, we remain committed to supporting and growing the construction industry across Canada.

---

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.
• Design, develop, and maintain Power BI dashboards, reports, scorecards, and data visualizations that provide meaningful insights and support decision-making.
• Collaborate 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.
• 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.
• Develop and maintain standard report templates, data definitions, business rules, technical documentation, user guides, and process documentation.
• Support data migration, transformation, integration, and cleansing activities to improve data quality and usability.
• Build, maintain, and monitor ETL processes, automations, and scheduled data workflows.
• Perform regular data audits, validation processes, reconciliation activities, and data quality assessments.
• Analyze datasets to identify trends, patterns, risks, and opportunities, and provide actionable recommendations.
• Streamline and standardize data collection, reporting, and analytics processes.
• Monitor and troubleshoot reporting, dashboard, and data issues, investigating root causes and implementing corrective actions.
• Communicate findings effectively through reports, dashboards, presentations, and stakeholder discussions.
• Collaborate with technical resources and business stakeholders to support system enhancements and reporting requirements.
• Provide training, coaching, and ongoing support to internal users 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.

---

Requirements

• 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.

---

Nice to Have

• Experience with Microsoft Azure, Microsoft Fabric, SharePoint, application integrations, or web-based reporting solutions.
• Professional certifications in Power BI, Microsoft Data Analytics, Azure Data Fundamentals, or related disciplines.

---

We Offer

• Competitive salary
• Opportunity to work in a dynamic and supportive environment
• Professional development opportunities
• Comprehensive benefits package

---

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