drjobs Business Intelligence Specialist 8575-2812

Business Intelligence Specialist 8575-2812

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

Monthly Salary drjobs

Not Disclosed

drjobs

Salary Not Disclosed

Job Description

HM Note: This hybrid contract role is three (3) days in office. Candidates resume must include first and last name.


Scope:
  • Work with project teams to ensure 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 highperforming 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 onpremise data sources.
  • Configure automatic refresh for Power BI datasets.
  • Enable Rowlevel 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/subprojects 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
Experience and Skill Set Requirements

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 nontechnical 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 and nbsp; and nbsp;
  • 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

Mandatory Requirements:
  • Use Power Query to extract data from different data sources and choose a storage mode and connectivity type. and nbsp;
  • Profile clean and load data into Power BI and nbsp;
  • Design data models that are intuitive highperforming and simple to maintain and nbsp;
  • 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 onpremise data sources

Criteria Ratings MUST TOTAL 100
Criteria 1: Technical Skills 60 points
Criteria 1 Details:
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 and nbsp;
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 and amp; Communication Skills
Criteria 2 Points: 40 points
Criteria 2 Details:
Documentation Collaboration and amp; Communication Skills
Ability to partner with internal/external stakeholders and liaise with technical experts and nontechnical 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 common understanding of the issues as well as agreement on 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 and nbsp; and nbsp;
Facilitation skills Interpersonal and consultative skills
Stakeholder management skills. Demonstrated strong problemsolving and organizational skills
A team player with a track record for meeting deadlines. and nbsp; and nbsp;
Working knowledge and experience developing reports for use by a wide spectrum of stakeholders and nbsp;
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

Knowledge Transfer
Knowledge to be Transferred:
(at the end of the contract) Processes used for developing the deliverables
Power BI models
All source code created in development of deliverables
Knowledge to be Transferred to: Team lead / Team members
Details of Transfer:
(how transfer will occur) 1:1 meetings / team meetings / throughout the duration of the project life cycle etc.

Must Haves:
  • 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 highperforming and simple to maintain
  • Previous OPS/Justice sector experience would be an asset.

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.