Sr. Business Consultant to support a data migration project from SAP HANA to Snowflake for our Pensions Client x2

Sr. Business Consultant to support a data migration project from SAP HANA to Snowflake for our Pensions Client x2

Length: 12 Months (High Possibility of Extension)

Location: Downtown Toronto (Hybrid 2 Days in Office)

Reporting to the Director, Business Intelligence, Performance Systems and Analytics, this 12- month contract position will be responsible for a broad range of activities affecting all groups within the Investment Reporting, Data Governance & Valuations. The individual will have considerable interaction with various departments within our clients IT, Front, Middle, and Back Offices and will be focused on cross-functional report building, systems configuration/maintenance/optimization and the data migration project as it relates to our processes

Must Have Skills:

• 7+ Years experience as a Business Analyst/Consultant within Financial Services (Preferably Pensions Funds)
• BI Tools Experience (Qlikview/QlikSense, Power BI)
• Experience with Capital Markets
• Solid understanding of SAP Hana Database or Snowflake

Nice to Have Skills:

• SQL or Python Development Experience

Job Description:

• 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
• Analyze, monitor and confirm the methodologies and the accuracy of the calculations impacting reports developed and/or supported by the team,
• Involved in the configuration, maintenance, and upgrades for our clients P&L system, and related source systems. Provide support for the projects related to said systems.
• Design and implement automated solutions used for data quality monitoring, evaluation, and exception-based handling, and otherwise 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 for the Business Intelligence, Performance Systems and Analytics group
•