Senior Business Intelligence (BI) Specialist

Senior Business Intelligence (BI) Specialist

On behalf of our client in the Government Services Sector, PROCOM is looking for a Senior Business Intelligence (BI) Specialist.

Senior Business Intelligence (BI) Specialist – Job Description

Work with project teams to ensure successful release of Business Intelligence reporting using Power BI

Use Power Query to extract data from different data sources and choose a storage mode and connectivity type

Profile, clean, and load data into Power BI

Design data models that are intuitive, high-performing, and simple to maintain

Use M and DAX language to create measures

Ensure high performance of Power Query data retrieval tasks

Create Power BI report designs and report formatting, including report navigation

Examine, sort and present data using Power BI in a cohesive manner

Leverage statistical summaries of data and facilitate export of data from Power BI when required

Apply and perform advanced analytics on reports for deeper and more meaningful data insight

Leverage workspaces in the Power BI service

Deploy Power BI artifacts to workspaces and enable sharing to users

Connect Power BI reports to on-premise data sources

Configure automatic refresh for Power BI datasets

Enable Row-level security

Understand the report users' needs and their requirements

Develop reports all the way into production

Work with the project team in completing all relevant and required documentation in alignment with standards

Deliverables : Create Power BI report(s), data models

Undertake special assignments / sub-projects as assigned

Conduct, assess, evaluate and document stakeholder interests and business needs

Ensure alignment and adherence to IT processes and standards

Support the testing team during system and UAT testing

Participate in Knowledge transfer

Senior Business Intelligence (BI) Specialist – Mandatory Skills

Proven experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards

Demonstrated experience with M, DAX and Power Query

Knowledge of Microsoft Azure ecosystem

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 and data management

Proven ability to partner with internal / external stakeholders and liaise with technical experts and non-technical colleagues

Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products

Excellent verbal and written communication skills, interpersonal and facilitation skills

Strong written, presentation and interpersonal communication skills with special attention to correct use of tense, grammar / spelling and terminology

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

5+ years of experience

Senior Business Intelligence (BI) Specialist - Assignment Start Date

ASAP – 5 months to start

Senior Business Intelligence (BI) Specialist - Assignment Location

Toronto, ON – Work Hybrid