RQ09934 - Business Intelligence Specialist - Senior

Client: Ministry of Public and Business Service Delivery and Procurement
Work Location:
21 college street,, Toronto, Ontario,
Onsite
Estimated Start Date:

Estimated End Date:

#Business Days:
250.00

Extension
:
250.00

Hours per day or Week:
7.25 hours per day

Security Level:
CRJMC

Must Have

• 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
• Create Power BI report designs and report formatting, including report navigation
• Examine, sort and present data using Power BI in a cohesive manner
• Connect Power BI reports to on-premise data sources
• At least 5 years of experience
• All roles procured are required to be cleared through the Contractor Security Clearance Process of the OPS.
• Security Clearance process, levels, roles etc. are subject to change without prior notice.
• Candidates may be required to undergo revised/new process (or levels) any time prior or during the term of the contract.

Description
Scope:
Responsibilities
Work with project teams to ensure a successful release of Business Intelligence reporting using Power BI. The resource(s) will be responsible for:

• 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 insights.
• 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 OPS 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

Skills And Knowledge

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

Experience And Skill Set Requirements
Criteria Ratings :
Criteria 1 Technical Skills – 60 Points

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

Criteria 2 Documentation, Collaboration & Communication Skills – 40 Points

• Documentation, Collaboration & Communication Skills
• Ability to partner with internal/external stakeholders and liaise with technical experts and non-technical colleagues, regarding project deliverables
• Proven experience in developing documentation
• Demonstrated experience collaborating with Developers, Testers and Program Managers
• Proven experience in producing diagrams, videos, and other visual content
• Experience analyzing customer feedback and responding to it to improve the customer experience
• Experience in bringing clarity to complex business challenges and conflicting articulation of business issues through techniques that result in a common understanding of the issues, as well as agreement business process requirements vs technology requirements to solve the issues.
• Experience in understanding, capturing, and analyzing complex and sometimes competing business requirements to develop Business Intelligence products
• Excellent verbal and written communication skills, interpersonal and negotiation skills
• Facilitation skills, Interpersonal and consultative skills
• Stakeholder management skills. Demonstrated strong problem-solving and organizational skills
• A team player with a track record for meeting deadlines.
• Working knowledge and experience developing reports for use by a wide spectrum of stakeholders
• 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

Note
This position is currently listed as
"Onsite"
; however, the Assignment under this request will provisionally be
"Hybrid"
, working 7.25 hours per calendar day, sometime between 8:00-5:00 PM (excluding lunch breaks) Monday to Friday inclusive, unless otherwise identified. These conditions are subject to change as the OPS reflects on its current situation. During the duration of the assignment you will be under the discretion of the Hiring Manager's requirements for the Project you are assigned to.

The start date is subject to change based on security clearances and contract signing timelines.

The VOR Master Service Agreement expires on April 5, 2027, with a six (6) month survival clause included for Statements of Work (SOWs) allowing them to continue until October 5th, 2027 (if operationally required), leaving some contracts with funding unassigned for fiscal

If the current statement of work expires on October 5th, 2027, the remaining funds can be used to exercise an option to extend the SOW beyond October 5, 2027, based on business case approvals. Such extensions will be allowable, only if the Master Service Agreement is extended beyond October 5, 2027, and be upon the same terms, conditions, and covenants contained in the SOW.

Eligibility and Application Steps
If you are enthusiastic about this exciting opportunity, we kindly request you to provide the following documents:

Without mandatory documents, we cannot submit a candidate.

• Updated Resume in word format (Mandatory)
• Skills Matrix and References (Mandatory)
• Expected hourly rate (Mandatory)
• Visa Status (Mandatory)
• LinkedIn ID (Mandatory)

Please only apply if you meet the qualifications mentioned above. Feel free to share with your network or tag someone who fits for this role
If you have any questions or need further clarification, feel free to call or text