Data Analyst

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.