Senior Excel Reporting Analyst Jobs (NOW HIRING)

Reporting Analyst

Job Description

The Reporting Analyst supports regulatory reporting, statistical data submissions, rating maintenance, and data management activities for insurance-related products. This role ensures that critical reporting is completed accurately, completely, and on time across multiple jurisdictions while supporting regulatory compliance. The analyst works closely with Finance, Actuarial, Product, Legal, IT, and Reporting teams to manage reporting requirements, maintain rating structures, and identify opportunities for process improvement and automation. The position is ideal for a highly analytical, organized, and technically savvy professional with strong data validation and reporting skills.

Responsibilities

• Prepare, validate, and submit required statistical reports to regulatory agencies and industry reporting organizations.
• Manage quarterly, annual, and ad hoc data submissions, ensuring compliance with reporting requirements and deadlines.
• Coordinate with business partners and technical teams to gather, extract, validate, and reconcile data from multiple systems.
• Maintain supporting documentation, audit trails, and reporting records to meet compliance and regulatory standards.
• Monitor regulatory and reporting updates and assist in implementing required changes to reporting processes and data structures.
• Extract and analyze data from various systems, databases, and reporting tools to support internal and external reporting needs.
• Perform data reconciliation and quality assurance reviews to ensure completeness, accuracy, and consistency of reported data.
• Investigate discrepancies, resolve data issues, and recommend corrective actions to improve data quality and integrity.
• Support internal reporting requirements while maintaining a high level of data integrity and control.
• Assist with the implementation and maintenance of rating tables, setup tables, and rating algorithms for insurance products.
• Support the development and documentation of rate and rule changes, including preparation of supporting materials.
• Collaborate with Product and Pricing teams to prepare exhibits, filing support materials, and documentation for regulatory filings.
• Maintain appropriate controls, approvals, and audit documentation for system updates and rating changes.
• Assist with regulatory examinations, audits, and information requests from state agencies and other governing organizations.
• Work closely with Legal, Finance, and business stakeholders to compile and provide requested documentation for audits and examinations.
• Support policy assessment, surcharge reporting, and related compliance activities.
• Organize and maintain records necessary for audit readiness and ongoing compliance.
• Identify opportunities to streamline reporting processes and improve efficiency through automation and enhanced reporting solutions.
• Assist in improving data workflows and reporting capabilities across the organization.
• Recommend enhancements that reduce manual effort, strengthen controls, and improve reporting accuracy.

Essential Skills

• At least 3 years of experience in data reporting, financial reporting, regulatory reporting, analytics, insurance operations, accounting, finance, actuarial support, or a similar analytical role.
• Hands-on experience extracting, validating, reconciling, and analyzing data from multiple systems and data sources.
• Advanced proficiency in Microsoft Excel, including use of formulas, lookups, pivot tables, and data analysis functions.
• Strong attention to detail with the ability to identify discrepancies and ensure data accuracy and completeness.
• Excellent time management skills and the ability to manage multiple reporting deadlines simultaneously.
• Strong problem-solving skills with a willingness to ask questions and seek clarification to gain a full understanding of requirements.
• Ability to work independently with minimal supervision while maintaining high quality standards.
• Experience with reporting and data-related activities in accounting, finance, or actuarial support environments.
• Comfort working with large data sets and complex reporting requirements.
• Effective communication skills to collaborate with cross-functional teams such as Finance, Actuarial, Product, Legal, IT, and Reporting.

Additional Skills & Qualifications

• Experience working in insurance, financial services, actuarial, tax, compliance, or regulatory reporting environments.
• Familiarity with reporting and business intelligence tools such as Power BI.
• Experience working with data warehouses and enterprise business systems.
• Knowledge of rating structures, insurance filings, or statistical reporting processes.
• Exposure to process improvement or automation initiatives focused on reporting and data workflows.
• Experience with data extraction and reporting platforms.
• Background in accounting, finance, actuarial, pricing, compliance, or audit-related functions.
• Ability to contribute to the design and enhancement of reporting solutions and workflows.
• Comfort collaborating with Finance, Tax, Reporting, and Actuarial stakeholders in a cross-functional environment.

Work Environment

This role follows a Monday–Friday schedule with flexible hours, typically ranging from approximately 7:00 a.m.–3:30 p.m. to 8:30 a.m.–5:00 p.m. The position is based in a hybrid work environment that includes roughly 60% onsite presence, offering a balance between in-office collaboration and remote work. The work setting is highly collaborative, with regular interaction among Finance, Tax, Reporting, Actuarial, Product, Legal, and IT stakeholders. The environment supports the use of modern technologies, including Microsoft Excel, data warehouse reporting tools, enterprise business systems, and data extraction and reporting platforms. There is a strong emphasis on professional development, with opportunities for long-term growth and potential conversion to a permanent position.

This is a Contract to Hire position based out of Neenah, WI.

The pay range for this position is $24.00 - $26.00/hr.

Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
• Medical, dental & vision
• Critical Illness, Accident, and Hospital
• 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
• Life Insurance (Voluntary Life & AD&D for the employee and dependents)
• Short and long-term disability
• Health Spending Account (HSA)
• Transportation benefits
• Employee Assistance Program
• Time Off/Leave (PTO, Vacation or Sick Leave)

This is a hybrid position in Neenah,WI.

This position is anticipated to close on Jul 16, 2026.

Aston Carter provides world-class corporate talent solutions to thousands of clients across the globe. Specialized in accounting, finance, human resources, talent acquisition, procurement, supply chain and select administrative professions, we extend the capabilities of industry-leading companies. We draw on our deep recruiting expertise and expansive network to meet the evolving needs of our clients and talent community with agility and excellence. With offices across the U.S., Canada, Asia Pacific and Europe, Aston Carter serves many of the Fortune 500. We are proud to be a ClearlyRated Best of Staffing® Platinum Award winner for both client and talent service.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

If you would like to request a reasonable accommodation, such as the modification or adjustment of the job application process or interviewing process due to a disability, please email astoncarteraccommodation@astoncarter.com for other accommodation options.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Massachusetts Lie Detector: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.