Company:
John Hancock
Location: Boston
Closing Date: 24/10/2024
Salary: £150 - £200 Per Annum
Hours: Full Time
Type: Permanent
Job Requirements / Description
Qualifications
- Excellent problem-solving skills and team skills.
- 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.
Responsibilities
- 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.
- The NAIC Valuation Data team is responsible for all aspects of the quarterly and year-end processes and supporting other company initiatives.
- 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.
- 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.
Benefits
- You share your humanity, helping us build a diverse and inclusive work environment for everyone.
Share this job
John Hancock