HOOPP (Healthcare of Ontario Pension Plan) Logo

HOOPP (Healthcare of Ontario Pension Plan)

Senior Analyst, Business Intelligence (18-month contract)

Posted 21 Days Ago
Be an Early Applicant
Toronto, ON
Senior level
Toronto, ON
Senior level
The Senior Analyst will analyze investment reporting, develop cross-functional reports, ensure data accuracy, and collaborate with IT teams. Requires deep industry knowledge and technical skills.
The summary above was generated by AI

Why you’ll love working here:

  • high-performance, people-focused culture

  • our commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selves

  • learning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growth

  • membership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement security

  • competitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account).

  • optional post-retirement health and dental benefits subsidized at 50%

  • yoga classes, meditation workshops, nutritional consultations, and wellness seminars

  • the opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workers

Job Summary:

Reporting to the Director, Business Intelligence, Performance Systems and Analytics, this 18- month contract position will be responsible for a broad range of activities affecting all groups within the Investment Reporting, Data Governance & Valuations.  This will require an understanding of HOOPP at a macro level as well as a detailed understanding of HOOPP’s Investment Products & Strategies, Investment Reporting,  Processes, as well as Data Structures & Business and IT Architecture.  The individual will have considerable interaction with various departments within HOOPP’s IT, Front, Middle, and Back Offices and will be focused on building, maintaining, and supporting cross-functional reports and underlying data models for a range of internal clients.

What you will do:

  • Develop a deep understanding of the Portfolio and Deal Structures within HOOPP including all of the securities that make up those strategies

  • Build cross-functional reports using a range of reporting tools and technologies like Qlikview/QlikSense, Python, Snowflake, Excel, Power BI, SAP Hana. Act as a SME resource for BI tools used by the team

  • Contribute to the decisions related to HOOPP’s Data Architecture to make sure the future state supports the need of the team and its clients. Analyze, monitor and confirm the methodologies and the accuracy of the calculations impacting reports developed and/or supported by the team Incorporate cross-functional, and data quality checks   across supported reports to ensure accuracy and robustness of reporting

  • Coordinate with other teams the completion of various projects, capture and document requirements, communicate them effectively and precisely to implementation teams, advise on preferred solutions, and ultimately validate and accept related deliverables. Communicate effectively and work closely with internal clients to make sure their requirements are met, and delivered solutions validated and accepted  

  • Interface various internal systems, to analyze workflows and data transformation within said systems. Identify opportunities for improvements, communicate the benefits and risks associated with proposed changes. Provide clear, hands-on, technical guidance to implementation teams. Validate and accept delivered solutions.

  • Collaborate with IT teams to help deliver robust, well-designed automated solutions while mitigating implementation risks. Continuously manage risk associated with data quality and governance

  • As a self-starter, continuously look for outside-of-the-box process improvements and new, value-add initiatives

  • Learn and keep current in the understanding of the key processes supported by or having an impact on the team.

What you will bring:

  • Undergraduate degree in a technical field (i.e. Finance, IT, Mathematics)

  • Professional designations – CFA, FRM, PRM would be an asset

  • 5+ Years of Investment Industry experience, preferably with various Derivative Instruments

  • Proven experience as a Business Analyst in Financial Services, preferably Pension Funds

  • Proficiency with SQL, spreadsheets, database applications (SAP Hana strongly preferred) and some type of general-purpose programming language (Python)

  • BI Tool experience (specifically with Qlikview/QlikSense, Power BI). Experience in report design, report implementation, and underlying data modeling

  • Basic knowledge of SDLC, SaaS and DevOps concepts, and change management processes

  • Practical product knowledge, with a solid understanding of theoretical fundamentals, especially those related to derivative valuations and structures

  • Diligent with strong troubleshooting and problem-solving skills, with keen eye for detail and accuracy

  • Ability to think conceptually, creatively, always looking for new ways of doing work. Lead initiatives to develop and implement improvements.

  • Able to work independently with minimal direction as well as part of a team

  • Works well under pressure handles concurrent tasks, and meets prescribed deadlines

  • A commitment to demonstrating HOOPP values

Top Skills

Excel
Power BI
Python
Qliksense
Qlikview
Sap Hana
Snowflake
SQL

Similar Jobs

2 Days Ago
Hybrid
Toronto, ON, CAN
Mid level
Mid level
Fintech • Machine Learning • Payments • Software • Financial Services
As a Principal Data Scientist, you'll develop, validate, and deploy machine learning models, analyze experiments, and derive insights from large datasets to optimize business strategies.
Top Skills: AWSCircleCIGitH2OJenkinsMatplotlibPythonRScalaScikit-LearnSeabornSQLTableauTensorFlowXgboost
Mid level
Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
The Customer Portal Analyst oversees the setup of Magna in automotive customer portals, providing training and support. The role involves improving efficiency, handling access, managing data flow, and supporting portal integration while assisting in contract negotiations and troubleshooting issues.
Top Skills: IpointOem Systems
2 Days Ago
Toronto, ON, CAN
Expert/Leader
Expert/Leader
Food • Retail • Agriculture • Manufacturing
The Principal Data Architect will lead the creation of enterprise data models, collaborate with teams on data solutions, and ensure data governance and security while mentoring others.
Top Skills: AIAnalyticsAzure DatabricksCloud Data WarehouseData LakesData ModelingData WarehousingPower BISQL

What you need to know about the Vancouver Tech Scene

Raincouver, Vancity, The Big Smoke — Vancouver is known by many names, and in recent years, it has gained a reputation as a growing hub for both tech and sustainability. Renowned for its natural beauty, the city has become a magnet for professionals eager to create environmental solutions, and with an emphasis on clean technology, renewable energy and environmental innovation, it's attracted companies across various industries, all working toward a shared goal: advancing clean technology.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account