Skills

Communication SQL Problem-solving Architecture power bi Organization Azure Databricks Microsoft Azure DAX

Job Specifications

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

This position is 100% onsite, Monday to Friday 8am-5pm.

Role Description

We are seeking a Business Intelligence Analyst Resource with a broad-based background of technical experience and deep technical expertise in data management principles, business intelligence tools, and data architectural methodologies. The Business Intelligence Analyst role is pivotal in transforming data into actionable insights that support the organization’s strategic objectives and digital transformation goals. The role involves designing and implementing technology solutions that enable the organization 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 apply their expertise in Power BI, Power Query, DAX, and other business intelligence reporting environments to deliver tailored content and effective presentations. They work closely with the Business Units to guide them through the solutioning process and into final delivery, ensuring that the solutions meet the business needs of the organization. The skills required for the Business Intelligence Analyst role are broad and encompass technical disciplines

such as cloud expertise in Power BI Service, Microsoft Azure, and Databricks, as well as knowledge of Lakehouse architecture and Delta format. Strong logical and problem-solving skills are essential to address data-related challenges and derive meaningful insights from complex datasets.

Responsibilities

Must be an expert communicator, capable of presenting complex information in a clear and tailored manner to various audiences.
Working 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 organization’s digital transformation goals.
Experience with data architectural methodologies is essential to ensure the integrity and efficiency of data systems.
Identify potential technical risks and devise strategies to mitigate them, ensuring the success of projects.

Required Skills and Experience

Must have a minimum 10 years experience, within the last 15 years working with modern data management principles, in a Business Intelligence Analyst or similar role.
Must have a Degree or Diploma in Computer Science / Engineering, Data Sciences or a related discipline, or minimum 10 years related work experience.
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.
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.
Proficiency in cloud services such as Power BI Service, Microsoft Azure, and Databricks is necessary.
Knowledge of Lakehouse architecture and Delta format is important for managing and analyzing large datasets.
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.
Strong logical and problem-solving skills are required to address data related challenges effectively.
Oversee the integration and visualization of data from legacy and on-premises systems to new solutions.
Experience with content management and data management programs and governance is necessary.
Knowledge of star schema and analytical data models is important for structuring data efficiently.
Familiarity with the Personal Information Protection and Electronic Documents Act and industry security standards is required to ensure compliance and data security.
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 devise strategies to mitigate them, ensuring the success of projects.
Canadian, federal, provincial, municipal government or similar wok experience.

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

InSync Systems Inc. is a privately-owned bouti

About the Company

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. We provide expert contract personnel, formal augmentation outsourcing or assistance in strengthening IT departments and business units through managed service arrangements with the best talent in the industry. InSync applies the consulting skills of our management team, with o... Know more