Business Intelligence Analyst

Dasro Consulting Inc.; Regina; On-site; CAD 90,000 - 120,000; Full time

Job summary

A consulting firm is seeking a Business Intelligence Analyst in Regina, Canada. The ideal candidate will have at least 10 years of experience in data management, effective communication skills, and a strong background in SQL and Power BI. Responsibilities include guiding business solutions, designing technological implementations, and communicating complex information clearly. This is a contract position for a mid-senior level role, offering the opportunity to work on transformative data projects.

Qualifications

• Minimum 10 years experience in modern data management principles.
• Expert level communication for effective presentation of information.
• Experience in guiding stakeholders through solutioning process.

Responsibilities

• Communicate complex information effectively to various audiences.
• Work closely with Business Units to guide solutioning process.
• Design and implement technology solutions supporting digital transformation.

Skills

SQL Expertise

Power BI and Business Intelligence Tools

Cloud Expertise

Data Analysis

Problem-Solving Skills

Education

Degree or Diploma in Computer Science / Engineering, Data Sciences

Tools

Power BI

Microsoft Azure

Databricks

Job description

Location: On-site, Regina, Saskatchewan, Canada

Term: 14 months

Recruiting for: Dasro Consulting Inc.

Responsibilities

• Responsibilities are but not limited to: 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 the clients 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.

Must-Have Experience

• Candidate must have minimum 10 years experience, within the last 15 years in working with modern data management principles, in a Business Intelligence Analyst or similar role.
• Candidate must have a Degree or Diploma in Computer Science / Engineering, Data Sciences or a related discipline, or minimum 10 years related work experience.
• Expert level communication (ability to communicate and present effectively, create effective tailored content).
• Experience working closely with the stakeholders to guide them from start to finish through the solutioning process and into final delivery.
• Experience designing and implementing technology solutions that enable an organization to achieve its digital transformation goals.
• Experience with data architectural methodologies application.
• Experience in identifying potential technical risks and devising strategies to mitigate them, ensuring the success of projects.
• Canadian federal, provincial, municipal government or similar work experience.

Required Technical 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, including 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.

Education & Other Requirements

• Candidate must have a Degree or Diploma in Computer Science / Engineering, Data Sciences or a related discipline, or minimum 10 years related work experience.

Seniority level: Mid-Senior level

Employment type: Contract