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 ensure 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 design, 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 and design and implement data structures for use by the statistical reporting team.
• 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 $96,000-$158,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
•Lead efforts in support of the team's strategic objectives and proactively identifying additional areas of opportunity and enforcing team standards and best practices
•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 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
•Ensure efficient data flows and streamline processes to minimize manual data manipulation by staff
•Perform data profiling of new data sources, including range of values, appropriate usage of data, relationships between tables, identification of primary key fields and appropriate usage, granularity of data sources, and interpretation of transactions and coverages
•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
•Continually review and modify structure of statistical data sources to ensure alignment with enterprise data initiatives and future state roadmaps
•Assist with onboarding of new data sources to the statistical reporting server
•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 availability of statistical data for all relevant data sources and lines of business
Required Experience & Education
• 5 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
•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; mage 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
• 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 Knowledge
• Knowledge of policy and claims administration systems, data marts and other reporting sources
•Continuous improvement methodology and principles
•Products and concepts relating to the insurance industry
•Data Delivery-focus:
•Strong proficiency in SQL programming
•Familiarity with relational database structures and transactional data
•Working knowledge of Microsoft Office, including Functions and Macros in Excel and MS Access query design
•Data Management-focus:
•Proficient in 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
•Working knowledge of Microsoft Excel VBA and Macros
•Reporting-focus:
•Strong understanding of P&C statistical reporting requirements across all states and lines of business
•Working knowledge of Microsoft Office
•Knowledge of SQL programming
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 office22 weeks of paid leave for family growth, with 12 weeks available to all parents on a gender-equal basisCompetitive 401(k) program with company match up to 8%Well-being program including holistic wellbeing coaching, gym membership, confidential counselling, financial and legal adviceTuition Reimbursement for professional certifications, and continuing educationEmployee Network and Community – QBE actively supports six Employee Networks, and many ways to give back to your communityTo learn more, click here: Benefits | QBE US.
Why QBE? What if you could have a positive impact – at work and in the world?
At QBE, we’re enabling a more resilient future – for our customers, communities, environment, and for our people. We’re building momentum to achieve something significant and know our people are at the center of our success.
Our industry offers interesting and varied careers where you can help people to protect what matters most. As part of the QBE team, you’ll get to spend every day working with people who are passionate, talented and kind. And our international scale means we’re big enough for your ambitions, yet small enough for you to make a real impact.
Join us now, so you can be part of our success – and we can be part of yours!
https://www.linkedin.com/company/qbe-north-america/
Commitment to Diversity
QBE is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with QBE, please inform our Talent Acquisition team to let us know the nature of your accommodation request and your contact information.
Equal Employment Opportunity:
QBE provides equal employment opportunities to applicants and employees without regard to race; color; gender; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; protected veteran status; or disability or any other legally protected status.
Supplementary information
Skills:
Business Intelligence Applications, Claims Administration, Commercial Acumen, Critical Thinking, Customer Service, Data Modeling, Intentional collaboration, Managing performance, Problem Solving, Process Improvements, Regulatory Compliance, Relational Database Programming, Research Analysis, Risk Management, Stakeholder ManagementApplication Close Date: 19/06/2025 11:59 PMHow 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.