Business Intelligence Analyst for BC Energy Regulator enhancing BI tools and supporting data-driven decision making across the organization. Collaborating on data initiatives and training users in analytics.
Responsibilities
The Business Intelligence Analyst (Analyst) plays a critical role in enabling data-driven decision-making at the BCER by developing, maintaining, and enhancing Business Intelligence (BI) tools, dashboards, and reporting capabilities.
The role is responsible for extracting, integrating, and validating data from multiple sources, ensuring its accuracy and reliability, and supporting both operational and strategic needs across the organization.
The Analyst contributes to advanced analytics and Artificial Intelligence/Machine Learning (AI/ML) initiatives by preparing datasets, building prototypes, and collaborating with data science teams to deliver predictive insights.
In addition, the Analyst provides training and guidance to business users, promotes adoption of self-service analytics, and supports data governance, quality management, and integration efforts.
This role requires strong analytical skills, solid technical expertise in BI and data practices, and the ability to translate complex information into clear, actionable insights.
Requirements
A degree from a recognized post-secondary institution in a relevant field, such as Business Administration, Economics, Public Administration, or Computer Science, and a minimum of four years of relevant experience.
Demonstrated experience writing SQL queries to gather and analyze data from various data sources, including Relational Database Management Systems (e.g.: Oracle, Postgres, SQL Server).
Demonstrated experience working in an operational Business Intelligence (BI) environment, including data analysis and reporting, developing BI capabilities, and providing user support.
Demonstrated experience supporting advanced analytics or collaborating with data science teams.
Demonstrated experience with data modeling, Extract, Transform, Load (ETL) processes, database design, and metadata management.
Demonstrated experience conducting research, analysis, and preparing reports and presentations to communicate findings effectively.
Demonstrated experience in Agile project management and communicating complex technical concepts to varied audiences.
Demonstrated experience applying AI/ML techniques (e.g.: regression, classification) and exposure to predictive analytics or advanced modeling projects.
Demonstrated experience applying knowledge of data governance, quality management practices, and enterprise data standards.
Preference may be given to those with exposure to cloud data environments (e.g.: Azure), data virtualization, or orchestration tools.
Benefits
The BCER operates under a Hybrid Office Model whereby employees work from both a home office and a designated BCER office location in order to support our mandate (eligibility may vary, depending on position).
The BCER is proud to be an equal employment opportunity employer. We do not discriminate based on the protected grounds under the Human Rights Code. The BCER is committed to providing reasonable accommodations for the removal of barriers for qualified individuals. If you need assistance or accommodation, please let us know.
We acknowledge and respect the many First Nations, each with unique cultures, languages, legal traditions and relationships to the land and water, on whose territories the British Columbia Energy Regulator's work spans.
Senior BI Engineer building data models, semantic layers, and dashboards for Jobber’s small - business service platform. Driving governed self - service analytics and trusted business metrics.
Senior BI Data Engineer building data pipelines, warehouses, and reporting solutions for Trillium Health Partners hospitals. Leading Microsoft BI architecture, integration, and technical delivery.
Business intelligence consultant building Sage Intacct and Sage 300 CRE financial reports. Supporting accounting and operations teams with SQL - integrated, multi - entity reporting solutions.
Senior BI Developer designing SAP Datasphere data solutions for Aecon, an infrastructure construction company. Enabling SAP analytics, integration, governance, and secure enterprise data products.
Senior BI Analyst building Power BI dashboards and data solutions for TD, a global financial institution. Delivering actionable insights through SQL, Databricks, DAX, and Power Query.
Senior Data and BI Engineer building enterprise data lakes, pipelines, and real - time analytics platforms. Supporting utility software provider Systems & Software’s trusted customer insights and operations.
Data Analytics & BI Analyst building dashboards, models, and reporting for CoVet’s AI tools supporting veterinary professionals. Partnering across teams to improve business decisions and data quality.
Business Intelligence Analyst developing data products, dashboards and insights for the Government of Alberta. Supporting data strategy, governance and evidence - based decisions across departments.
Développeur BI chez BEEM, transformant les données d’entreprises en dashboards Power BI et solutions IA. Conception de semantic layers, SQL avancé et livraison de solutions data auprès des clients.