Senior Statutory Transaction Analyst

Primary DetailsTime Type: Full time

Worker Type: Employee

Statutory Transaction Analyst

The Opportunity: This role is responsible for providing subject matter expertise to the statistical reporting team in support of regulatory reporting, ensuring timely and accurate regulatory reporting, satisfactorily resolving inquiries with regulators and monitoring and providing feedback relating to adherence to team standards and best practices. You will support the availability of SQL-based queries and accuracy of query output for use by the statistical reporting team, including new query development and query maintenance while working within the strategic framework to ensure efficient data flows and consistency in reporting. You will maintain and execute ETL processes, ensuring data completeness, reasonableness and consistency for all in scope data sources, perform reconciliation of source data to the General Ledger.

• Location/Work Arrangement: This role requires hybrid presence (2-3 days/week) in either our Chicago, IL office or our Sun Prairie, WI office.

• The starting salary range for this role is between $69,500-$114,500, depending on experience.

Your New Role:

• Act as subject matter expert for statistical reporting team members, providing guidance on reconciling to General Ledger, resolving edits and inquiries from regulators
•Ensure timely and accurate 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 with regulators and third parties
•Understand the usage and relevance of QBE data sources, including data warehouses 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
•Support the team's strategic objectives while consistency following team standards and best practices
•Support the development of business, technical and functional requirements to implement system enhancements and ensure compliance with regulatory reporting
•Review and evaluate internal processes for effectiveness and efficiency and recommend alternative approaches and solutions to enhance the consistency, quality and timeliness of reporting
•Data Delivery-focus:
•Ensure timely and accurate availability of data for all relevant data sources to team members in support of regulatory reporting
•Create and maintain SQL queries following team standards, version control and best practices
•Ensure all query logic meets requirements from applicable statistical plans and bulletins and validate test files with regulators as required
•Data Management-focus:
•Create and maintain automated data load packages using SSIS for statistical data sources
•Establish and maintain standards and best practices to ensure consistency of data across the statistical reporting server
•Troubleshoot data quality issues within source files and work with business partners to remediate as required
•Perform monthly reconciliation of premiums and losses to General Ledger, collaborate with business partners to remediate any material variances, track reconciliation results for each data source and provide data quality reports and updates to management
•Reporting-focus:
•Ensure timely and accurate 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 with regulators and third parties
•Perform reconciliation of premiums and losses to General Ledger for each regulatory report
•Understand the usage and relevance of QBE data sources, including data warehouses and policy and claims admin systems in relation to regulatory reporting and ensure inclusion of statistical data for all relevant data sources and lines of business

Required Experience & Education

• 4 years relevant experience
• Bachelor's Degree or equivalent combination of education and work experience

Preferred Competencies/Skills

• 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 others
•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

Preferred Experience

•Liability reporting experience
•Quantitative data collection & analysis background
•Increasing levels of responsibility

Preferred Knowledge

• Knowledge of policy and claims administration systems, data marts and other reporting sources
•Products and concepts relating to the insurance industry
•Data Delivery-focus:
•Proficiency in SQL programming
•Familiarity with relational database structures
•Working knowledge of Microsoft Office, including Functions and Macros in Excel and MS Access query design
•Data Management-focus:
•Working knowledge of SSIS and SQL programming to extract, transform and load data
•Familiarity with varying data sources and data file formats, such as fixed record formats, csv, delimited files as well as FTP processes
•Experience executing Microsoft Excel VBA procedures and Macros
•Reporting-focus:
•Understanding of P&C statistical reporting requirements
•Working knowledge of Microsoft Office
•Experience executing SQL queries or equivalent query tool

Why Join Us?

This is a unique opportunity to become a key contributor to our global tax team, driving innovation and excellence in state and local tax processes.  We value professional growth, cross-functional collaboration, and leadership development, creating an environment where innovation thrives and your impact is recognized.

Compensation Package: The salary range for this role is provided above. This is the national range for location(s) listed. The salary offer will be decided based on the role's complexity, its location, and the candidate’s professional background, including their education and experience. Beyond the base salary, regular full-time and part-time employees will also be eligible for QBE’s annual discretionary bonus plan based on business and individual performance. We encourage all candidates to apply, even if their salary expectations fall outside of this range, as we are committed to finding the right fit for our team.

QBE Benefits: We offer a range of benefits to help provide holistic support for your work life, whatever your circumstances. As a QBE employee you will have access to:

• Hybrid Working – a mix of working from home and in the office
• 22 weeks of paid leave for family growth, with 12 weeks available to all parents on a gender-equal basis
• Competitive 401(k) program with company match up to 8%
• Well-being program including holistic wellbeing coaching, gym membership, confidential counselling, financial and legal advice
• Tuition Reimbursement for professional certifications, and continuing education
• Employee Network and Community – QBE actively supports six Employee Networks, and many ways to give back to your community

To learn more, click here: Benefits | QBE US.

Skills:

Business Intelligence Applications, Claims Administration, Commercial Acumen, Critical Thinking, Customer Service, Data Analysis, Data Modeling, Intentional collaboration, Managing performance, Problem Solving, Process Improvements, Regulatory Compliance, Research Analysis, Risk Management, Stakeholder ManagementApplication Close Date: 24/07/2025 11:59 PM

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.