Sr Business Data Analyst

thehartford; Hartford (CT); Hybrid; USD 100,000 - 150,000; Full time

Job summary

The Hartford in Hartford, CT is seeking a Sr. Business Data Analyst to join the Enterprise Data Services IT team supporting Global specialty. The role requires strong SQL skills, data analysis expertise, and the ability to gather data from diverse sources while collaborating with IT, Product and Reporting partners.

Hybrid work is offered; candidates must reside near Hartford, CT, Columbus, OH, Charlotte, NC, or Chicago, IL and will work in the office 3 days a week (Tuesday through Thursday).

Qualifications

• 6+ years of experience in business requirements or data analysis, preferably in Insurance.
• Proficient in SQL; hands-on Snowflake experience is desirable.
• Strong communication and analytical skills; ability to work with IT, Product and Reporting partners.

Responsibilities

• Elicit and translate business data needs into clear requirements and analytics deliverables.
• Collaborate with partners to gather requirements and develop data assets and reporting solutions.
• Perform data analysis, data discovery and profiling using SQL to support business needs.
• Maintain data mapping documents and data transformation rules.
• Act as liaison between business and IT stakeholders and mentor junior analysts.
• Drive best practices and foster collaboration and continuous improvement.

Skills

SQL

Data analysis

Communication

Agile

Insurance knowledge

Mentoring

Tools

Snowflake

Job description

Sr Consult Bus Data Analysis - GA07AE

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 Enterprise Data Services department's IT team supporting Global specialty is looking for a skilled Sr. Business Data Analyst to join us. The ideal candidate will demonstrate exceptional communication skills, experience in data analysis, and strong SQL abilities to gather required data from various data sources. You will engage with a diverse array of business customers, including IT, Product, and Reporting partners across the enterprise.

Job Description & Responsibilities:

• Applies strong functional knowledge and elicitation techniques necessary to draw out data and analytics business requirements completely and accurately from stakeholders.
• Work together with internal partners determine needs, gather requirements, and develop solutions for data assets and reporting.
• Performs requirements planning, monitoring and requirements management.
• Independently performs rigorous data analysis, data discovery and data profiling using industry standard querying tools (SQL) to support business requirements development that are complete, clear, unambiguous, well written and appropriate to audience.
• Maintains data mapping documents, bus matrix and/or other data design artifacts that define business data requirements and transformation rules.
• Act as liaison and advisor/consultant between the business and IT stakeholders providing thought leadership.
• Lead responsibility in mentoring, instructing, assigning, directing, and checking the work of Business Data Analysts within their group.
• Acts as a change leader to help and drive implementation of industry best practices. Provides support and consulting by answering questions, researching possible solutions to complex problems, and fostering open communication between the customer and development team.
• Identifies logical, relevant business, data relationships between complex topics in the broader context of own project or functional area.
• Identifies choices and improvement opportunities to better align own work with the direction and strategic priorities of the broader organization.
• Conduct root cause analysis on identified issues, providing assistance to resolve data quality problems.
• Supports the upkeep of data mapping documents and other design artifacts that outline business requirements and transformation rules
• Foster a positive work environment by exemplifying cultural values and encouraging others to promote collaboration, accountability, diversity, and continuous improvement

This role has a Hybrid work arrangement. Candidates must live near one of our locations (Hartford, CT, Columbus, OH, Charlotte, NC, or Chicago, IL) and will have the expectation of working in office 3 days a week- Tuesday through Thursday.

Qualifications:

• 6+ years of experience in business requirements or data analysis preferably supporting the Insurance industry and data warehouse or reporting/analytic projects
• Proficient in Industry Standard querying tools (SQL). Hands on experience with Snowflake is desired
• Strong Insurance Product Knowledge
• Strong critical thinking skills and analytical ability
• Proven ability to organize and manage multiple priorities in a timeline driven environment
• Advanced business acumen with technical aptitude
• Experience in working in a Agile team environment
• Detail oriented with strong communication skills (both verbal and non-verbal)
• Forward looking and focused on continuous improvement

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.

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:

$100,000 - $150,000

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