Business Consultant

The Hartford•Hartford, CT

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. The Hartford is seeking a Business Consultant. The Business Consultant will serve as a strategic partner in analyzing, managing and optimizing data processes to support Employee Benefits Sales & Relationship Management Organization. This role requires advanced technical skills (Non IT), strong business acumen, and the ability to collaborate across the organization to ensure data integrity, quality, efficient storage, and effective data retrieval.

Requirements

Experience: Minimum 2-5 years in data analysis, quality review and business consulting roles, degree not required however preferred.
Technical Skills: 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.

Nice To Haves

Ideal candidate will reside in Connecticut and will have the ability to travel into office

Responsibilities

Data Analysis & Quality Management 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.
Collaboration & Testing 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
Technical Expertise 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.
Business Acumen 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.