Data Analyst / Business Intelligence Developer

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 Arrangement
Hybrid

The Opportunity
In this role, you work on SQL, Qlik, and other technical things, such as improving processes and streamlining data activities for the NAIC team. You will primarily deal with LTC (Long Term Care), VA (Variable Annuities), and FP (Fixed Products) data. The responsibilities include SQL/Qlik reporting changes for data-related items, issues, or processes. You must understand the existing Data warehouse (specifically Annex 4) architecture. That includes tables and critical fields on how the data flows from admin systems into the data warehouse tables. We will work with the ETL (VST (Valuation System Transformation) team) and accounting folks to ensure we have the correct data. During QE, you will run the Qlik jobs and do critical data control checks. Post-quarter, we work on developments and data changes as the reporting team requires. You will need documentation, following standard methodologies in SQL, Qlik, and some Python as required.
Responsibilities

• Quarterly and Yearly reporting
• Providing data and reports for Line actuaries during
• Testing the data for all the data changes and during SIT (System Integration Testing), UAT (User Acceptance Testing) VST cycles.
• This person will also work within large global VST teams assembled primarily of IT and Actuarial partners. The main technologies used are Qlik, SQL, and Python
• The person is responsible for RMA (Reserve Movement Analysis) analysis and testing to make sure data is correct and on-time
• State audits, AAT (Asset Adequacy Testing) data requests, and any other data questions
• Understanding the Qlik driver file (where all the NAIC reporting business logic is stored) and making vital changes.
• Attend the LTC/FP VST touchpoint calls to be aware of the changes happening in the VST and analyze the impact for NAIC.
• Ad-hoc data requests
• Working with the NAIC reporting team to provide and make changes as required. The student is responsible for preparing and communicating data to be consumed by reporting teams to analyze and report financial results.
• The NAIC Valuation Data team is responsible for all aspects of the quarterly and year-end processes and supporting other company initiatives. Some of the areas of responsibilities include:
• Talking to Line actuaries and understanding the requirements for sustainable solutions in Qlik/SQL/any appropriate tools and technologies.
• Surveys
• Assisting with ad-hoc requests and analyses as needed.
• You will gain experience in the business side of their assigned LOB and broad financial data concepts. The upcoming vital projects include IFRS17 data restructure for NAIC reporting; this includes working with the VST team and evaluating the NAIC data.
• Data analysis and understanding the SQL and Qlik solutions.
• Identifying and driving process improvement ideas and improving the use of technology within our group (including VST/QlikView/SQL etc.).

How will you create impact?
You will work with Line Actuaries and Data folks across the Lines of Business to create long-term sustainable solutions, Improve and automate processes to make the team more digital.
What motivates you?

• You think big, with curiosity to discover ways to use your agile approach and enable business outcomes.
• You obsess about customers, listen, engage and act for their benefit.
• You thrive in teams and enjoy getting things done together.
• You take ownership and build solutions, focusing on what matters.
• You share your humanity, helping us build a diverse and inclusive work environment for everyone.
• You do what is right, work with integrity and speak up.

What We Are Looking For

• Basic working experience and understanding of any reporting tools such as Qlik/Power BI /Tableau are required
• Basic working experience and understanding of data warehousing, understanding data models and business intelligence tools
• A Computer Science or Information Technology grad is preferred
• Should be an effective communicator across multiple teams
• Basic working experience and understanding of creating SQL queries or stored procedures
• Excellent problem-solving skills and team skills. Should be able to work with multiple teams
• Basic understanding of any programming language such as Python or R

What can we offer you?

• Professional development and leadership opportunities.
• A competitive salary and benefits packages.
• A growth trajectory that extends upward and outward, encouraging you to follow your passions and learn new skills.
• Flexible work policies and strong work-life balance.
• A focus on growing your career path with us.

Our commitment to you

• Continuous innovation: We invite you to help redefine the future of financial services.
• Boundless opportunity: We create opportunities to learn and grow at every stage of your career.
• Values-first culture: We lead with our Values every day and bring them to life together.
• Delivering the promise of Diversity, Equity and Inclusion: We foster an inclusive workplace where everyone thrives.
• Championing Corporate Citizenship: We build a business that benefits all stakeholders and has a positive social and environmental impact.

Every career at Manulife/John Hancock provides the opportunity to learn new skills and move your career forward. Ready to make an impact somewhere? What are you waiting for? Apply today.
About John Hancock And Manulife
John Hancock is a unit of Manulife Financial Corporation, a leading international financial services group that helps people make their decisions easier and lives better. We operate primarily as John Hancock in the United States, and Manulife globally, including Canada, Asia and Europe. We provide financial advice, insurance and wealth and asset management solutions for individuals, groups and institutions. Assets under management and administration by Manulife and its subsidiaries were CAD$1.3 trillion (US$1.1 trillion) as of June 30, 2021. Manulife Financial Corporation trades as MFC on the TSX, NYSE, and PSE, and under 945 on the SEHK. Manulife can be found at manulife.com.
One of the largest life insurers in the United States, John Hancock supports more than 10 million Americans with a broad range of financial products, including life insurance, annuities, investments, 401(k) plans, and education savings plans. Additional information about John Hancock may be found at johnhancock.com.
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 [email protected].
Salary & Benefits
The annual base salary for this role is listed below.
Primary Location
Boston, Massachusetts
Salary range is expected to be between
$66,920.00 USD - $124,280.00 USD
If you are applying for this role outside of the primary location, please contact [email protected] 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.
Know Your Rights I Family & Medical Leave I Employee Polygraph Protection I Right to Work I E-Verify I Pay Transparency
Company: John Hancock Life Insurance Company (U.S.A.)