Senior Business Intelligence Analyst

InSync Systems; Regina; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading consulting company is seeking a Senior Business Intelligence Analyst for a 9-month contract in Regina. The ideal candidate will possess extensive experience in data management and business intelligence tools, particularly Power BI. Responsibilities include designing technology solutions to support digital transformation and ensuring data integrity. The role requires effective communication and collaboration with business units to deliver tailored solutions. This is an on-site position, emphasizing a commitment to operational excellence and compliance with industry standards.

Qualifications

• Minimum 10 years experience in Business Intelligence or similar role.
• Extensive experience with Power BI and data management.
• Proficiency in cloud services and SQL.

Responsibilities

• Design and implement technology solutions for digital transformation.
• Communicate complex information effectively to various audiences.
• Oversee data integration and visualization from legacy systems.

Skills

Data Management Principles

Business Intelligence

SQL

Power BI

Data Analysis

Communication

Education

Degree or Diploma in Computer Science

Degree or Diploma in Data Sciences

Tools

Power BI

Microsoft Azure

Databricks

Job description

We are looking for a Senior Business Intelligence Analyst for a 9-month contract position, with possible extensions in Regina, Saskatchewan. Must be legally entitled to work in Canada.

This position is available as on-site, 8 hours a day, 40 hours a week. The working hours are Monday - Friday, 8am-5pm. This is NOT a remote role.

Role Description

We are seeking a Business Intelligence Analyst with a broad-based background of technical experience and deep technical expertise in data management principles, business intelligence tools, and data architectural methodologies. The role involves designing and implementing technology solutions that enable the company to achieve its digital transformation goals. This includes the development and optimization of SQL queries for data extraction and manipulation, creating and maintaining reporting and SQL scripts, and providing insights into changing reporting needs and requirements.

The ideal candidate will be engaged in enterprise design and development, overseeing the reporting integration and visualization of data from legacy and on-premises systems to new solutions. Additionally, the role requires commitment to operational excellence in delivering customer-focused experiences, adherence to industry security standards, and compliance with the Personal Information Protection and Electronic Documents Act.

Responsibilities

• Communicate and present complex information effectively in a clear and tailored manner to various audiences.
• Work closely with the Business Units to guide them through the entire solutioning process, from initial concept to final delivery.
• Design and implement technology solutions that support the company’s digital transformation goals.
• Apply Data Architectural Methodologies to ensure the integrity and efficiency of data systems.
• Identify potential technical risks and devise strategies to mitigate them, ensuring the success of projects.
• The analyst will oversee the integration and visualization of data from legacy and on-premises systems to new solutions.

Required Skills and Experience

• 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
• Must have Degree or Diploma in Computer Science / Engineering, Data Sciences or a related discipline, or minimum 10 years related work experience
• Extensive experience with Power BI and other business intelligence reporting environments is required.
• Strong knowledge of Power Query and DAX within the Power BI environment.
• Proficiency in cloud services such as Power BI Service, Microsoft Azure, and Databricks is necessary.
• Knowledge of Lakehouse architecture and Delta format
• The analyst should provide insights into the changing reporting needs and requirements of the company and offer suggestions for technical solutions.
• The ability to analyze complex datasets and derive meaningful insights is essential for making informed business decisions.
• Content Management and Data Management Programs and Governance experience
• Knowledge of star schema and analytical data models
• Familiarity with the Personal Information Protection and Electronic Documents Act and industry security standards is required to ensure compliance and data security.
• 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 risks and devise strategies to mitigate them, ensuring the success of projects.
• Previous experience in Canadian, federal, provincial, municipal or similar work
• Ability to write and optimize SQL queries for data extraction and manipulation
• Create and maintain reporting and SQL scripts

Please note that while all applications are appreciated, only candidates selected for interview will be contacted.

InSync Systems Inc. is a privately-owned boutique Canadian Resourcing and Consulting Services Company that works closely with a range of corporate clients across multiple industries to bring them solutions that effectively address their business needs.