Performance Analytics Consultant

The Hartford•Columbus, OH

2d•Hybrid

About The Position

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future. Are you looking to begin or further your career in Performance Analytics while supporting a growing Business with strong aspirational goals? Are you passionate about solving complex problems and unlocking insights using analytical techniques and tools? If so, then this role might be for you. The Performance Analytics Consultant will support initiatives, processes, and analytical duties for the Middle and Large Business’ Sales & Distribution team, as well as broader Middle and Large bodies of work. They will contribute to the cultivated culture of data driven decision making and accountability by supporting strategic initiative execution, resulting in revenue growth and/or increased profitability. As a true partner to their Business and Data Science & Analytics colleagues, they will leverage the power of data and analytics to support the pursuit of Middle and Large Business’ objectives. This successful candidate will execute on a wide array of reporting, deep-dive analytics, diagnostics, and root cause problem solving to help drive the Performance Analytics roadmap forward. Other responsibilities may include collaboratively executing on bodies of work with other organizations such as Data Science and Engineering, Business Intelligence, Asset Ownership, Actuarial, Finance, Information Technology, and other project-related organizations. This role will have a Hybrid work schedule, with the expectation of working in an office (Hartford, CT , Columbus, OH, Chicago, IL or Charlotte, NC) 3 days a week (Tuesday through Thursday). The Ideal Candidate Is curious, analytical, and eager to understand how Middle and Large Underwriting and Operations work Demonstrates strong SQL skills and confidence in independently sourcing and transforming data Demonstrates a working knowledge of Python Demonstrates a clear desire to incorporate various types and levels of analytical techniques to accomplish their bodies of work Has experience with visualization and reporting tools (e.g., Power BI, Tableau) Understands or can quickly learn financial and operational performance drivers in specialty insurance Translates data into clear, compelling stories tailored to both technical and executive audiences Asks thoughtful questions, builds strong cross‑functional partnerships, and contributes to elevating analytics maturity Is open and curious to learn new analytical and technological skills, including, but not limited to, additional coding language and Agentic AI-related platforms

Requirements

Working Proficiency in SQL, with experience in Snowflake and Oracle
Working knowledge of Python for analytical and automation tasks
Knowledge of Data Warehousing/Relational Databases
Strong written and verbal communication skills
Self‑motivated; can work independently and in teams
Bachelor’s degree required, preferably in Data Analytics, Statistics, Finance, Economics, Mathematics, Business, or a related quantitative field
Candidate must be authorized to work in the US without company sponsorship.
The company will not support the STEM OPT I-983 Training Plan endorsement for this position.

Nice To Haves

Experience with visualization tools such as Power BI / Tableau, development experience
Knowledge of Generative and Agentic AI solutions
Familiarity with Agile practices

Responsibilities

Analyze key KPIs and performance trends, identifying meaningful shifts and diagnosing underlying causes
Support monthly routines for reporting and analytics
Tackle ad-hoc questions with a clear understanding of the data as well as the business context and story, enabling data-driven decision making for our business partners
Develop an understanding of Data Science solutions and other technologies that support and transform Sales and Distribution and Middle and Large Underwriting
Partner with and support Data Engineering professionals to ensure data quality and shared understanding of data assets
Independently source, transform, and validate data using SQL; maintain proactive communication with engineering partners on data quality and structure
Independently execute on reoccurring routines as well as ad-hoc analytical/reporting-based requests
Conduct analyses to identify meaningful patterns and insights, leveraging a number of different analytical techniques and tools
Present insights and recommendations through polished PowerPoint materials tailored to varying technical and leadership levels
Combine and reconcile data from multiple sources, developing a strong understanding of Middle and Large data assets, lineage, and quality considerations.
Build trusted working relationships with Underwriting, Product, Actuarial, Claims, and Finance through reliable analysis, open communication, and consistent delivery
Respond to ad‑hoc analytical requests, providing clarity on definitions, methods, and drivers; offer guidance on KPI interpretation and visualization best practices
Maintain strong, clear documentation of work‑effort progress and analysis activities
Adhere to and promote strong agile practices