Business Intelligence Specialist Senior

2iResourcing; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

This innovative firm is seeking a Senior Business Intelligence Specialist to leverage Power BI for impactful data solutions. In this role, you will extract, clean, and model data from various sources, creating intuitive reports that drive business decisions. Your expertise in SQL Server, M, and DAX will be crucial as you collaborate with cross-functional teams to deliver high-quality BI products. Join a dynamic environment that values your analytical skills and offers the flexibility of a hybrid work model. If you're passionate about data and eager to make a difference, this opportunity is perfect for you.

Qualifications

• Proven experience as a Business Intelligence Specialist or Power BI Developer.
• Strong skills in M, DAX, SQL Server, and data visualization.

Responsibilities

• Extract and load data into Power BI, ensuring high performance and maintainability.
• Collaborate with stakeholders to develop BI products and documentation.

Skills

Power BI

SQL Server

Data Modeling

Data Visualization

M Language

DAX

Data Analysis

Data Management

Collaboration

Communication Skills

Education

Bachelor's Degree in Computer Science or related field

Tools

Power Query

Microsoft Azure

Power Platform

Job description

RQ04181 - Business Intelligence Specialist Senior

Client: Ministry of Solicitor General

Period: 6 Months

Start Date: 2022-11-14

End Date: 2023-05-15

Location: Toronto

Working Hrs.: 7.25 Hrs. / day

Assignment Type: Hybrid - Candidate must come in to the office 3 days in office 2 days remote (is flexible).

MANDATORY REQUIREMENTS

1. Use Power Query to extract data from different data sources and choose a storage mode and connectivity type.
2. Profile, clean, and load data into Power BI.
3. Design data models that are intuitive, high-performing, and simple to maintain.
4. Create Power BI report designs and report formatting, including report navigation.
5. Examine, sort and present data using Power BI in a cohesive manner.
6. Connect Power BI reports to on-premise data sources.

Must have:

• Proven work experience as a Business Intelligence Specialist, Power BI Developer, or similar role.
• Demonstrated experience with M, DAX and Power Query.
• Proven experience with SQL Server and other database technologies.
• Proven, demonstratable experience in data modeling and data visualization; working with different data schemas and BI implementation methodologies.
• Knowledge of data analysis, data management.
• Demonstrated experience collaborating with Developers, Testers and Program Managers.

Criteria 1: Technical Skills: 60 points

1. Proven work experience as a Power BI Report Developer.
2. Demonstrated experience with M, DAX and Power Query.
3. Knowledge of Microsoft Azure ecosystem and the Power Platform.
4. Proven experience with SQL Server and Power BI Datasets.
5. Proven, demonstratable experience in data modeling and data visualizations for Power BI; working with different data schemas and BI implementation methodologies.
6. Knowledge of data analysis, data management.
7. Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products.
8. Demonstrated experience with performance tuning in Power BI including measures, relationships and visuals.
9. Demonstrated experience with data sources for Power BI including DirectQuery, Import and appropriate considerations and limitations.
10. Demonstrated experience with Power BI datasets.
11. Demonstrated experience with Power BI refresh.

Criteria 2: Documentation, Collaboration & Communication Skills: 40 points

1. Ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues, regarding project deliverables.
2. Proven experience in developing documentation.
3. Demonstrated experience collaborating with Developers, Testers and Program Managers.
4. Proven experience in producing diagrams, videos, and other visual content.
5. Experience analyzing customer feedback and responding to it to improve the customer experience.
6. Experience in bringing clarity to complex business challenges and conflicting articulation of business issues through techniques that result in common understanding of the issues, as well as agreement on business process requirements vs technology requirements to solve the issues.
7. Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Business Intelligence products.
8. Excellent verbal and written communication skills, interpersonal and negotiation skills.
9. Facilitation skills, interpersonal and consultative skills.
10. Stakeholder management skills. Demonstrated strong problem-solving and organizational skills.
11. A team player with a track record for meeting deadlines.
12. Working knowledge and experience developing reports for use by a wide spectrum of stakeholders.
13. Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar/spelling and terminology.
14. Demonstrated effective time management and organizational skills, including the ability to plan and prioritize workload, ensuring timelines are met and respond to demands of a dynamic environment.