Business Data Analyst

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