Senior Data Analyst

Argo; Chicago (IL); Presencial; USD 128.000 - 152.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Health insurance

401(k) matching

Professional development

Paid time off

Descripción de la vacante

Argo seeks a Senior Data Analyst to advance regulatory reporting, data quality, and analytics capabilities within the Shared Services organization in Chicago. The role owns end-to-end data transformation across policy, claims, underwriting, and financial data to ensure timely regulatory submissions and strong governance.

You will mentor analysts, partner with Compliance, Finance, and Data Engineering, and drive improvements in data platforms and reporting; experience in P&C insurance is highly

Formación

• Bachelor's degree in data science, statistics, business analytics, computer science, actuarial science, finance, or related field.
• 5+ years of progressive experience in data analysis, BI, analytics, regulatory reporting, or related functions in P&C insurance.
• Experience supporting regulatory reporting, statutory reporting, or financial reporting processes.
• Strong knowledge of insurance operations and data structures across policy, claims, underwriting, accounting, finance, or actuarial functions.
• Advanced SQL skills and experience with large-scale relational databases, data warehouses, and data transformation methods.

Responsabilidades

• Design advanced analyses to support regulatory reporting and compliance initiatives.
• Transform complex business requirements into scalable data solutions and insights.
• Analyze policy, claims, underwriting, financial, and operations data for accuracy and compliance.
• Develop and optimize SQL queries, data models, and datasets for performance and scalability.
• Collaborate with Data Engineering to design data enrichment, transformation, and integration solutions.
• Support and enhance data platforms, reporting processes, and analytics assets using modern data tech.
• Own data preparation, validation, and reconciliation for statutory reporting and regulatory filings.
• Develop expertise in P&C insurance operations and regulatory reporting requirements.
• Translate regulatory and business needs into sustainable data processes and controls.
• Diagnose data quality issues and implement sustainable corrective actions.
• Design analytical approaches for complex or evolving problems.
• Identify opportunities to automate reporting and improve data accessibility.

Conocimientos

SQL

Data analysis

Statistical modeling

BI concepts

Educación

Bachelor's degree

Herramientas

Snowflake

Python

Power BI

Tableau

Descripción del empleo

Company

Shared Services

Argo and Farm Family are specialty property and casualty insurance brands whose underwriting companies are wholly-owned subsidiaries of Clearbrook Holdings Inc. Argo and Farm Family partner with agents and brokers to provide insurance solutions that enable businesses to manage risks with confidence.

Job Description

The Senior Data Analyst plays a critical role in advancing the organization’s regulatory reporting, data quality, and analytical capabilities. This position owns the end-to-end transformation of complex policy, claims, underwriting, and financial data into accurate, timely, and compliant regulatory submissions while driving improvements in data processes, governance, and reporting standards. As a senior analytical professional, this role combines advanced data analysis, data engineering, insurance domain expertise, and business insight to solve complex data challenges, influence decision-making, and identify opportunities that improve operational effectiveness and regulatory compliance. The Senior Data Analyst serves as a trusted partner to business and technical stakeholders and provides mentorship and guidance to analysts across the organization.

Essential Responsibilities

• Design and execute advanced analyses to support regulatory reporting, compliance initiatives, and strategic business decisions.
• Transform complex business requirements into scalable data solutions, analytical frameworks, and actionable insights.
• Analyze policy, claims, underwriting, financial, and operational data to ensure accuracy, completeness, consistency, and regulatory compliance.
• Develop, optimize, and maintain complex SQL queries, data models, reconciliations, and datasets to improve performance, scalability, and reusability.
• Partner with Data Engineering and Application teams to design and implement data enrichment, transformation, and integration solutions.
• Support and enhance data platforms, reporting processes, and analytical assets using modern data technologies and best practices.
• Own data preparation, validation, and reconciliation activities supporting statutory reporting, regulatory filings, annual statement reporting, premium tax reporting, market conduct examinations, audits, and ad hoc regulatory requests.
• Develop deep expertise in Property & Casualty insurance operations, regulatory reporting requirements, and statutory accounting principles.
• Ensure analytical outputs align with regulatory expectations and support sound business decision-making.
• Translate regulatory and business requirements into sustainable data processes and controls.
• Independently diagnose data quality, integration, and reporting issues across multiple systems and business functions.
• Perform root-cause analysis and develop sustainable corrective actions that improve data integrity and reporting accuracy.
• Design analytical approaches for complex or ambiguous business problems where requirements may be incomplete or evolving.
• Identify opportunities to automate reporting, improve efficiency, and enhance data accessibility for business stakeholders.
• Build strong partnerships with Compliance, Finance, Underwriting, Claims, Actuarial, MGA Operations, Applications, and Data Engineering teams.
• Effectively communicate complex analytical findings to both technical and non-technical audiences.
• Develop clear narratives that connect data insights to regulatory, operational, and business outcomes.
• Challenge assumptions, provide data-driven recommendations, and influence prioritization of data and reporting initiatives.
• Champion data governance practices and contribute to the development of data standards, controls, documentation, and definitions.
• Establish and enhance data quality monitoring processes within assigned domains.
• Serve as a subject matter resource for analytical methodologies, reporting practices, and regulatory data requirements.
• Mentor and provide guidance to analysts by reviewing analytical approaches, sharing best practices, and supporting professional development.
• Promote a culture of continuous learning, collaboration, and analytical excellence.

Qualifications & Experience Required

• Bachelor's degree in data science, statistics, business analytics, computer science, actuarial science, finance, or a related quantitative field.
• 5+ years of progressive experience in data analysis, business intelligence, analytics, regulatory reporting, or related functions within the Property & Casualty insurance industry.
• Demonstrated experience supporting regulatory reporting, statutory reporting, compliance initiatives, or financial reporting processes.
• Strong knowledge of insurance operations and data structures across policy, claims, underwriting, accounting, finance, or actuarial functions.
• Advanced proficiency in SQL and experience working with large-scale relational databases, data warehouses, and data transformation methodologies.
• Experience performing complex data analysis, reconciliation, root-cause investigation, and data quality assessments.
• Ability to independently manage multiple priorities and deliver results in a fast-paced environment.
• Proven ability to influence stakeholders and collaborate effectively across technical and business teams.
• Strong verbal, written, presentation, and data storytelling skills.

Preferred Qualifications

• Master's degree in quantitative, analytical, or business-related discipline.
• Experience with Snowflake, Python, Power BI, Tableau, or similar analytical and visualization platforms.
• Experience with data governance frameworks, metadata management, data lineage, and data quality programs.
• Intermediate or advanced Property & Casualty insurance designations (CPCU, AINS, AU, API, or equivalent).
• Experience partnering with Actuarial teams and supporting actuarial, financial, or regulatory reporting processes.
• Familiarity with cloud-based data platforms and modern data engineering concepts.

Key Competencies

• Technical & Analytical Skills - Designs advanced analyses, metrics, and scalable data solutions while improving performance, quality, and reusability of datasets and reporting assets.
• Business Acumen & Domain Knowledge - Applies deep Property & Casualty insurance and regulatory expertise to connect analytical work with broader business objectives and outcomes.
• Problem Solving & Critical Thinking - Independently solves complex, ambiguous problems and develops analytical approaches from the ground up.
• Communication & Data Storytelling - Translates complex data into clear, compelling narratives that influence business decisions and drive action.
• Stakeholder Management & Influence - Builds trusted partnerships across functions, challenges assumptions constructively, and helps guide analytical priorities.
• Leadership & Mentorship - Provides informal leadership through mentoring, knowledge sharing, review of analytical work, and coaching of other analysts.
• Data Quality & Governance - Improves data quality standards, governance practices, and reporting controls within the domain.
• Strategic Thinking & Innovation - Connects analytics to broader organizational goals and identifies high‑… etc.

The base salary range provided below is for hires in those geographic areas only and will be commensurate with candidate experience. Pay ranges for candidates in other locations may differ based on the cost of labor in that location. In addition to base salary, this position is eligible for an annual bonus based on company and individual performance as well as a generous benefits package.

• Chicago Pay Range: $128010.00 - $152,184.00
• Omaha and Richmond Pay Range: $116,382.00 - $138,414.00
• Los Angeles and New York City Pay Range: $139,638.00 - $166,260.00

Please Note

Applicants must be legally authorized to work in the United States. At this time, we are not able to sponsor or assume sponsorship of employment visas.

If you have a disability under the Americans with Disabilities Act or similar state or local law and you wish to discuss potential reasonable accommodations related to applying for employment with us, please contact our Benefits Department at 210-321-8400.

Benefits And Compensation

We offer a competitive compensation package, performance-based incentives, and a comprehensive benefits program—including health, dental, vision, 401(k) with company match, paid time off, and professional development opportunities.

Core Values

At Clearbrook our Core Values are Integrity, Collaboration, Pursuit of Excellence and Forward Thinking. These values