John Hancock
Data Analyst
John Hancock, Boston, Massachusetts, us, 02298
Job Description
John Hancock is hiring a Data Analyst with 0 - 3 years of experience. Based in United States - Boston, MA with in-office ways of working. 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, including 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
Providing data and reports for Line actuaries during quarterly and yearly reporting. Managing ad-hoc data requests, state audits, AAT (Asset Adequacy Testing) data requests, and other data questions. Working with the NAIC reporting team to provide and make changes as required. Preparing and communicating data to be consumed by reporting teams to analyze and report financial results. Conducting RMA (Reserve Movement Analysis) analysis and testing to ensure data is correct and on-time. Performing data analysis and understanding the SQL and Qlik solutions. Engaging with Line actuaries to understand requirements for sustainable solutions in Qlik/SQL/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 changes during SIT (System Integration Testing) and UAT (User Acceptance Testing) VST cycles. Collaborating within large global VST teams primarily comprised of IT and Actuarial partners. Attending the LTC/FP VST touchpoint calls to stay updated on changes and analyze their impact for NAIC. Gaining experience in the business side of assigned LOB and broad financial data concepts. Assisting with upcoming vital projects, including IFRS17 data restructure for NAIC reporting. Assisting with ad-hoc requests and analyses as needed. Qualifications
Excellent problem-solving skills and team skills. Ability to work with multiple teams. Basic working experience and understanding of reporting tools such as Qlik/Power BI/Tableau. Basic working experience and understanding of data warehousing, 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. Effective communicator across multiple teams. A Computer Science or Information Technology grad is preferred. Benefits
You share your humanity, helping us build a diverse and inclusive work environment for everyone. 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. Want to learn more about our company and our products? Visit our website:
https://www.johnhancock.com John Hancock is an equal opportunity employer - AA/F/M/D/V
#J-18808-Ljbffr
John Hancock is hiring a Data Analyst with 0 - 3 years of experience. Based in United States - Boston, MA with in-office ways of working. 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, including 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
Providing data and reports for Line actuaries during quarterly and yearly reporting. Managing ad-hoc data requests, state audits, AAT (Asset Adequacy Testing) data requests, and other data questions. Working with the NAIC reporting team to provide and make changes as required. Preparing and communicating data to be consumed by reporting teams to analyze and report financial results. Conducting RMA (Reserve Movement Analysis) analysis and testing to ensure data is correct and on-time. Performing data analysis and understanding the SQL and Qlik solutions. Engaging with Line actuaries to understand requirements for sustainable solutions in Qlik/SQL/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 changes during SIT (System Integration Testing) and UAT (User Acceptance Testing) VST cycles. Collaborating within large global VST teams primarily comprised of IT and Actuarial partners. Attending the LTC/FP VST touchpoint calls to stay updated on changes and analyze their impact for NAIC. Gaining experience in the business side of assigned LOB and broad financial data concepts. Assisting with upcoming vital projects, including IFRS17 data restructure for NAIC reporting. Assisting with ad-hoc requests and analyses as needed. Qualifications
Excellent problem-solving skills and team skills. Ability to work with multiple teams. Basic working experience and understanding of reporting tools such as Qlik/Power BI/Tableau. Basic working experience and understanding of data warehousing, 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. Effective communicator across multiple teams. A Computer Science or Information Technology grad is preferred. Benefits
You share your humanity, helping us build a diverse and inclusive work environment for everyone. 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. Want to learn more about our company and our products? Visit our website:
https://www.johnhancock.com John Hancock is an equal opportunity employer - AA/F/M/D/V
#J-18808-Ljbffr