Business Intelligence Analyst

Rocky View County values our employees and provides a welcoming and stable work environment where positive energy, creativity, and a service mindset are encouraged. We seek individuals who enjoy making a difference and contributing meaningfully to a vibrant community. Our valued and diverse team of 500+ employees are provided with the same concern, respect, and caring attitude as the 45,000 people who call Rocky View County home.

At Rocky View County we value employee work/life balance. Staff are provided with opportunities to grow professionally while being supported with paid training, a competitive salary, benefits after 30 days, 27 paid days off in their first year, plus general holidays, a pension plan, paid sick time, and a hybrid work environment for eligible positions.

Position Summary

The Business Intelligence Analyst is responsible for transforming data into actionable insights to support business decision-making. This role involves designing, developing, and maintaining BI solutions, including dashboards, reports, and data visualizations. The BI Analyst collaborates with stakeholders to gather requirements, analyze data trends, and provide recommendations to drive operational efficiency and strategic initiatives. Key skills include proficiency in BI tools (e.g., Power BI, Tableau), SQL, data modeling, and strong analytical and communication skills. Experience with data warehousing and ETL processes is a plus. As part of the Information Management team, this role supports the County's emerging information management and data governance programs and aligns analytics with the transition to SharePoint Online (SPO) as the core ECM/EDRMS by promoting sustainable, governed data sources for reporting.

Core Accountabilities

• Lead the design, development, and implementation of BI tools, dashboards, and reporting solutions to meet business needs.
• Analyze data to identify trends, patterns, and insights, providing actionable recommendations to inform decision-making.
• Ensure alignment between stakeholders by understanding business needs and translating them into data requirements.
• Design and produce regular and ad-hoc reports, dashboards, and visualizations to communicate data-driven insights effectively to various audiences.
• Cleanse, manipulate, and transform data through programming/scripting to ensure accuracy and usability for analysis and reporting.
• Break down complex business problems, analyze data, and provide subject-matter insights and recommendations.
• Document and maintain operational procedures and processes related to analytics and reporting.
• Collaborate with internal and external stakeholders to support the development and execution of strategic analytics and reporting initiatives.
• Recommend and implement solutions to improve data processes, reporting efficiency, and alignment with business goals.
• Attend and participate in inter-jurisdictional meetings and activities on an ad-hoc basis.
• Act in a professional and responsible manner to protect the integrity of employees and the business of Rocky View County.
• Display a professional and ethical responsibility to protect privacy, use information appropriately, and maintain the confidentiality and security of all information related to employees, business and residents of Rocky View County.
• Work in accordance with the requirements established by the RVC Health and Safety Program and the Alberta OHS Act, Regulation and Code.
• Take reasonable care to protect their health and safety and other persons at or in the vicinity of the worksite while they are working.
• Support the County's Data Governance program by operationalizing emerging policies and standards within analytics solutions; maintain business definitions, data lineage, and basic data quality checks for assigned datasets.
• Recommend practical modernization steps aligned to SharePoint Online (SPO) (e.g. where appropriate, convert Excel workbooks to governed SPO Lists/Libraries to improve sustainability, discoverability, and Power BI readiness).
• Collaborate closely with the Information Management (IM) team and data stewards to align analytics deliverables with records, privacy (ATIA/POPA), and access practices while the programs mature.
• Perform other duties and special projects as assigned.
• This position is eligible for hybrid work.

Position Requirements

Completion of Bachelor's degree in Computer Science, Data Science, Information Systems, Business Analytics, or a related field along with 3-5 years of experience in business intelligence, data analysis, or a similar role is required.

• Strong analytical mindset with the ability to interpret complex data to identify trends, patterns, and anomalies, and be able to recommend data-driven solutions that address strategic business problems and align with organizational objectives.
• Excellent communication and relationship building skills to engage with diverse cross-functional stakeholders, gather business requirements, deliver business-aligned solutions, and present data insights to technical and non-technical audiences.
• Proficiency with BI tools and analytics platforms and data visualization techniques (e.g., Power BI, Tableau, QlikView, SAP BusinessObjects). Relevant certifications in BI tools are considered an asset.
• Time management skills to handle multiple projects and deadlines and applying project management frameworks like Agile and Waterfall.
• Strong attention to detail to deliver documentation for maintaining processes, reports, and dashboards.
• Knowledge of data modeling and database design principles and experience with advanced analytics, machine learning, or predictive modeling is an asset.
• Experience with SQL for querying and manipulating data (extraction, transformation, and analysis).
• Familiarity with data warehousing concepts and ETL processes.
• Experience with programming/scripting languages (e.g., Python, R) for data manipulation and analysis is an asset.
• Understanding of cloud-based data platforms (e.g., AWS, Azure, Google BigQuery) is an asset.
• Adaptability and willingness to learn new tools and technologies.
• Experience supporting emerging Data Governance and Information Management programs (e.g. stewardship, business glossary/definitions, data lineage, basic data quality rules) within Microsoft 365 is an asset.
• Working knowledge of SharePoint Online is sufficient to recognize modernization opportunities (lists/libraries, content types, permissions) and to partner with administrators; tenant-wide configuration or administration is not required.
• Familiarity with Alberta's Access to Information Act (ATIA), Protection of Privacy Act (POPA), and records/information management principles (e.g., ISO 15489, ARMA principles) is an asset.

We thank applicants for their interest. Only those selected for an interview will be contacted.

Applications can be submitted online at

Closing Date: January 2, 2026 or until a suitable candidate is found.