Senior Data Analyst - P&C Analytics & Dashboards

Clearbrook Group Services Inc.; New York (NY); On-site; USD 113,000 - 143,000; Full time

Benefits offered by this job

Health insurance

401(k) with company match

Paid time off

Professional development opportunities

Job summary

Clearbrook Group Services Inc. is seeking a Senior Data Analyst to collaborate with underwriting, product, actuarial, claims, and marketing teams in P&C Operations.

You will translate complex data into actionable insights, build data pipelines, and develop dashboards with Power BI to support strategic decisions. This 100% in-office role requires on-site work at a designated office during business hours in New York.

Qualifications

• Four to six years of relevant work experience.
• Bachelor’s degree in mathematics, computer science, data science, data analytics, or a related field.
• Equivalent work experience in a business or technical environment will be considered in lieu of a bachelor’s degree.
• Proficient in Python/PySpark, SQL (CTE, window functions) and Power BI using graphs, charts, and map features.
• Experience in data quality control/governance, data mining, and modeling.
• Working knowledge of emerging analytics technology (e.g., Agentic AI/ML concepts).
• Strong soft skills with clear, effective oral and written communication.

Responsibilities

• Partners with stakeholders to define business problems, translate data needs into analytical solutions, and ensure alignment between business objectives and data outputs.
• Develops and maintains methods to distribute management information, as appropriate, throughout P&C Operations using tools, standards, and platforms in use at the time with minimal guidance.
• Designs, develops, and maintains dashboards (Power BI), reports, and data products for use throughout P&C Operations using the tools, standards, and platforms in use at the time with minimal guidance.
• Develops and optimizes SQL queries, Python/PySpark scripts, and data pipelines to extract, transform, and validate data for analysis and reporting.
• Independently leads analytics initiatives, managing priorities, timelines, and deliverables from intake through deployment.
• Responds to support questions promptly, courteously, and accurately, with an analysis of the results and any issues or changes made with minimal guidance.
• Synthesizes analytical findings into clear insights and recommendations, tailoring communication for both technical and non-technical audiences.
• Ensure enterprise reporting and analytics adhere to defined data governance standards, business rules, and data quality expectations.
• Validates data accuracy and completeness across source systems and downstream reporting layers, identifying trends, anomalies, and data quality issues.
• Performs quality assurance checks to validate completeness and accuracy of data and/or deliverables for release with minimal guidance.
• Supports recurring operational data needs (e.g., month-end, quarter-end, and ongoing production reporting cycles) by ensuring timely, accurate delivery of analytics and reports.
• Identifies trends, patterns, and opportunities within data to support process improvements and strategic initiatives.

Skills

Soft skills

Communication

Team collaboration

Mentoring

Education

Bachelor's degree in mathematics or computer science or data analytics

Tools

Python/PySpark

SQL

Power BI

Microsoft Fabric

Snowflake

Visual Studio Code

Job description

Clearbrook Group Services Inc. is seeking a Senior Data Analyst to collaborate with underwriting, product, actuarial, claims, and marketing teams in P&C Operations.

You will translate complex data into actionable insights, build data pipelines, and develop dashboards with Power BI to support strategic decisions. This 100% in-office role requires on-site work at a designated office during business hours in New York.