Senior Data Analyst (Capital Markets)

Manulife Financial; Toronto; Hybrid; CAD 113,000 - 163,000; Full time

Job summary

Manulife Financial Corporation, a leading global financial services company, seeks a Senior Data Analyst to join the GWAM Data Engineering team. You will translate business requirements into scalable data models and collaborate across Data Management, Delivery, and governance functions to deliver high-quality data products for investment and wealth management.

You will analyze data quality, define data lineage, and contribute to data templates, governance, and testing strategies while leveraging

Qualifications

• >5-10 years experience working with Investment domain data and Data Management solutions
• >Experience with data-centric projects in capital markets or investment banking including Master data management, Data integration, Data warehousing and reporting
• >Experience with major trading platforms and data documentation artifacts
• >Strong SQL skills and ability to translate business requirements into data models
• >Exposure to Azure and agile/scrum delivery environments

Responsibilities

• Deliver flexible, reusable core data repositories
• Use accelerated delivery methodologies to provide timely business value
• Develop expertise in Investment domain and data content validation
• Establish data standards with Data Governance and document data templates and tools
• Capture data requirements and communicate them to stakeholders
• Ensure technical solutions meet business needs
• Conduct data profiling and advise on data cleansing rules
• Assist in creating business glossaries (data dictionaries)
• Collaborate with QA to test data components
• Evaluate data models and interfaces with clear data flow documentation
• Keep up-to-date on Investment domains to assess data quality
• Provide guidance to project teams via peer reviews
• Support documentation and testing of data transformations

Skills

Investment data

Data management

Data warehousing

Data modeling

Azure

Capital markets

Data governance

Agile / Scrum

Big Data

Tools

Bloomberg Polar Lake

SimCorp Dimension

Findur

Apex

Eagle

Charles River

Sylvan

Calypso

Job description

We are seeking a highly motivatedSenior Data Analystto join theGWAM Data Engineeringteam within the Global Wealth and Asset Management division. In this role, you will partner closely with Data Management, Data Delivery, Business Stakeholders, Data Architects, and Data Modelers to design and deliver scalable, high-quality data solutions that drive business value and align with the organization's Information Management standards. The ideal candidate will be a strongTechno-Functional professionalwith deep Capital Markets experience/knowledge and a solid understanding of data warehousing, data modeling, and enterprise data management.

You will play a key role in translating complex business requirements into logical and physical data models, collaborating on the design of data structures and tables, defining data lineage and governance standards, and ensuring the successful delivery of data products across the investment and wealth management landscape. Strong analytical skills, stakeholder management capabilities, and hands-on experience working with large-scale financial data ecosystems are essential for success in this role.

Responsibilities

• Deliver flexible, reusable and well-maintained core data repositories

• Use accelerated delivery methodologies to ensure data initiatives provide timely business value

• Develop and maintain expertise in the Investment domain, as well as expertise in accessing, querying, testing and validating data content to drive quality and consistency within solutions

• Partner with the Data Governance group to establish appropriate standards and methodologies, template and tools related to documenting, analyzing and testing data - work with management to implement these standards within the IS and Data Governance organizations

• Developing templates and methodologies to ensure data requirements are accurately and completely captured and can be effectively communicated to other data stakeholders, including Business Users, Business Architects, Business Analysts, Solutions Architects, Solutions Developers, Quality Assurance Analysts, Data Governance and Data Management Staff

• Ensuring the proposed technical solutions effectively meet the business need

• Conducting data profiling to analyze quality of incoming data and advising on any data cleansing rules

• Assisting in the creation of business glossaries (data dictionaries)

• Collaborating with the QA group to develop methods to test data components

• Evaluating existing and proposed data models and how to best access and query them

• Evaluating existing and proposed data interfaces and how to clearly document them, including specification of data flow models, data flow timing, source-to-target mapping, and data transformation rules including data validations and controls

• Keeping current on evolving Investment business knowledge domains to accurately assess the quality of the data

• Providing guidance to project teams via peer reviews

Required Qualifications:

• 5-10 years related experience in working with Investment domain data and Data Management solutions

• Experience with data-centric projects delivering the following (within a capital markets or investment banking domain): Master data management, Data integration, Data warehousing and reporting. Big Data environment for analytics

• Significant experience in major trading platforms, book of record systems, performance management platforms, such as Bloomberg Polar Lake, SimCorp Dimension, Findur, Apex, Eagle, Charles River, Sylvan, Calypso

• Experience delivering data documentation artifacts in organizations of similar size and complexity within project deadlines

Preferred Qualifications:

• Experienced writing complex SQL queries to analyze data and provide results to business users or project team members

• Able to communicate clearly, both verbally and in written form at various levels within the project teams

• Strong work ethic, results oriented, and accuracy / attention to detail are critical

• Demonstrated initiative, able to work both independently and as a team member

• Able to clearly communicate complex methodologies and approaches to stakeholders, peers and management

• Able to work in agile or scrum delivery environments

• Good understanding of techniques and tools pertaining to the planning, analysis, design, development, testing, deployment and maintenance of technology solutions

• exposure to Azure

When you join our team:

• We’ll empower you to learn and grow the career you want.

• We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words.

• As part of our global team, we’ll support you in shaping the future you want to see.

The role being advertised is an existing vacancy.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Manulife is an Equal Opportunity Employer

At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals. We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.

It is our priority to remove barriers to provide equal access to employment. A Human Resources representative will work with applicants who request a reasonable accommodation during the application process. All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies. To request a reasonable accommodation in the application process, contact [e-mail].

Referenced Salary Location

Toronto, Ontario

Working Arrangement

Hybrid

Salary range is expected to be between

$113,000.00 CAD - $163,000.00 CAD

Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are applying for this role outside of the primary location, please contact [e-mail] for the salary range for your location.

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact [e-mail] for more information about U.S.-specific paid time off provisions.

We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our personal information collection statement.