BI Consultant

4 months 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
  • 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 Skills 40%
  • 10+ years of 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
  • 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 Skills 35%
  • 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 Experience 5%
  • Prior public sector experience would be an asset
#J-18808-Ljbffr

  • BI Consultant

    2 weeks ago

    Old Toronto, Canada Apex Systems Full time

    Consultant, Cloud Security Architecture and AnalyticsConsultant, Cloud Security Architecture and AnalyticsApex Systems, a global IT services provider, is seeking a Consultant with extensive expertise in analytics tools, network infrastructure, security principles, and general systems to place at a leading Top Five Bank.Client: Big 5 BankLocation: Hybrid; 1-2...

  • Power BI Consultant

    1 week ago

    Greater Toronto Area, Canada Dimensional Strategies Inc. Full time

    Job Summary:We are seeking a highly skilled and motivated Power BI Consultant to help our clients implement and optimize data analytics solutions using Microsoft Power BI. The successful candidate will work with business leaders and stakeholders to understand their reporting needs and create data-driven insights that empower decision-making. This position...

  • Power BI Consultant

    3 weeks ago

    Greater Toronto Area, Canada, Ontario Dimensional Strategies Inc. Full time

    Job Summary:We are seeking a highly skilled and motivated Power BI Consultant to help our clients implement and optimize data analytics solutions using Microsoft Power BI. The successful candidate will work with business leaders and stakeholders to understand their reporting needs and create data-driven insights that empower decision-making. This position...

  • Executive Sales Director

    2 weeks ago

    Old Toronto, Canada BI WORLDWIDE Full time

    About the RoleWe are seeking a highly accomplished Executive Sales Director to lead our Regional Vice President team in Toronto. As a key member of our organization, you will be responsible for driving revenue growth and developing a high-performing sales team.Job OverviewThis is an exceptional opportunity to join BI WORLDWIDE as a Regional Vice President....

  • Consultant projet BI/Data

    1 week ago

    Old Toronto, Canada Société Financière Manuvie Full time

    p>Selling Tools and Insights Consultant, North AmericaRole DescriptionWorks directly with diverse sales regions to understand their unique needs, while implementing and optimizing adoption of new sales tools and insights.Leads change management and communication strategies to drive adoption of new tools and methodologies, collaborating closely with sales...

  • Power Bi

    6 months ago

    Toronto, Canada Virtusa Full time

    About Virtusa: Virtusa Corporation is a global provider of Digital Business Transformation, Digital Engineering, and Information Technology (IT) outsourcing services that accelerate our clients’ journey to their Digital Future. Virtusa serves Global 2000 companies in Banking, Financial Services, Insurance, Healthcare, Telecommunications, Media,...

  • Axiom Consultant with PlSQL, Power Bi

    1 week ago

    Toronto, Canada AstraNorth Full time

    **Experience (Years): 10 & Above** **Essential Skills**: - Axiom Consultant-SQL, Power BI, PL/SQL, SSIS, Tableau, Qlik, Cognos, experience of Axiom Controller View - Good knowledge and experience in using Axiom components. - Migration of Axiom components, Unix/Linux, & Windows platforms - Axiom reporting development and configuration experienceExperienced...

  • Consultant Data

    1 week ago

    Old Toronto, Canada Société Financière Manuvie Full time

    p>As a federally chartered bank and federally and provincially regulated trust company, Manulife Bank and Manulife Trust (“Manulife Bank”) are subject to numerous legislative requirements including the Bank Act, the Trust and Loans Company Act, the Proceeds of Crime (Money Laundering) and Terrorist Financing Act and the Personal Information Protection...

  • IT Infrastructure Consultant

    1 week ago

    Old Toronto, Canada ROSS Full time

    Technical Consultant Job DescriptionWe are seeking a highly skilled Technical Consultant to join our team at ROSS, a leader in business intelligence and analytics. As a Technical Consultant, you will be responsible for providing technical expertise and solutions to our clients.Job Responsibilities:Install and configure software on various operating...

  • Consultant Data

    2 weeks ago

    Old Toronto, Canada Brand My Bags Full time

    BDO is dedicated to fostering strong relationships with both their people and clients, offering a people-first culture that prioritizes personal and professional growth. The new Data Analytics Consultant/Data Engineer will be part of BDO Digital, tasked with executing client engagements and driving the implementation of analytics solutions.In this role you...

  • Axiom Consultant with PL/SQL, Power BI

    1 month ago

    Toronto, Canada Astra North Infoteck Inc. Full time

    Keywords: Axiom Consultant-SQL, Power BI, PL/SQL, SSIS, Tableau, Qlik, Cognos, experience of Axiom Controller ViewGood knowledge and experience in using Axiom components.Migration of Axiom components, Unix/Linux, & Windows platforms Experience (Years): 10 & above Essential Skills:Axiom reporting development and configuration experienceExperienced in Axiom...

  • Axiom Consultant with PL/SQL, Power BI

    1 month ago

    Toronto, Canada Astra North Infoteck Inc. Full time

    Job DescriptionKeywords: Axiom Consultant-SQL, Power BI, PL/SQL, SSIS, Tableau, Qlik, Cognos, experience of Axiom Controller ViewGood knowledge and experience in using Axiom components.Migration of Axiom components, Unix/Linux, & Windows platforms Experience (Years): 10 & above Essential Skills:Axiom reporting development and configuration...

  • Power BI Specialist

    1 month ago

    Toronto, Canada ZS Full time

    : **ZS** is a place where passion changes lives. As a management consulting and technology firm focused on improving life and how we live it, our most valuable asset is our people. Here you’ll work side-by-side with a powerful collective of thinkers and experts shaping life-changing solutions for patients, caregivers and consumers, worldwide. ZSers drive...

  • Power BI Analyst

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

  • Power BI Analyst

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

  • Power BI Developer

    4 weeks ago

    Toronto, Ontario, Canada Lyons Consulting Group Full time

    Job DescriptionSenior Power BI EngineerAbout the RoleWe are seeking an experienced Senior Power BI Engineer to join our team at Lyons Consulting Group. As a key member of our data engineering team, you will be responsible for designing and implementing complex data models, optimizing Power BI reports and SQL queries, and working closely with business...

  • Senior Data Integration and Business Intelligence Consultant

    1 month ago

    Old Toronto, Canada Promote Project Full time

    About the RoleWe are seeking an experienced Senior Consultant to join our team as a Senior Data Integration and Business Intelligence Consultant. This role will play a pivotal part in the expansion of our India Practice, where you will lead custom data warehouse and BI solutions using Oracle NetSuite Analytics Warehouse (NSAW) platform.

  • Technical Consultant for Enterprise Data Integration

    1 week ago

    Old Toronto, Canada ROSS Full time

    Senior Data Integration (DI) Technical Consultant Job DescriptionWe are seeking a highly skilled Senior Data Integration (DI) Technical Consultant to join our team at ROSS, a leader in business intelligence and analytics. Our software provides an integrated platform for analyzing data from every source and gaining predictive power to drive change at every...

  • Business Analyst

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

  • Regional Vice President of Sales

    3 months ago

    Old Toronto, Canada BI WORLDWIDE Full time

    We have a career opportunity for the Regional Vice President for our Toronto Sales office. The primary role of the Regional Vice President (RVP) is to build a great team of Business Development Directors (BDDs) and grow BIW revenue in the region. This includes hiring and developing people into a high performing sales team, and utilizing corrective action...