John Hancock
is hiring
Data Analyst
About Our Company
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.
Job Description & Responsibilities
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
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
Surveys
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?
- You obsess about customers, listen, engage and act for their benefit.
- You think big, with curiosity to discover ways to use your agile approach and enable business outcomes.
- You thrive in teams and enjoy getting things done together.
- You take ownership and build solutions, focusing on what matters.
- You do what is right, work with integrity and speak up.
- You share your humanity, helping us build a diverse and inclusive work environment for everyone.
Requirements
What We Are Looking For
- Excellent problem-solving skills and team skills. Should be able to work with multiple teams
- 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
- Basic working experience and understanding of creating SQL queries or stored procedures
- Basic understanding of any programming language such as Python or R
- Should be an effective communicator across multiple teams
- A Computer Science or Information Technology grad is preferred
What we offer
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 opportunity: We create opportunities to learn and grow at every stage of your career.
- Continuous innovation: We invite you to help redefine the future of financial services.
- 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.
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.
