Actuarial Data & Reporting Data Analytics/Programmer II

AAIS (American Association of Insurance Services); United States; On-site; USD 111,000 - 135,000; Full time

Job summary

AAIS, the American Association of Insurance Services, seeks an experienced AD & R Analytics/Programmer II to support regulatory reporting and internal data initiatives. You will work with actuarial and product teams in an agile setup on data harmonization and analytics to drive value for members.

You will analyze large data sets, develop data products, and ensure quality and governance while collaborating with stakeholders to deliver timely, accurate insights for leadership and regulators.

Qualifications

• Bachelor's degree in Business, Math, CS, or related field; minimum.
• 5+ years of data analysis and SQL & Python programming experience.
• Experience with Excel and Power BI; knowledge of data governance is a plus.

Responsibilities

• Regulatory Reporting: understand regulations, data sources, QA, and reporting in regulated insurance.
• Data Management: ensure data and reporting are accurate, complete, and timely.
• Quality Assurance: design/maintain data systems with automated QA and data governance.
• Data Presentation: organize data for human or machine readability and insights.
• Business Intelligence: provide leadership with timely, accurate trend analyses and predictions.
• Documentation: maintain clear, reproducible data analysis docs and workflows.
• Collaborate with Actuarial for automation of analyses and data harmonization.
• Data Catalogue: organize assets and ensure accessibility across teams.

Skills

SQL queries

Python programming

Power BI

Excel (Microsoft 365)

Data governance concepts

Education

Bachelor's degree in Business, Math, CS, or related data engineering discipline

Master’s degree in analytics or related field

Tools

Databricks

Power BI

SQL databases

Microsoft 360 suite

Job 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.

Description

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.

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.

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.

Notice of AI Use in Job Application Review

As part of our commitment in creating a fair, efficient, and consistent hiring process we may use artificial intelligence (AI) to help our recruiting teams organize, summarize, and analyze information provided by candidates, including resumes, application responses, and other materials submitted during the application process.AI may be used to identify patterns, highlight relevant skills, and experience, and assist in comparing a candidate’s qualifications with the requirement of a specific role. These tools are to improve efficiency and consistency while supporting more informed hiring decisions, which will ultimately be made by the hiring team.