Power BI

3 months ago


Toronto, Canada Scotiabank Full time

Requisition ID: 199165

Join a purpose driven winning team, committed to results, in an inclusive and high-performing culture.

As a Power BI expert and Data Analytics Specialist you will be at the forefront of analysing and visualizing data from Clarity PPM (and other sources) to provide stakeholders with actionable insights into key indicators like time tracking, project performance, resource utilization and portfolio management. You will be responsible for designing BI dashboards/reports that drive business and operational efficiency. You will collaborate closely with various stakeholders/teams/ management representatives across the bank to understand business objectives and reporting needs, unique requirements and deliver comprehensive Power BI solutions that meet their needs while adhering to quality and standards.

**Is this role right for you? In this role you will**:

- Data Modeling and Transformation: Extract/download data from Clarity PPM and other relevant systems/sources, clean, massage and reprocess data as needed. perform in-depth analysis to identify trends, patterns, and key performance indicators related to project management, time tracking and resource allocation. Design and implement robust data models.
- Dashboard and Report Development: Maintain & Develop visually appealing and intuitive dashboards, reports, and visualizations using Power BI. Support stakeholders with real-time insights into data related to project management, statuses, resource utilization/allocation, budget variance, time tracking and other critical metrics..
- Data Integration: Understand the data from various systems - Clarity PPM data & other data sources such as financial systems or HR databases, to provide a comprehensive view of project performance and portfolio management.
- Performance Optimization: Optimize BI reports and queries to ensure fast and efficient performance, specially when dealing with large volumes of data.
- Data Quality: Implement rigorous data quality checks and validation processes to ensure the accuracy, consistency, and integrity of data used in Power BI dashboards/solutions.
- Stakeholder Collaboration: Collaborate closely with project managers, business analysts, directors, senior Leaders & other stakeholders to understand their reporting requirements and translate them into effective BI solutions (that drive informed decision-making) following a well defined work intake process. Regularly prioritize the initiatives with the stakeholders and set the right expectations.
- Documentation and Training: Create comprehensive documentation for BI solutions, including data models, report specifications, and user guides. Provide training and support to end users to ensure they can effectively utilize BI reports and dashboards.

**Do you have the skills that will enable you to succeed in this role? We’d love to work with you if you have**:

- Bachelor's degree in Computer Science, Information Systems, Finance, or a related field.
- 4 years of experience working as a Power BI developer and data engineer preferably in financial services industry.
- 3 years of experience working on Clarity PPM ( project portfolio management technology) preferably in financial services industry.
- Excellent analytical skills with a keen attention to detail.
- Strong communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
- Experience with data modeling techniques and best practices, particularly in the context of project management, time tracking, resource management, Dashboard reporting, data extracts and other banking data.
- Proficiency in Structured Query Language for data manipulation and querying, with a solid understanding of relational data structures and schema.
- Strong knowledge of software lifecycle, project management, time tracking, financial management and processes
- Proven track record of developing insightful dashboards and reports using Power BI in an enterprise environment.
- Familiarity with financial performance metrics, risk management principles, and regulatory reporting
- Knowledge of Clarity CA-PPM, programming languages, data analysis and automation

**What’s in it for you?**
- Hybrid work model allowing for flexibility and work/life balance.
- A rewarding career path with diverse opportunities for professional development
- A culture that promotes teamwork and cross-functional collaboration to achieve business goals. Inclusive workplace that values diversity of thought, background, and experience
- A competitive compensation and benefits package
- An organization committed to making a difference in our communities - for you and our customers.
- Get a great overview of how the Bank operates by joining the COO team within Technology & Operations in a role that has widespread impact across all major business lines and functions.

Location(s): Canada : Ontario : Toronto

Scotiabank is a leading bank in the Americas. Guided by our pur


  • Power Bi

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

  • Power BI Expert

    3 days ago


    Toronto, Ontario, Canada Global Pharma Tek Full time

    Job DescriptionGlobal Pharma Tek is seeking a highly skilled Senior Report Developer to join our team. As a key member of our Business Intelligence team, you will be responsible for designing, developing, and maintaining complex Power BI reports and datasets.Key ResponsibilitiesData Modeling and Visualization: Design and implement data models that are...

  • Power BI Expert

    2 days ago


    Toronto, Ontario, Canada Global Pharma Tek Full time

    Job DescriptionGlobal Pharma Tek is seeking a highly skilled Senior Report Developer to join our team. As a key member of our Business Intelligence team, you will be responsible for designing, developing, and maintaining complex Power BI reports and datasets.Key ResponsibilitiesData Modeling and Visualization: Design and implement data models that are...

  • Power BI Specialist

    3 months ago


    Toronto, Canada CareRx Corporation Full time

    **About CareRx** CareRx is Canada’s leading provider of specialty pharmacy services to seniors. We serve more than 92,000 residents in over 1,500 seniors and other communities (long-term care homes, retirement homes, assisted living facilities, and group homes). We are a national organization with a large network of pharmacy fulfillment centers that...

  • Power BI Developer

    2 days ago


    Toronto, Ontario, Canada Capleo Global LLC Full time

    Job DescriptionJob Title: Power BI SpecialistCompany: Capleo Global LLCLocation: Remote/HybridDuration: Contract + Possible ExtensionJob Type: Full-timeAbout the Role:We are seeking a highly skilled Power BI Specialist to join our team. As a Power BI Specialist, you will be responsible for developing and implementing business intelligence solutions using...

  • Power BI Developer

    3 days ago


    Toronto, Ontario, Canada Capleo Global LLC Full time

    Job DescriptionJob Title: Power BI SpecialistCompany: Capleo Global LLCLocation: Remote/HybridDuration: Contract + Possible ExtensionJob Type: Full-timeAbout the Role:We are seeking a highly skilled Power BI Specialist to join our team. As a Power BI Specialist, you will be responsible for developing and implementing business intelligence solutions using...


  • Toronto, Canada CareRx Corporation Full time

    **About CareRx** CareRx is Canada’s leading provider of specialty pharmacy services to seniors. We serve more than 92,000 residents in over 1,500 seniors and other communities (long-term care homes, retirement homes, assisted living facilities, and group homes). We are a national organization with a large network of pharmacy fulfillment centers that...

  • Power BI Developer

    1 month ago


    Toronto, Canada Experis Full time

    Power BI Developer Start ASAP Contract End: Dec-20-2024, renewable Worksite: Brampton, ON Our client, a leading IT consulting firm, is looking for a Power BI Developer. Responsibilities: Develop and maintain dynamic Power BI dashboards: Design and implement data connections to existing security and network tools like Splunk, QRadar, Arcsight,...

  • Power BI Analyst

    3 months ago


    Toronto, Canada Zeitview Full time

    Zeitview (formerly DroneBase) is the leading intelligent aerial imaging company for high-value infrastructure, providing businesses with actionable, real-time insights to recover revenue, reduce risk and improve build quality. Zeitview serves customers in the solar, wind, insurance, construction, real estate, and critical infrastructure industries. Trusted...

  • Power BI Developer

    3 months ago


    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto – hybrid – onsite 3x/week Contract Duration: 10 months Possibility for Extension Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (Possible OT) Reason: Additional workload Story Behind the Need Business group: Global Cash Management The team focused on internal treasury reporting around liquidity and funding...

  • Power BI Developer

    3 weeks ago


    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto – hybrid – onsite 3x/week Contract Duration: 10 months Possibility for Extension Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (Possible OT) Reason: Additional workload Story Behind the Need Business group: Global Cash Management The team focused on internal treasury reporting around liquidity and funding...

  • Power BI Developer

    3 months ago


    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto – hybrid – onsite 3x/week Contract Duration: 10 months Possibility for Extension Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (Possible OT) Reason: Additional workload Story Behind the Need Business group: Global Cash Management The team focused on internal treasury reporting around liquidity and funding...

  • Power BI developer

    6 days ago


    Toronto, Ontario, Canada Cloudious LLC Full time

    Job Title: Power BI Developer Company: [Company Name] Job Description: As a Power BI Developer, you will be responsible for designing and implementing dynamic Power BI dashboards that provide insights into security incidents, trends, vulnerabilities, network traffic patterns, and device health. Key Responsibilities: Design and implement data...

  • Power BI Developer

    2 weeks ago


    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto – hybrid – onsite 3x/weekContract Duration: 10 monthsPossibility for ExtensionNumber of Positions: 1Schedule Hours: 9am-5pm Monday-Friday (Possible OT)Reason: Additional workloadStory Behind the NeedBusiness group: Global Cash ManagementThe team focused on internal treasury reporting around liquidity and funding metrics.We are...

  • Power BI Developer

    2 weeks ago


    Old Toronto, Canada Nexus Systems Group Inc. Full time

    Location Address: Toronto – hybrid – onsite 3x/weekContract Duration: 10 monthsPossibility for ExtensionNumber of Positions: 1Schedule Hours: 9am-5pm Monday-Friday (Possible OT)Reason: Additional workloadStory Behind the NeedBusiness group: Global Cash ManagementThe team focused on internal treasury reporting around liquidity and funding metrics.We are...

  • Power BI Specialist

    2 months ago


    Toronto, Canada Capleo Global LLC Full time

    Position: Power BI Specialist Location: Toronto, ON (Hybrid) Duration: 178 business days Contract + Possible Extension Notes on Location: Candidate is required to work Onsite 3 days per week and 2 Remote. Job Description: Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a...

  • Power BI Analyst

    3 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

    3 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

    1 month ago


    Old Toronto, Ontario, CA Nexus Systems Group Inc. Full time

    Location Address: Toronto – hybrid – onsite 3x/week Contract Duration: 10 months Possibility for Extension Number of Positions: 1 Schedule Hours: 9am-5pm Monday-Friday (Possible OT) Reason: Additional workload Story Behind the Need Business group: Global Cash Management The team focused on internal treasury reporting around liquidity and funding...

  • Business Intelligence

    3 months ago


    Toronto, Canada CareRx Corporation Full time

    **About CareRx** CareRx is Canada’s leading provider of specialty pharmacy services to seniors. We serve more than 92,000 residents in over 1,500 seniors and other communities (long-term care homes, retirement homes, assisted living facilities, and group homes). We are a national organization with a large network of pharmacy fulfillment centres that...