Business Intelligence Analyst

Job Title: Business Intelligence Analyst
Job ID: 84544
Location: Regina, Saskatchewan 

Overview:
Our client in Regina, SK is looking for several Business Intelligence Analyst resources for an initial 15 month contract till March 31, 2027, reference SX7227, with the option for multiple renewals. This is an onsite role and the successful candidate(s) must be currently residing in the Regina area or be willing to relocate to the area for the duration of the contract.


What you will be doing:
Our client is seeking two (2) Business Intelligence Analyst Resources with a broad-based background of technical experience and deep technical expertise in data management principles, business intelligence tools, and data architectural methodologies. As a data-driven organization, our client leverages advanced analytics and business intelligence to enhance decision-making and drive operational excellence. The Business Intelligence Analyst role is pivotal in transforming data into actionable insights that support strategic objectives and digital transformation goals. The role involves designing and implementing technology solutions that enable the client 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. Business Intelligence Analysts 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. Business Intelligence Analysts are 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.

• 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 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

What you must have:

• 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 datarelated 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.

Thank you for your interest in this opportunity. If you are selected to move forward in the process, we will contact you directly. If you do not hear from us, we encourage you to continue visiting our website for other roles that may be a good fit.


For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com