Search Our Jobs

Search Remote Jobs

If searching for a remote/work from home position, please conduct your search by State or click “Search Remote Jobs”

Lead Statutory Transaction Reporting Analyst in Sun Prairie at QBE

Date Posted: 9/12/2018

Job Snapshot

  • Employee Type:
  • Location:
    Sun Prairie
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description

The purpose of the Lead Statutory Transaction Reporting Analyst is to collect, develop, analyze and distribute data, analysis and metrics from internal and external sources to support regulatory compliance, rate making, business decision-making and the achievement of company objectives. Serve as a technical resource by reviewing data and escalating issues as necessary to assist with problem-solving and meeting business needs and requirement.

Essential Job Responsibilities

  • Complete regulatory reports timely and accurately, ensuring statistical data edits have been validated and data has been balanced to General Ledger.  Act as an subject matter expert for offshore analysts to support in the completion of regulatory reports

  • Research and resolve data quality issues identified within regulatory reports.  Provide satisfactory responses to regulatory inquiries.  Communicate effectively with regulatory agencies and maintain strong working relationships

  • Understand the usage and relevance of QBE data sources and policy and claims admin systems in relation to regulatory reporting and ensure availability of statistical data for all relevant data sources and lines of business

  • Share institutional, industry and technical knowledge with team members and provide support as needed to ensure compliance and promote an environment of continuous improvement and learning

  • Lead efforts in support of the team’s strategic objectives and proactively identifying additional areas of opportunity

  • Assess impact to regulatory reporting work processes due to new product offerings, systems migrations, or changes to regulatory reporting requirements, collaborate with business partners and ensure appropriate solutions are implemented, while working with minimal oversight.

  • Support the development of business, technical and functional requirements to shape improvements to meet regulatory reporting.

  • Ensure reporting is in alignment with all legal and regulatory requirements and adhere to corporate standards and best practices

  • Review and evaluate internal processes for effectiveness and efficiency and recommend alternative approaches and solutions to enhance the consistency, quality and timeliness of reporting

  • Perform gap and impact analysis between current and desired stat to identify exposures that need to be addresses

  • Collaborate with key stakeholders to ensure statistical reporting

  • Facilitate operational excellence by researching existing documentation and reports to locate and capitalize on reusable data and promote streamlined, efficient data delivery

  • Deliver reliable reports by analyzing and testing data and escalating complex issues as required to troubleshoot errors and ensure valid information

  • Contribute to a positive environment by demonstrating cultural expectations and guiding leaders to reward performance and value “can do” people, accountability, diversity and inclusion, flexibility, continuous improvement, collaboration, creativity and fun

  • Adopt QBE values in personal work behaviors, decision-making, contributions and interpersonal interactions; manage own career development by soliciting feedback and valuing other perspectives

Requirements & Qualifications


  • Bachelor’s Degree or equivalent combination of education and work experience


  • 5+ years relevant experience
  • Experience working with Property and Casualty insurance products (including one or more of the following: Personal Lines, Commercial Property and Liability, Worker’s Compensation, Specialty Lines and/or Accident and Health)

Preferred Qualifications


  • Working knowledge of technology to control and safeguard the collection, organization, structure, processing and delivery of data
  • Working knowledge of Microsoft Office, including Functions and Macros in Excel and MS Access query design
  • Continuous improvement methodology and principles
  • Products and concepts relating to the insurance industry
  • Knowledge of policy and claims administration systems, data marts and other reporting sources
  • Proficient in SQL programming and SSIS to manage data loads
  • Familiarity with relational database structures
  • Familiarity with varying data sources and data file formats, such as fixed record formats, csv and delimited files


  • Use statistical techniques and a methodological approach to solve data issues
  • Analyze and synthesize data to form options and recommendations
  • Create and maintain current, accurate and readily accessible data in various formats
  • Understand the needs and goals of a customer and actively look for ways to meet them
  • Utilize effective research and investigative techniques
  • Willingness to help and/or assist


  • Choose a solution to a problem even in ambiguous or difficult situations; escalate issues when necessary
  • Clearly and confidently convey information to a wide audience
  • Follow established guidelines to focus on details and complete tasks attentively and thoroughly; manage one's own time
  • Build constructive and cooperative working relationships
  • Adapt and be flexible in a complex changing environment
  • Use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems

Travel Frequency

  • Infrequent (approximately 1-4 trips annually)

Number of Openings:


How to Apply:

To submit your application, click "Apply" and follow the step by step process.

Equal Employment Opportunity:

QBE is an equal opportunity employer and is required to comply with equal employment opportunity legislation in each jurisdiction it operates.


  1. Accountant Jobs
  2. Controller Jobs

The companies of QBE North America are committed to equal employment opportunities. All qualified applicants will receive consideration for employment without regard to age, disability, marital or parental status, national origin, citizenship, race, color, religion, sex, sexual orientation, or veteran status. All personal information contained in this application will be kept confidential as required by law.