BI Consultant

icon briefcase Job Type : Full Time

Number of Applicants

 : 

000+

Click to reveal the number of candidates who applied for this job.

Job Description - BI Consultant

BI Developer – Senior

Government Services

Start Date - 2024-05-06

End Date - 2025-03-31

No Clearance Required

Downtown Toronto - Hybrid – 3 days onsite



Must Haves:


  • Demonstrated experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service

  • Implement, maintain, and support BI solutions in Microsoft and other BI platforms

  • We seek a candidate with extensive experience with Oracle SQL and Spark SQL

  • Experience with cloud platform like Azure and working knowledge for cloud migration

  • Experience with Microsoft Azure data analytics tools, such as, Azure Data Factories, Azure Databricks, Azure Synapse




Nice to Have:


  • Prior public sector experience would be an asset

  • Experience working with PeopleSoft data would be an asset.

  • Proficiency with Power BI and DAX would be an asset.






Development Skills40%

  • 10+ yearsof experience in data analysis developing business intelligence and reporting in a medium to large size corporate environment demonstrating detailed knowledge of BI functions such as analytics, data modeling & data mining, reporting, report conversion and data cleansing.

  • Demonstrated experience in Azure Databricks, Delta Lake, Azure Storage, ADF, Azure Analysis Service(must have)

  • Design and develop BI dashboards and reports based on business requirements

  • Implement, maintain, and support BI solutions in Microsoft and other BI platforms(must have)

  • Complete committed backlog and sprints within the agreed upon timeframe

  • Curate data from multiple data sources for an efficient presentation in an enterprise environment

  • Recommend improvements to streamline processes regarding data flow and data quality to improve data accuracy, usability, and value

  • Remain abreast of technology developments within fields relevant to current and future BI and Reporting initiatives

  • Document “As Built’ reports and all data transformations deployed to production

  • Take ownership of end-to-end development of each dashboard and report being developed

  • We seek a candidate with extensive experience with Oracle SQL and Spark SQL(must have)

  • Proven ability to work with complex SQL queries, potentially hundreds or thousands of lines in length.

  • Ability to organize complex SQL for readability and understanding by others.

  • Solid understanding of concepts underlying analytical data models required.

  • Experience working with PeopleSoft data would be an asset.

  • Proficiency with Power BI and DAX would be an asset.




Technology Skills35%

  • Experience with cloud platform like Azure and working knowledge for cloud migration(must have)

  • Experience with Microsoft Azure data analytics tools, such as, Azure Data Factories, Azure Databricks, Azure Synapse(must have)

  • Expertise in advanced prediction and prescriptive analytics including machine learning algorithms, designing experiments, fraud detection

  • Internally motivated and adaptable, able to work proficiently both independently and in a team environment.

  • Managing PowerBI workspaces, report access, report deployment, developing best practices in an enterprise environment

  • Strong knowledge and experience in analyzing as well as designing data models that meet the reporting needs

  • Advance knowledge of writing complex SQL queries.

  • Strong Power BI experience (Power Query, DAX, Power Bi Services)

  • Experience with Microsoft BI and Azure stack

  • Able to troubleshoot BI reporting and analytic business needs and provide solutions for issue resolution




Soft Skills-20%

  • Strong communication skills; both written and verbal

  • Ability to develop and present new ideas and conceptualize new approaches and solutions

  • Excellent interpersonal relations and demonstrated ability to work with others effectively in teams

  • Demonstrated ability to work with functional and technical teams

  • Demonstrated ability to participate in a large team and work closely with other individual team members

  • Proven analytical skills and systematic problem solving

  • Strong ability to work under pressure, work with aggressive timelines, and be adaptive to change




Public Sector Experience5%

  • Prior public sector experience would be an asset





#J-18808-Ljbffr
Original job BI Consultant posted on GrabJobs ©. To flag any issues with this job please use the Report Job button on GrabJobs.
icon no cv required No CV Required icon fast interview Fast Interview via Chat

Share this job with your friends

icon get direction How to get there?

icon geo-alt Old Toronto, On

icon get direction How to get there?
View similar Others jobs below

Similar Jobs in Canada

GrabJobs is the no1 job portal in Canada, connecting you to thousands of jobs fast! Find the best jobs in Canada, apply in 1 click and get a job today!

Mobile Apps

Copyright © 2024 Grabjobs Pte.Ltd. All Rights Reserved.