Business Intelligence Analyst

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

Job summary

A consulting firm in Canada is seeking a Business Intelligence Analyst specializing in Power BI to support energy sector clients. The successful candidate will communicate effectively, guide business solutions, and implement technology solutions essential for digital transformation. A strong foundation in data analysis, compliance, and security standards is required. This role presents the opportunity to influence reporting needs and develop insightful solutions within the organization.

Qualifications

• Expert communicator capable of tailoring information for various audiences.
• 5+ years of experience with Power BI; 8+ years in Business Intelligence & Analytics.
• Experience with data architectural methodologies to ensure data integrity.

Responsibilities

• Guide business units through the solutioning process.
• Design and implement technology solutions for digital transformation.
• Identify and mitigate technical risks for project success.

Skills

SQL Expertise

Power BI

Cloud Services

Data Analysis

Problem-Solving Skills

Tools

Power BI Service

Databricks

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]