Demo

Business Data Analyst

The Hartford
Columbus, OH Full Time
POSTED ON 2/4/2025
AVAILABLE BEFORE 3/5/2025
Consultant Bus Data Analysis - GA08BE

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.

Join The Hartford’s Enterprise Data Services department with our fast-paced talented Agile team to unlock Data Capabilities for our Sales and Distribution Business. We use both Legacy and the latest Cloud technologies, software engineering practices, Agile delivery framework, and are passionate about technology building well architected innovative solutions driving optimal business value generation. The successful candidate will leverage data analytics to provide strategic insights, helping The Hartford and the Sales and Distribution Team make informed business decisions. The Business Data Analyst will work closely with cross functional teams to understand their needs, translate business requirements into data models, and deliver actionable insights through reports and dashboards.

Responsibilities

  • Analyze sales trends and other KPI's such as sales volume, premiums, lead times etc, to obtain various insights into sales strategies and promotions.
  • Help sales forecast based on historical data, market trends, and seasonality to support demand planning.
  • Use predictive analytics to anticipate changes in demand patterns, helping the business adapt its sales and distribution approach.
  • Assistant defining data architecture and data pipeline requirements to ensure relevant data is collected and processed effectively.
  • Use data to provide insights into customer retention, churn analysis and cross selling or upselling opportunities.
  • Analyze large data sets to extract meaningful insights that drive business growth.
  • Create and maintain data models, dashboards, and reports to visualize scheme metrics.
  • Collaborate with various departments to understand their data needs and ensure accurate data collection.
  • Translate business requirements into analytical solutions for IT teams.
  • Train end users on reporting tools and data interpretation, enabling them to make data-driven decisions.
  • Maintain data mapping documents, business matrix and/or other data design artifacts that define business data requirements and transformation rules
  • Work in an agile environment, adapting to changing requirements and collaborating with cross-functional teams. 
  • Create and implement end-to-end testing plans, partnering heavily with the Sales and Distribution teams to consider downstream impacts and ensure data quality throughout the testing process. 
  • Demonstrate a proactive approach to personal and professional development, with a commitment to learning and adapting in a dynamic business landscape.

Qualifications

  • Proficiency with data analysis tools like SQL, Python, Erwin Data Manager or similar data modelling tools.
  • Experience with data visualization tools such as Tableau, Power BI, or similar platforms.
  • Experience working with databases and data warehouses such as SQL Server, MySQL or Snowflake.
  • Familiarity with ETL (Extract – Transform - Load) processes.
  • Bachelor's degree in data Analytics or Computer science or related field.
  • 2 years or more experience as a Business Data Analyst or in a similar role.
  • Strong analytical and problem-solving skills. Ability to translate complex data into clear insights and recommendations.
  • Excellent communication skills with the ability to present data to non-technical audiences.

Preferred Skills

  • Familiarity with CRM systems (example Salesforce or ERP systems).
  • Experience in specific industry such as insurance or finance is advantageous.
  • Cloud certifications such as AWS or Snowflake is a plus

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.

This role will have a Hybrid work arrangement, with the expectation of working in an office location (Hartford, CT – Charlotte, NC – Columbus, OH) 3 days a week (Tuesday through Thursday).

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:

$77,360 - $116,040

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us | Culture & Employee Insights | Diversity, Equity and Inclusion | Benefits

Salary : $77,360 - $116,040

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Business Data Analyst?

Sign up to receive alerts about other jobs on the Business Data Analyst career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$80,838 - $103,226
Income Estimation: 
$98,772 - $126,519
Income Estimation: 
$113,567 - $162,206
Income Estimation: 
$80,838 - $103,226
Income Estimation: 
$98,772 - $126,519
Income Estimation: 
$113,567 - $162,206
Income Estimation: 
$98,772 - $126,519
Income Estimation: 
$124,737 - $157,493
Income Estimation: 
$132,928 - $192,066
Income Estimation: 
$135,553 - $179,566
Income Estimation: 
$180,040 - $239,859
Income Estimation: 
$301,033 - $439,918
Income Estimation: 
$66,720 - $84,360
Income Estimation: 
$80,838 - $103,226
Income Estimation: 
$85,534 - $118,479
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at The Hartford

The Hartford
Hired Organization Address Windsor, CT Full Time
Sr Admin Asst - DA10AN We're determined to make a difference and are proud to be an insurance company that goes well bey...
The Hartford
Hired Organization Address Creve Coeur, MO Full Time
Account Manager - OA09HN Associate Account Manager - OA10FN We’re determined to make a difference and are proud to be an...
The Hartford
Hired Organization Address Chicago, IL Full Time
Account Manager - OA09HN Associate Account Manager - OA10FN We’re determined to make a difference and are proud to be an...
The Hartford
Hired Organization Address Chicago, IL Full Time
Staff Software Engineer - IE07IE Senior Staff Software Engineer - IE07HE We’re determined to make a difference and are p...

Not the job you're looking for? Here are some other Business Data Analyst jobs in the Columbus, OH area that may be a better fit.

Data integration Business analyst

Steneral Consulting, Columbus, OH

Business Data Analyst II

Supply Chain, Westerville, OH

AI Assistant is available now!

Feel free to start your new journey!