"Alerted.org

Business Consultant - BB08AE

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.

Key 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.

Specific Responsibilities:

+ 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.

Qualifications:

+ 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.

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

This role can have a Hybrid or Remote work arrangement. Candidates who live near one of our office locations will have the expectation of working in an office 3 days a week (Tuesday through Thursday).   Candidates who do not live near an office will have a remote work arrangement, with the expectation of coming into an office as business needs arise.

Compensation

The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford’s total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is:

$70,960 - $106,440

Equal Opportunity Employer/Sex/Race/Color/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us (https://www.thehartford.com/about-us) | Our Culture (https://www.thehartford.com/about-us/corporate-culture) | What It’s Like to Work Here (https://www.thehartford.com/careers/our-employees) | Perks & Benefits (https://www.thehartford.com/careers/benefits)

Every day, a day to do right.

Showing up for people isn’t just what we do. It’s who we are – and have been for more than 200 years. We’re devoted to finding innovative ways to serve our customers, communities and employees—continually asking ourselves what more we can do.

Is our policy language as simple and inclusive as it can be? Can we better help businesses navigate our ever-changing world? What else can we do to destigmatize mental health in the workplace? Can we make our communities more equitable?

That we can rise to the challenge of these questions is due in no small part to our company values that our employees have shaped and defined.

And while how we contribute looks different for each of us, it’s these values that drive all of us to do more and to do better every day.

About Us (https://www.thehartford.com/about-us)

Our Culture

What It’s Like to Work Here (https://www.thehartford.com/careers/our-employees)

Perks & Benefits

Legal Notice (https://www.thehartford.com/legal-notice)

Accessibility Statement Producer Compensation (https://www.thehartford.com/producer-compensation)

EEO

Privacy Policy (https://www.thehartford.com/online-privacy-policy)

California Privacy Policy

Your California Privacy Choices (https://www.thehartford.com/data-privacy-opt-out-form)

International Privacy Policy

Canadian Privacy Policy (https://www.thehartford.com/canadian-privacy-policy)

Unincorporated Areas of LA County, CA (Applicant Information)

MA Applicant Notice (https://www.thehartford.com/ma-lie-detector)

Hartford India Prospective Personnel Privacy Notice