drjobs Business Intelligence Specialist 0186-1616

Business Intelligence Specialist 0186-1616

Employer Active

drjobs

Job Alert

You will be updated with latest job alerts via email
Valid email field required
Send jobs
Send me jobs like this
drjobs

Job Alert

You will be updated with latest job alerts via email

Valid email field required
Send jobs
Job Location drjobs

Toronto - Canada

Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Job Description

HM Note: This hybrid role is three (3) days in office

Description:
We are looking to hire a Senior Business Intelligence specialist who is very experienced with architecting building and deploying enterprise scale Business Intelligence solutions using Power BI. Leveraging their experience they are expected to help OH develop Power BI governance framework associated SDLC processes best practices and outline roles and responsibilities of stakeholders in the context of a Hub and Spoke enterprise model. They are also expected to develop proofofconcepts and final versions of proposed solutions. and nbsp; and nbsp;
and nbsp;
Must haves: and nbsp; and nbsp;
  • Expert technical understanding of evolving Power BI and Microsoft Fabric capabilities as well as limitations and ability to propose governance around it in the context of hubandspoke model. and nbsp; and nbsp;
  • Experience with outlining policy processes and standard operating procedures related to Power BI projects in the context of hubandspoke model and nbsp;
  • Extensive experience in Microsoft Power BI Desktop Microsoft Power BI Dataflows Microsoft Power BI Report Builder Microsoft Power Automate Tabular Editor DAX Studio and VertiPaq Analyzer and nbsp;
  • Proficient in DAX M Power Query SQL and performance optimization and nbsp;
  • Experience in developing and implementing Power BI solutions. This includes data modelling designing development and testing of reports. and nbsp;
  • Experience in implementing security and have an understanding of application security layer model in Power BI and nbsp;
  • Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values duplicate meanings and invalid data) and nbsp;
  • Experience in developing enterprise architecture deliverables (e.g. business logical and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines and nbsp;
  • Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications and nbsp;
  • Extensive experience with conceptual logical and physical data modelling tools and nbsp;

Responsibilities: and nbsp;
  • Work collaboratively with a diverse group of stakeholders including management business and IT and nbsp;
  • Ability to lead participate and deliver Power BI projects and nbsp;
  • Participate and lead functional and technical specification reviews and nbsp;
  • Provide guidance and technical expertise for BI applications to other team members and nbsp;
  • Communicate technical concepts to nontechnical stakeholders and nbsp;

Desired Skills: and nbsp;
  • Ability to assess performance issues with Power BI solutions and provide recommendations. and nbsp; and nbsp;
  • Ability to translate business and data requirements into specifications sufficient for designing appropriate technology solutions including Power BI and nbsp;
  • Broad understanding of data management business analysis database architecture and information visualization and nbsp;
  • Excellent verbal and written communication skills. and nbsp; and nbsp;
  • Strong organizational and time management skills and nbsp;
  • Proven troubleshooting and analytical experience and nbsp;

Required Skills:
1 . Extensive experience in Microsoft Power BI Desktop Microsoft Power BI Dataflows Microsoft Power BI Report Builder Microsoft Power Automate Tabular Editor DAX Studio and VertiPaq Analyzer and nbsp;: 20 points
  • Proficient in DAX M Power Query SQL and performance optimization and nbsp;
2. Experience in developing and implementing Power BI solutions. This includes data modelling designing development and testing of reports. and nbsp;: 10 Points
3.Experience in implementing security and have an understanding of application security layer model in Power BI: 10 Points
4. Expert technical understanding of evolving Power BI and Microsoft Fabric capabilities as well as limitations and ability to propose governance around it in the context of hubandspoke model. and nbsp; and nbsp;: 20 Points
5.Experience with outlining policy processes and standard operating procedures related to Power BI projects in the context of hubandspoke model and nbsp;: 20 Points
6 . Ability to convey information in a clear comprehensive concise and organized manner verbally and through formal documentation with all levels of stakeholders and nbsp;: 20 Points

Total: 100 Points
Deliverables

From a Power BI governance perspective: and nbsp; and nbsp;
In general the deliverables include policy and process documentation as well Power BI proofofconcepts and solutions to support Power BI governance in the context of hubandspoke model. and nbsp; and nbsp;

Some of the key focus areas for Power BI governance are:
and nbsp; and nbsp;
  • Define roles and responsibilities of Hub and spoke teams to support process documentation and approvals and nbsp;
  • Clear list of required processes with supporting documentation and approval processes from hub and spoke teams especially for PHI data with Power BI and nbsp;
  • Critical documentation templates to support development validation and deployment and nbsp;
  • Power BI Workspace Management including creation administration and decommissioning. and nbsp;
  • Consider PHI and nonPHI Power BI solutions being developed validated and deployed (embedded) to portals. and nbsp;
  • Sourcing data from Analytics Data Hub (ADH Azure Synapse) and excel sources hosted on restricted folders (R:drive) and nbsp;
  • Access management to Power BI zones/environments (Dev/Validation/Production) and nbsp;
  • Power BI product and operations management plan
  • and nbsp;
From a Power BI solution development perspective: and nbsp;
  • Work with the business to understand a business problem define reporting requirements and translate them into Power BI solutions and reporting deliverables that can be embedded to the portals and nbsp;
  • Translate business and data requirements into specifications sufficient for designing appropriate technology solutions including Power BI and nbsp;
  • Recommend data aggregation approaches to enable aggregate reporting using record level data and nbsp;
  • Designing high quality interfaces to present information in a meaningful way to end users e.g. ability to create wireframes prototypes and Proofofconcepts and nbsp;
  • Develop best practices and standards related to Power BI and nbsp;
  • Convey information in a clear comprehensive concise and organized manner verbally and through formal documentation and nbsp;

Knowledge Transfer Details:
  • The Candidate will ensure full knowledge transfer of all technical and process related work is provided to the Ontario Health team during and before end of engagement. Some of this might occur during and at the end of the engagement but will also be shared as information is obtained/consolidated. Key deliverables will be shared with team using an approved format. and nbsp;
  • The Candidate must provide all related documentation as part of Knowledge transfer protocol. Documents will be reviewed by the appropriate leads and signed off by manager/director. and nbsp;
  • The candidate will work collaboratively with Ontario Health team throughout the assignment and ensure key deliverables milestones and documentation are shared during and at the end of the engagement. and nbsp;
  • A walkthrough of any demos development etc. will be required during and before end of engagement as required.

Must Haves:
  • 5 years experience with Power BI as well as Microsoft Fabric experience in a hubandspoke model. and nbsp; and nbsp;
  • 2 years experience with outlining policy processes and standard operating procedures related to Power BI projects in the context of hubandspoke model.
  • 5 years experience and nbsp; and nbsp;with any of the following: and nbsp; and nbsp;MS Power BI Desktop MS Power BI Dataflows MS Power BI Report Builder MS Power Automate Tabular Editor DAX Studio and VertiPaq Analyzer

Employment Type

Full Time

Company Industry

About Company

Report This Job
Disclaimer: Drjobpro.com is only a platform that connects job seekers and employers. Applicants are advised to conduct their own independent research into the credentials of the prospective employer.We always make certain that our clients do not endorse any request for money payments, thus we advise against sharing any personal or bank-related information with any third party. If you suspect fraud or malpractice, please contact us via contact us page.