Business Intelligence Analyst (Power BI)

Finney-Taylor Consulting Group Ltd.; Regina; On-site; CAD 70,000 - 90,000; Full time

Job summary

A consulting company based in Regina is seeking an experienced Business Intelligence Analyst to design and implement technology solutions and guide business units through the solution process. The candidate will need extensive experience in Power BI and should possess strong analytical, communication, and problem-solving skills. Knowledge of data architectural methodologies and familiarity with cloud services are essential for success in this role.

Qualifications

• At least 5 years of experience with Power BI.
• At least 8 years of experience with Business Intelligence & Analytics.
• Experience in the Energy industry is required.

Skills

Communicating and Presenting Effectively

Guiding Business Solutions

Designing and Implementing Technology Solutions

Applying Data Architectural Methodologies

Identifying and Mitigating Technical Risks

SQL Expertise

Power BI and Business Intelligence Tools

Cloud Expertise

Lakehouse Architecture and Delta Format

Insight into Reporting Needs

Data Analysis

Problem-Solving Skills

Reporting Integration and Visualization

Content and Data Management

Star Schema and Analytical Data Models

Compliance and Security Standards

Job description

Business Intelligence Analyst (Power BI)

Job Description : Our client is looking for a Business Intelligence in Regina, SK.

Must Have Primary Skills

• Communicating and Presenting Effectively: The Business Intelligence Analyst must be an expert communicator, capable of presenting complex information in a clear and tailored manner to various audiences.
• Guiding Business Solutions: The role involves working closely with the Business Units to guide them through the entire solutioning process, from initial concept to final delivery.
• Designing and Implementing Technology Solutions: The analyst will design and implement technology solutions that support SaskEnergy's digital transformation goals.
• Applying Data Architectural Methodologies: Experience with data architectural methodologies is essential to ensure the integrity and efficiency of data systems.
• Identifying and Mitigating Technical Risks: The analyst will identify potential technical risks and devise strategies to mitigate them, ensuring the success of projects.

Nice to Have Secondary Skills

• SQL Expertise: The ability to write and optimize SQL queries for data extraction and manipulation is crucial. Additionally, the analyst should be able to create and maintain reporting and SQL scripts.
• Power BI and Business Intelligence Tools: Extensive experience with Power BI and other business intelligence reporting environments is required. This includes strong knowledge of Power Query and DAX within the Power BI environment.
• Cloud Expertise: Proficiency in cloud services such as Power BI Service, Microsoft Azure, and Databricks is necessary.
• Lakehouse Architecture and Delta Format: Knowledge of Lakehouse architecture and Delta format is important for managing and analyzing large datasets.
• Insight into Reporting Needs: The analyst should provide insights into the changing reporting needs and requirements of the company and offer suggestions for technical solutions.
• Data Analysis: The ability to analyze complex datasets and derive meaningful insights is essential for making informed business decisions.
• Problem-Solving Skills: Strong logical and problem-solving skills are required to address data related challenges effectively.
• Reporting Integration and Visualization: The analyst will oversee the integration and visualization of data from legacy and on-premises systems to new solutions.
• Content and Data Management: Experience with content management and data management programs and governance is necessary.
• Star Schema and Analytical Data Models: Knowledge of star schema and analytical data models is important for structuring data efficiently.
• Compliance and Security Standards: Familiarity with the Personal Information Protection and Electronic Documents Act and industry security standards is required to ensure compliance and data security.

Skills

• Databases: at least 5 years of experience with Power BI; at least 8 years of experience with Business Intelligence & Analytics.

Industry experience required: Energy

Email to: [e-mail]