Lead Statutory Transaction Reporting Analyst

$96,000 - $158,500/Yr

QBE Insurance Group - Sun Prairie, WI

Full-time - Mid Level

Hybrid - Sun Prairie, WI

Insurance Carriers and Related Activities

About the position

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.

Responsibilities

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

Requirements

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

Nice-to-haves

• 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

Benefits

• 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