Business Intelligence Analyst

Raise; Burnaby; Hybrid; CAD 129,000 - 156,000; Full time

Job summary

Raise is hiring a Business Intelligence Analyst in Vancouver, BC, on a 1-year contract with hybrid work. The role collaborates with Water Services and internal BI teams to create data visuals from large datasets using SQL and Power BI.

The position emphasizes requirements gathering, standards, and documentation, with an estimated 600 project hours per year. Initial term is one year, subject to budget and project needs; hybrid in-office plus remote work.

Qualifications

• Design, build, and deploy BI solutions such as reports and dashboards.
• 1
• Maintain and improve existing BI systems and pipelines.
• 1
• Strong SQL skills and experience with relational databases (SQL Server, Oracle).
• 1
• Experience with ETL, data modeling, and visualization.
• 1
• Experience with building data pipelines and ETL processes.
• 1
• Power BI expertise including Dataflows and Datamarts.
• 1
• Experience with Azure DevOps for project management preferred.
• 1

Responsibilities

• Translate business requirements into technical specifications.
• 1
• Create data visualizations by analyzing large datasets using SQL and Power Query.
• 1
• Develop reusable data analytics frameworks (data warehouse, data lake, ODS).
• 1
• Design data models and ensure Power BI reports are secure and scalable.
• 1
• Explore advanced Power BI features for analytics and automation.
• 1

Skills

SQL

Power BI

Data visualization

Data profiling

ETL

Data modeling

Azure DevOps

Python or R (plus)

Education

Bachelor's in Computer Science or related field

Tools

SQL Server

Oracle

Power BI

REST APIs

OLAP cubes

Dataflows / Datamarts

Azure DevOps

Microsoft Fabric

Job description

Business Intelligence Analyst

Pay Rate: $62-75/hour, depending on experience

Contract Length: 1 year

Location: Vancouver, British Columbia

Work Schedule arrangement: Hybrid

Raise is currently hiring a Business Intelligence Abalyst on behalf of our client. They’re expanding their team to meet growing needs, making this a unique opportunity to work with an industry leader. Our client, a partnership of 12 municipalities - one Electoral Area and one treaty First Nation. That collaboratively plans for and delivers regional-scale services with its core services being drinking water, wastewater treatment and solid waste management.

Note: The primary pay rate is based on T4 classification; however, we will also consider applications from candidates interested in an INC classification, where applicable.

Description

The Business Intelligence Analyst in this role will collaborate with the Water Services Team and the internal BI Project Team. This role involves creating data visualizations by analyzing large datasets using SQL and Power Query to extract and present valuable insights from multiple systems. Additionally, the successful candidate will also focus on requirements gathering, documentation, and standards development. This position is intended to support project-specific initiatives, with assignments offered as required based on project demand and resource requirements. This position requires participation in a hybrid work environment, combining remote work with regular in-office attendance.

The terms of this contract will be as follows:

The initial term of the contract is one year, subject to budget approval and project work availability, with the option to extend or terminate the contract as required. The position is expected to require approximately 600 hours of work annually, although actual hours may vary depending on project requirements and business needs.

Responsibilities

• Translating business requirements into technical specifications
• Data profiling
• Source data analysis with SQL or applicable tools
• Business Analysis
• Designing and developing the data analytics (data warehouse, data lake ODS, data modelling, Power BI security, Power BI workspace) reusable framework
• Designing data models based on technical specifications
• Exploring advanced Power BI features for analytics, including customized solutions such as Dataflows and Datamarts
• Designing and building data pipelines and ETL packages including:
• M Query
• Dax Language
• Power Query
• Dashboards and reports with Power BI Desktop
• Troubleshoot day-to-day data warehouse issues

Qualifications

• Design, build, and deploy BI solutions (e.g., reporting tools, dashboards)
• Maintain and improve existing BI systems
• Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle).
• Experience with on-premise data warehouse reusable framework design and implementation
• Experience with data modelling, analysis, and visualization
• Work with relational and non-relational databases to extract, transform, and load (ETL) data
• Experience with building data pipelines and ETL processes
• Extensive development experience with technologies including SQL Server, REST APIs, OLAP cubes, and BI analytics tools.
• Extensive analytic development experience with Power BI and preferably Microsoft Power Platform.
• Advanced Power BI Service configuration experience, including Power BI Dataflows and Datamarts.
• Experience in Power BI report development, reports automation with data source refresh configurations
• Experience with analyzing data source systems to identify data transformation needs
• Thorough knowledge of software development methods, practices and procedures
• Ability to prepare technical design and write technical specifications
• Experience using Azure DevOps to manage projects is preferred
• Experience with programming languages such as Python or R is a plus
• Experience with Microsoft Fabric for data integration, data warehousing, analytics, semantic modeling, and enterprise reporting solutions is considered a strong asset

Professional & Interpersonal Skills

• Establish and maintain effective working relationships with a variety of internal contacts
• Provide advice and assistance on matters related to the work
• Ability to document, analyze, and assess a variety of information; identify priorities and resources; and propose alternative business processes.
• Demonstrated experience reviewing, streamlining and standardizing technical and operational documentation.
• Ability to develop practical standards that promote consistency while remaining easy for teams to maintain.
• Ability to assist in the development of standards and perform other administrative tasks related to assigned work
• Ability to communicate effectively orally and in writing and to present proposals in non-technical language
• Perform assigned duties with minimal supervision, although direction will be given.
• Maintain confidentiality

Education and Certifications

Bachelor's in Computer Science or related field

Looking for meaningful work? We can help!

We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodation: https://raise.jobs/accommodations/

In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or any other Raise job posting (or have any other questions), please contact us at [phone] or [e-mail].

#WES

#LI-SC1