Actuarial Data & Reporting Data Analytics/Programmer II

Aaisonline; United States; Remote; USD 111,000 - 135,000; Full time

Job summary

AAIS is seeking an Actuarial Data & Reporting Data Analytics/Programmer II to support regulatory reporting and data harmonization tasks. You will work with insurance statistical data, internal data, and external sources in a collaborative agile environment with actuaries, product developers, regulators, and Members.

The role requires strong SQL and Python programming, data analysis, and experience with BI tools like Power BI.

Qualifications

• Minimum 5+ years of data analysis experience with SQL and Python.
• Proficiency in Excel and Microsoft 360 suite, including Power BI.
• Experience with Databricks is a plus.
• Knowledge of Data Governance concepts and practices.

Responsibilities

• Regulatory reporting - understand data sources and regulatory requirements.
• Data management - ensure data accuracy and timely delivery.
• Quality assurance - design and maintain data systems with automated QA.
• Data presentation - format data for human or machine consumption.
• Business Intelligence - deliver accurate, timely executive reports.
• Documentation - maintain reproducible analysis steps.
• Collaboration with actuarial for automation and data harmonization.
• Data catalog - organize data assets across the organization.
• Support analysis and visualization of large data sets.
• Perform additional duties as assigned.

Skills

SQL

Python

Data analysis

Data visualization

Communication

Critical thinking

Team collaboration

Education

Bachelor's degree in Business/Math/CS

Master’s Degree in analytic field

Tools

Power BI

Databricks

Job description

All Jobs > Actuarial Data & Reporting Data Analytics/Programmer II

Fully Remote • Remote Worker - N/A

Description

About AAIS

Since 1936, American Association of Insurance Services("AAIS") has served the property and casualty insurance industry as the only national not-for-profit advisory organization governed by its member companies. We are committed to evolving with changes in the insurance industry, adding value to our members, regulators, and the industry with responsive products and insights.

The Actuarial Sciences team at AAIS is actively involved in product research and development, assisting the product team, and advising leadership on market trends, legal issues, and regulatory interpretations. As a member of this team, you will be stretched beyond the traditional in-house counsel role and challenged to develop skills in business intelligence, strategic planning, and marketing.

Purpose

The AD & R Analytics/Programmer II 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 Data Harmonization.

The AD & R Analytics Programmer II will work in an agile, collaborative environment with data and software architects, software developers, actuaries, product developers, state regulators, Member Engagement Managers and Members. Core to this role are strong business and data analysis skills in order 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 are well managed, accurate, and complete, 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
• Collaborate with Actuarial for automation of actuarial analyses and to develop analytic products that provide real value to AAIS, including Data Harmonization and testing processes
• 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 conversant in AAIS’s data and industry position.
• 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.

Requirements

• Bachelor's degree in Business, Math, Computer Science, or other data engineering-related discipline.
• 5+ years of full-time experience in data analysis and SQL & Python programming.
• Proficiency in Excel and Microsoft 360 suite, including Power BI
• Databricks experience is a plus.
• 7+ years of 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.
• A record of success and top-tier achievement in prior work and education experiences.
• Minimum travel is required for annual all-company gatherings or team design sessions (up to 5% of the time)

Minimum starting base of $123,000, with upward flexibility based on skills and experience + 10% annual bonus.

Salary Description

Min $123k base; see full pay details in job post.