Senior Data Analyst (Capital Markets)

We are seeking a highly motivated Senior Data Analyst to join the GWAM Data Engineering team 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 strong Techno-Functional professional with 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. #LI-Hybrid The role being advertised is an existing vacancy.About Manulife and John HancockManulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit .Manulife is an Equal Opportunity EmployerAt 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 View email address on us.fitly.work Salary LocationToronto, OntarioWorking ArrangementHybridSalary range is expected to be between$113,000.00 CAD - $163,000.00 CADEmployees 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 View email address on us.fitly.work 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 View email address on us.fitly.work 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.SummaryLocation: Toronto, OntarioType: Full time