Prepare for and practice interview questions from John Hancock.

John Hancock Interview Questions

John Hancock Interview Guides

<p>You are testing hundreds of hypotheses with many <em>t</em>-tests. What considerations should be made?</p>


<p>What is a key disadvantage of the F-test when compared to multiple t-tests?</p>

What is a key disadvantage of the F-test when compared to multiple t-tests?

Hundreds of Hypotheses

You are testing hundreds of hypotheses with many t-tests. What considerations should be made?

<p>Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.</p>

<p>How would you assess the validity of the result?</p>


Experiment Validity

<p>In an A/B test, how can you check if assignment to the various buckets was truly random?</p>


<p>In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?</p>

In an A/B test, which of the following is a common method to determine if the assignment to the test groups was truly random?

Random Bucketing

John Hancock Salaries by Position

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

<p>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 its helping our clients plan for their financial future, helping local communities grow stronger, or helping our employees chart a course for their careers, were 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</p>

<p>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 its helping our clients plan for their financial future, helping local communities grow stronger, or helping our employees chart a course for their careers, were 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</p>

<p>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</p>

<h3>Job Description </h3><p>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. </p><h3>The Opportunity </h3><p>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. </p><h3>Responsibilities </h3><ul><li>Providing data and reports for Line actuaries during quarterly and yearly reporting. </li><li>Managing ad-hoc data requests, state audits, AAT (Asset Adequacy Testing) data requests, and other data questions. </li><li>Working with the NAIC reporting team to provide and make changes as required. </li><li>Preparing and communicating data to be consumed by reporting teams to analyze and report financial results. </li><li>Conducting RMA (Reserve Movement Analysis) analysis and testing to ensure data is correct and on-time. </li><li>Performing data analysis and understanding the SQL and Qlik solutions. </li><li>Engaging with Line actuaries to understand requirements for sustainable solutions in Qlik/SQL/appropriate tools and technologies. </li><li>Understanding the Qlik driver file (where all the NAIC reporting business logic is stored) and making vital changes. </li><li>Identifying and driving process improvement ideas and improving the use of technology within our group (including VST/QlikView/SQL etc.). </li><li>Testing the data for all changes during SIT (System Integration Testing) and UAT (User Acceptance Testing) VST cycles. </li><li>Collaborating within large global VST teams primarily comprised of IT and Actuarial partners. </li><li>Attending the LTC/FP VST touchpoint calls to stay updated on changes and analyze their impact for NAIC. </li><li>Gaining experience in the business side of assigned LOB and broad financial data concepts. </li><li>Assisting with upcoming vital projects, including IFRS17 data restructure for NAIC reporting. </li><li>Assisting with ad-hoc requests and analyses as needed. </li> </ul><h3>Qualifications </h3><ul><li>Excellent problem-solving skills and team skills. </li><li>Ability to work with multiple teams. </li><li>Basic working experience and understanding of reporting tools such as Qlik/Power BI/Tableau. </li><li>Basic working experience and understanding of data warehousing, data models, and business intelligence tools. </li><li>Basic working experience and understanding of creating SQL queries or stored procedures. </li><li>Basic understanding of any programming language such as Python or R. </li><li>Effective communicator across multiple teams. </li><li>A Computer Science or Information Technology grad is preferred. </li> </ul><h3>Benefits </h3><p>You share your humanity, helping us build a diverse and inclusive work environment for everyone. </p><p>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. </p><p>Want to learn more about our company and our products? Visit our website: <a > </a> </p><p>John Hancock is an equal opportunity employer - AA/F/M/D/V </p>#J-18808-Ljbffr

John Hancock Interview Questions

John Hancock Interview Guides

John Hancock Interview Questions

John Hancock Salaries by Position

John Hancock Opening Jobs