We are a leading financial services provider committed to making decisions easier and lives better for our customers and colleagues around the world. From our environmental initiatives to our community investments, we lead with values throughout our business. To help us stand out, we help you step up, because when colleagues are healthy, respected and meaningfully challenged, we all thrive. Discover how you can grow your career, make impact and drive real change with our Winning Team today.Working ArrangementHybridJob DescriptionThe opportunityThe Actuarial System Data and Reporting team is looking for a highly skilled and motivated Business Intelligence Analyst to join our team. This role works with the US Reporting Steward and will help serve as a liaison between US Actuarial and Global Systems & Data teams to meet the business' reporting needs. The primary function of this role will be to use data tools (SQL, QlikView, PowerBI) to query our data warehouse and provide meaningful analysis through new solutions and improving of existing ones to support Valuation with their Quarter-end and Year-end Reporting. The role will also be responsible for tracking change management tickets and implementation, along with supporting prioritization and assessment by developers, for continued System Improvement. The ideal candidate will have a solid background in querying data warehouses, SQL queries, using business intelligence tools for data visualization and analysis, and a passion for thinking outside the box to come up with process improvements and new insights.Responsibilities
Collaborate with business partners to understand actuarial data requirements and translate them into technical specifications
Work closely with development teams to ensure effective implementation of data solutions
Develop and maintain SQL queries to extract and manipulate data from the data warehouse
Support SIT (Systems Integration Testing) and UAT (User Acceptance Testing) cycles and conduct regression testing
Deliver actionable insights and recommendations to support process improvements
Design and create QlikView dashboards to improve analysis and reporting
Contribute to change management process by collecting requests, working with developers on assessment, tracking JIRA logs, and supporting prioritization process
Continuously improve actuarial data processes and standard methodologies to ensure data accuracy and integrity
What we are looking for
Bachelor's degree in Finance, Business, Computer Science, Mathematics, or related field
2-5 years of hands-on experience with SQL, including writing sophisticated queries and manipulating large datasets
Experience using data visualization tools (preferably Qlikview and/or PowerBI) to create and maintain reports to communicate insights from data
Strong analytical and problem-solving skills
Superb communication and collaboration abilities
Familiarity with change management processes and methodologies
Ability to work independently and cross-functionally in a team environment
Experience working with programming languages such as Python or R for data analysis and manipulation is preferred but not required
Knowledge of data warehousing concepts and methodologies is a plus
What can we offer you?
A competitive salary and benefits packages!
A growth trajectory that extends upward and outward, encouraging you to follow your passions and learn new skills.
A focus on growing your career path with us.
Flexible work policies and strong work-life balance.
Professional development and leadership opportunities.
Our commitment to you
Values-first culture!We lead with our Values every day and bring them to life together.
Boundless opportunityWe create opportunities to learn and grow at every stage of your career.
Continuous innovationWe invite you to help redefine the future of financial services.
Delivering the promise of Diversity, Equity and InclusionWe foster an inclusive workplace where everyone thrives.
Championing Corporate CitizenshipWe build a business that benefits all partners and has a positive social and environmental impact.
#LI-HybridAbout Manulife and John HancockManulife Financial Corporation is a leading international financial services group that helps people make their decisions easier and lives better. With our global headquarters in Toronto, Canada, we operate as Manulife across our offices in Asia, Canada, and Europe, and primarily as John Hancock in the United States. We provide financial advice, insurance, and wealth and asset management solutions for individuals, groups and institutions. At the end of 2022, we had more than 40,000 employees, over 116,000 agents, and thousands of distribution partners, serving over 34 million customers. At the end of 2022, we had $1.3 trillion (US$1.0 trillion) in assets under management and administration, including total invested assets of $0.4 trillion (US $0.3 trillion), and segregated funds net assets of $0.3 trillion (US$0.3 trillion). We trade as ‘MFC’ on the Toronto, New York, and the Philippine stock exchanges, and under ‘945’ in Hong Kong.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 .Salary & BenefitsThe annual base salary for this role is listed below.Primary LocationBoston, MassachusettsSalary range is expected to be between$68,740.00 USD - $127,660.00 USDIf you are applying for this role outside of the primary location, please contact for the salary range for your location. 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. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.Manulife/John Hancock 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/401(k) savings plans and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in the U.S. includes up to 11 paid holidays, 3 personal days, 150 hours of vacation, and 40 hours of sick time (or more where required by law) each year, and we offer the full range of statutory leaves of absence.Company: John Hancock Life Insurance Company (U.S.A.)