Sr Business Data Analyst

The Hartford; Columbus (OH); Hybrid; USD 100,000 - 150,000; Full time

Job summary

The Hartford in Columbus, OH is seeking a Sr. Business Data Analyst to join our Enterprise Data Services IT team supporting Global specialty.

You will apply data analysis and SQL skills to gather data from multiple sources and translate business requirements into analytical solutions. The ideal candidate will mentor junior analysts, collaborate with IT, Product and Reporting partners, and drive best practices for data management and reporting.

Qualifications

• 6+ years in business requirements or data analysis preferably in insurance and data warehouse or reporting projects.
• Proficient in SQL; Snowflake experience desired.
• Strong insurance product knowledge.
• Strong critical thinking and analytical ability.
• Ability to manage multiple priorities in a timeline-driven environment.
• Experience in Agile teams.
• Excellent communication, verbal and written.

Responsibilities

• Elicit complete data requirements from stakeholders.
• Collaborate with internal partners to gather requirements and develop data assets and reporting.
• Plan and monitor requirements; manage changes.
• Perform rigorous data analysis, discovery, and profiling using SQL.
• Maintain data mapping documents and design artifacts.
• Act as liaison between business and IT stakeholders; provide thought leadership.
• Mentor and guide junior Business Data Analysts in the group.
• Drive adoption of industry best practices and foster collaboration.

Skills

SQL

Data analysis

Insurance knowledge

Leadership

Agile

Communication

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