Description:
The Actuarial Data & Reporting Analyst will work with insurance statistical data, internal business data and external data sources in support of the Actuarial Data & Reporting function specifically for regulatory reporting and other related internal initiatives such as openIDS and Cloverleaf Analytics Implementation.
The Actuarial Data & Reporting Analyst will work in a collaborative environment with data and software architects, software developers, actuaries, product developers, state regulators, Member Engagement Managers and AAIS Member companies. Core to this role is strong business and data analysis skills to understand the needs of key stakeholders, curiosity and ingenuity in how data can be accessed and used and the ability to apply best practices in data management, quality assurance and data operations to information management in a highly regulated business.

Responsibilities

• Regulatory Reporting: Understand regulatory reporting regulations and requirements, data sources, quality assurance, and reporting in the regulated insurance industry.
• Data Management: Ensure all data and reporting is well managed, accurate, and comprehensive meeting business and regulatory deadlines.
• Quality Assurance: Design and maintain data systems and databases to high-quality standards including continuous, automated quality assurance, fixing coding errors and other data-related problems. Participate in peer review. Analyze data relationships to determine data quality and statistical validity. Participate in and comply with data governance standards.
• Data Presentation: Analyze data from primary and secondary sources, reorganizing data into a format that can be easily read by either human or machine.
• Business Intelligence: Prepare reports for executive leadership that are accurate, timely, and effectively communicate trends, patterns, and predictions using relevant data.
• Documentation: Create and maintain appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary.
• Member Success: Provide customer support to AAIS Members regarding the quality of their data submissions.
• Manage the data intake process of statistical data from AAIS Member companies.
• Collaborate with Actuarial for automation of actuarial analyses and to develop analytic products that provide real value to AAIS.
• Data Catalogue: Collaborate with internal and external data customers to ensure that all data assets are properly organized, communicated, and used throughout the organization.
• Provide support to the organization in analyzing and visualizing large, complex, and unique data sets.
• Perform additional duties as assigned or requested.

Knowledge, Skills, and Abilities

• Ability to quickly become knowledgeable on AAIS’s data and industry position.
• Participate in key initiatives supporting underlying data capture and utilization opportunities.
• Establish working relationships with key technical leads throughout the organization and ensure ongoing alignment with their activities and the organization’s overall strategic direction.
• Ability to analyze data to determine data quality, statistical validity, and reporting readiness.
• Research data anomalies and develop recommendations to solve unique organizational and industry data issues.
• Working knowledge of Property and Casualty Insurance products and statistical data.
• Experience with business intelligence tools and analytic concepts to transform raw data into useful information.
• Previous exposure to working with large structured and unstructured data sets, including statistical analyses and data visualization.
• Entrepreneurial inclination to discover novel opportunities for applying analytical techniques to business problems across the insurance industry.
• Intermediate to advanced skills in writing SQL queries and working with databases.
• Excellent written and oral communication skills; must be capable of fully yet concisely articulating technical and data governance concepts to non-technical audiences.
• The ability to manage multiple priorities in parallel and meet agreed upon deadlines by communicating and adjusting workload and expectations in collaboration with the Director, Actuarial Data & Reporting.
• Problem Solving/Critical Thinking skills: making the best decisions possible given the data quality and time available.
• Strong analytical thinking and ability to quickly pick up new methods, tools and domain expertise.
• Strong collaboration and mentoring skills.
• Ability to communicate effectively across multiple channels and asynchronously in a remote-first working environment.

Requirements:

• Bachelor’s degree in Business, Math, Computer Science or other data engineering related disciplines.
• 5+ years full time experience in data analysis and SQL & Python programming.
• Snowflake experience is a plus.
• 7+ years property casualty insurance industry experience in an analytic or statistical capacity OR Master’s Degree in an analytic field.
• Exposure to, ongoing education and training in, and hands-on experience with Data Governance concepts and practice including analytic methods and tools.
• Experience in analytical models and leveraging data to make business decisions.
• Proficiency in Excel.
• A record of success and top-tier achievement in prior work and education experiences.
• Obtainment of or pursuing IDMA (Insurance Data Management Association) credentials.
• Minimum travel is required for annual all-company gatherings or team design sessions (up to 5% of the time)

• Regulatory Reporting: Understand regulatory reporting regulations and requirements, data sources, quality assurance, and reporting in the regulated insurance industry.
• Data Management: Ensure all data and reporting is well managed, accurate, and comprehensive meeting business and regulatory deadlines.
• Quality Assurance: Design and maintain data systems and databases to high-quality standards including continuous, automated quality assurance, fixing coding errors and other data-related problems. Participate in peer review. Analyze data relationships to determine data quality and statistical validity. Participate in and comply with data governance standards.
• Data Presentation: Analyze data from primary and secondary sources, reorganizing data into a format that can be easily read by either human or machine.
• Business Intelligence: Prepare reports for executive leadership that are accurate, timely, and effectively communicate trends, patterns, and predictions using relevant data.
• Documentation: Create and maintain appropriate documentation that allows stakeholders to understand the steps of the data analysis process and duplicate or replicate the analysis if necessary.
• Member Success: Provide customer support to AAIS Members regarding the quality of their data submissions.
• Manage the data intake process of statistical data from AAIS Member companies.
• Collaborate with Actuarial for automation of actuarial analyses and to develop analytic products that provide real value to AAIS.
• Data Catalogue: Collaborate with internal and external data customers to ensure that all data assets are properly organized, communicated, and used throughout the organization.
• Provide support to the organization in analyzing and visualizing large, complex, and unique data sets.
• Perform additional duties as assigned or requested