BI Consultant

3 weeks ago

Old Toronto, Canada Nexus Systems Group Inc. Full time
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

  • Power BI Technical Consultant

    2 weeks ago

    Old Toronto, Canada Motion Recruitment Partners LLC Full time

    One of the top banks in Canada is looking to add a Power BI Technical Consultant to their team. This consultant will play a key role in the successful adoption of governance of Power BI throughout the organization to enable rapid data driven decisions through the business. You will be responsible for providing guidance on deploying and managing the Power BI...

  • Power BI Technical Consultant

    2 weeks ago

    Old Toronto, Canada Motion Recruitment Partners LLC Full time

    One of the top banks in Canada is looking to add a Power BI Technical Consultant to their team. This consultant will play a key role in the successful adoption of governance of Power BI throughout the organization to enable rapid data driven decisions through the business. You will be responsible for providing guidance on deploying and managing the Power BI...

  • Power BI Technical Consultant

    2 weeks ago

    Old Toronto, Canada Motion Recruitment Partners LLC Full time

    One of the top banks in Canada is looking to add a Power BI Technical Consultant to their team. This consultant will play a key role in the successful adoption of governance of Power BI throughout the organization to enable rapid data driven decisions through the business. You will be responsible for providing guidance on deploying and managing the Power BI...

  • Power BI Technical Consultant

    2 weeks ago

    Toronto, ON, Canada Motion Recruitment Partners LLC Full time

    One of the top banks in Canada is looking to add a Power BI Technical Consultant to their team. This consultant will play a key role in the successful adoption of governance of Power BI throughout the organization to enable rapid data driven decisions through the business. You will be responsible for providing guidance on deploying and managing the Power BI...

  • Senior Manager, BI Consulting

    3 weeks ago

    Toronto, Canada Tiger Analytics Full time

    Tiger Analytics is an advanced analytics consulting firm. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our consultants bring deep expertise in Data Science, Data Analytics, Data Engineering, Business Intelligence, Machine Learning and AI. Our business value and leadership have...

  • Senior Manager, BI Consulting

    3 weeks ago

    Toronto, Canada Tiger Analytics Full time

    Tiger Analytics is an advanced analytics consulting firm. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our consultants bring deep expertise in Data Science, Data Analytics, Data Engineering, Business Intelligence, Machine Learning and AI. Our business value and leadership have...

  • Senior Manager, BI Consulting

    3 weeks ago

    Toronto, Canada Tiger Analytics Full time

    Tiger Analytics is an advanced analytics consulting firm. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our consultants bring deep expertise in Data Science, Data Analytics, Data Engineering, Business Intelligence, Machine Learning and AI. Our business value and leadership have...

  • Senior Manager, BI Consulting

    3 weeks ago

    Toronto, Canada Tiger Analytics Full time

    Tiger Analytics is an advanced analytics consulting firm. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our consultants bring deep expertise in Data Science, Data Analytics, Data Engineering, Business Intelligence, Machine Learning and AI. Our business value and leadership have...

  • BI Consultant

    3 weeks ago

    Toronto, ON, Canada Nexus Systems Group Inc. Full time

    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...

  • Senior Manager, BI Consulting

    2 weeks ago

    Toronto, ON, C6A, Ontario, Canada Tiger Analytics Full time

    Tiger Analytics is an advanced analytics consulting firm. We are the trusted analytics partner for several Fortune 100 companies, enabling them to generate business value from data. Our consultants bring deep expertise in Data Science, Data Analytics, Data Engineering, Business Intelligence, Machine Learning and AI. Our business value and leadership have...

  • Senior Data Analytics Consultant

    2 days ago

    Old Toronto, Canada TalentWorld Full time

    Explore the dynamic realm of data analytics as a Senior Data Analytics Consultant! Craft insightful dashboards and reports with Power BI, illuminating strategic pathways and uncovering actionable insights. Your expertise will be pivotal in decoding complex datasets and driving informed decisions. Join us in shaping the future of data-driven initiatives...

  • Senior Data Analytics Consultant

    2 days ago

    Old Toronto, Canada TalentWorld Full time

    Explore the dynamic realm of data analytics as a Senior Data Analytics Consultant! Craft insightful dashboards and reports with Power BI, illuminating strategic pathways and uncovering actionable insights. Your expertise will be pivotal in decoding complex datasets and driving informed decisions. Join us in shaping the future of data-driven initiatives...

  • Power BI Analyst

    4 days ago

    Toronto, Canada SickKids Full time

    **About SickKids**: Dedicated exclusively to children and their families, The Hospital for Sick Children (SickKids) is one of the largest and most respected paediatric healthcare centres in the world. As innovators in child health, we lead and partner to improve the health of children through the integration of healthcare, leading-edge research and...

  • SAP Bw/bi Consultant

    4 weeks ago

    Toronto, Canada vTech Solution Full time

    **Job title: BI Analyst (SAP)** **Duration: Full-time permanent** **Location: Etobicoke, ON** **Requirement** - A Bachelor's Degree in Information Technology or related field - 8 + years of experience modeling/implementation of SAP BW data warehousing solutions and reporting with SAP BEx, SAP Business Objects and their best practices - Experience in...

  • Data analyste bi

    4 weeks ago

    Toronto, ON, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Data analyste bi

    4 weeks ago

    Toronto, ON, Canada Tata Consultancy Services Full time

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity and is reflected in our people stories across our workforce implemented through...

  • Business Analyst

    4 weeks ago

    Toronto, Canada Dawn InfoTek Inc. Full time

    Dawn InfoTek Inc. is a professional IT consulting team that partners with major financial institutions, investment firms and government sectors. We have been dedicated to delivering cutting-edge consulting services and recruiting all levels of IT positions for our clients. We are currently seeking competent individuals to fulfill the role of Business...

  • Senior Consultant, Business Intelligence

    1 week ago

    Old Toronto, Canada Canadian Imperial Bank of Commerce Full time

    Senior Consultant, Business Intelligence page is loaded Senior Consultant, Business Intelligence Apply locations Toronto, ON time type Full time posted on Posted 3 Days Ago job requisition id 2408434 We’re building a relationship-oriented bank for the modern world. We need...

  • Senior Consultant, Business Intelligence

    1 week ago

    Old Toronto, Canada Canadian Imperial Bank of Commerce Full time

    Senior Consultant, Business Intelligence page is loaded Senior Consultant, Business Intelligence Apply locations Toronto, ON time type Full time posted on Posted 3 Days Ago job requisition id 2408434 We’re building a relationship-oriented bank for the modern world. We need...

  • Senior Consultant, Business Intelligence

    2 weeks ago

    Old Toronto, Canada Canadian Imperial Bank of Commerce Full time

    Senior Consultant, Business Intelligence page is loaded Senior Consultant, Business Intelligence Apply locations Toronto, ON time type Full time posted on Posted 3 Days Ago job requisition id 2408434 We’re building a relationship-oriented bank for the modern world. We need...