John Hancock is a company built on trust and integrity. Throughout our rich history which spans 160 years, we have remained true to the ideals on which our company was built, while also encouraging fresh insights and new ways of thinking. Whether it’s helping our clients plan for their financial future, helping local communities grow stronger, or helping our employees chart a course for their careers, we’re committed to offering help every step of the way. Because for us – a promise made, is a promise kept.
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.
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:
Providing data and reports for Line actuaries during
Quarterly and Yearly reporting
Ad-hoc data requests
State audits, AAT (Asset Adequacy Testing) data requests, and any other data questions
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 person is responsible for RMA (Reserve Movement Analysis) analysis and testing to make sure data is correct and on-time
Data analysis and understanding the SQL and Qlik solutions.
Talking to Line actuaries and understanding the requirements for sustainable solutions in Qlik/SQL/any appropriate tools and technologies.
Understanding the Qlik driver file (where all the NAIC reporting business logic is stored) and making vital changes.
Identifying and driving process improvement ideas and improving the use of technology within our group (including VST/QlikView/SQL etc.).
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
Attend the LTC/FP VST touchpoint calls to be aware of the changes happening in the VST and analyze the impact for NAIC.
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.
Assisting with ad-hoc requests and analyses as needed.
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?
What We Are Looking For
What can we offer you?
Our commitment to you
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.