Back to jobs

Actuarial Data & Reporting Data Analytics/Programmer II

Pay
$123,000/yearAnnual period assumed — pay source
Salary Description Min $123k base; see full pay details in job post.
Read the full posting
Work setting
Working pattern needs review — work setting source
Listed location: Remote Worker - N/A
Work setup in the employer’s posting: Hybrid
From the employer’s posting
Employment
Not stated

What you’ll work on

Full posting
  • Produce accurate, timely regulatory reports and executive dashboards

  • Design and maintain databases with automated quality assurance checks

  • Fix coding errors and data problems, and take part in peer review

  • Write documentation so analysis steps can be repeated

  • Support members on the quality of their data submissions

From the employer’s posting
Prepare reports for executive leadership that are accurate, timely, and effectively communicate trends, patterns, and predictions using relevant data.
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.
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
provide customer support to AAIS Members regarding the quality of their data submissions

What you’ll bring

All qualifications

Core experience

  • 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
  • 7+ years of property casualty insurance industry experience in an analytic or statistical capacity OR Master’s Degree in an analytic field.
  • Experience in analytical models and leveraging data to make business decisions.
Qualification wording
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
7+ years of property casualty insurance industry experience in an analytic or statistical capacity OR Master’s Degree in an analytic field.
Experience in analytical models and leveraging data to make business decisions.
Education & alternatives
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.
- 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.

About American Association of Insurance Services

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.

In the employer’s words · Read in context

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
5
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

American Association of Insurance Services is hiring

3 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • R
  • SQL
  • Databricks
  • Excel
  • Power BI
Where the posting names them
- 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
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.
- 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.
- 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.
- 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.

Your next step

Complete your application on recruiting.paylocity.com. The employer’s form will show what is required.

Applying through Paylocity

  • “Upload your resume and we’ll automatically fill out your application”: the form fills itself from your file, so check it before sending.

Already applied? Track this application

Job description

View original posting ↗

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Salary Description Min $123k base; see full pay details in job post.
Location & working pattern

Remote Worker - N/A

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.