The Hartford · 1 month ago
Business Consultant
Hartford, CT
Full-time
Hybrid
Entry, Mid Level
$71K/yr - $106K/yr
2+ years expThe Hartford is an insurance company that is determined to make a difference, and they are seeking a Business Consultant. This role involves analyzing, managing, and optimizing data processes to support the Employee Benefits Sales & Relationship Management Organization, requiring strong technical skills and business acumen.
Auto InsuranceCommercial InsuranceEmployee BenefitsFinanceFinancial ServicesInsuranceLife InsuranceProperty Insurance
Responsibilities
Perform advanced data analysis to identify trends, anomalies, and opportunities for improvement
Ensure data quality through rigorous review and validation processes
Develop and maintain efficient data storage and retrieval strategies
Partner with developers and source system owners to design and execute data testing protocols
Provide guidance on best practices for data integration and system enhancements
Production Data Research & Troubleshooting
Proficient in utilizing advanced Excel functions (ie: pivot tables, macros, complex formulas) for testing, quality review, reporting and analysis
Skilled at reviewing, diagnosing and updating macros and formulas created by other team members
Familiarity with Salesforce.com
Manage and maintain SharePoint sites for document control and collaboration
Strong desire to learn AI capabilities that will further enhance current data assets
Apply knowledge of Employee Benefits products, including Life Insurance, Short Term Disability (STD), Long Term Disability (LTD), Supplemental Health Products & Specialty
Ability to interpret performance trends and deliver actionable insights to stakeholders
Support the data management and quality of Employee Benefits formal sales results (*Employer Group and Specialty Segments)* as well as Key Indicators *(Quote Activity, Close Ratio, Inventory Pipeline).*
This includes, but is not limited to ensuring Accuracy & Integrity of the data, source & code development, data oversight & troubleshooting, clear definitions etc
Support data testing and accuracy related to system, data feeds & process changes
Ad hoc report requests related to sales, quote activity, close ratio & inventory pipeline
Position involves growing responsibilities, including sales forecasting and planning development opportunities
Qualification
Required
Minimum 2-5 years in data analysis, quality review and business consulting roles, degree not required however preferred
Advanced proficiency in Excel with proven working experience
Ability to reverse engineer existing Excel VBA code
Familiarity with Sharepoint & Salesforce.com
Strong understanding of data management principles
Experience in data research and troubleshooting, working across all business lines with proficient follow-up & follow-through
Proven ability to quickly adjust focus and respond effectively to urgent, high priority tasks via strong multi-tasking skills
Strong communication and collaboration skills with the ability to work across technical and business teams
Detail oriented and proficient in analytical and problem-solving skills
Benefits
Short-term or annual bonuses
Long-term incentives
On-the-spot recognition
Company
The Hartford
The Hartford is an industry leading provider of property and casualty insurance, group benefits and mutual funds.
10001+ employees
Funding
Current Stage
Public CompanyTotal Funding
unknown1995-12-15IPO
Leadership Team
Christopher Swift
Chief Executive Officer
Recent News
2025-12-09
2025-12-08
EIN Presswire
2025-12-02
Company data provided by crunchbase