Business Intelligence Manager – Employee Benefits

Role Overview

• Lead the rationalization and replatforming of existing Business Intelligence reports from SAP Business Objects to SAP BI 2027 and/or ThoughtSpot (for Actuarial-specific reporting)
• Establish and manage a comprehensive migration roadmap inclusive of leadership checkpoints, stakeholder readouts, and progress reporting to senior management
• Evaluate and recommend future BI delivery capabilities including Generative AI, Agentic AI solutions, self-service analytics, and delivery efficiencies that minimize rework and exceed customer expectations
• Directly manage a blended team of Hartford employees and Cognizant contractors, including 1 Hartford onshore employee, 1 Cognizant onshore resource, and 8 Cognizant offshore contractors
• Provide coaching, mentorship, and performance management across the team, fostering a culture of accountability, collaboration, and continuous improvement
• Model The Hartford's expected behaviors and leadership competencies; provide leadership perspective and strategic counsel to peers across the organization
• Actively participate in and provide leadership expertise and guidance within Employee Benefits investment value streams, including Team Thunderbolts, Team Membrino, Team Cafe, and Team Ignite
• Collaborate with value stream leads to align BI priorities with broader divisional and enterprise objectives
• Field ad hoc data and analytics requests from field partners, customers, and leaders on a wide range of Employee Benefits insurance topics
• Write and execute SQL queries against Snowflake, Oracle, and other data sources to investigate questions, produce datasets, and deliver timely answers
• Leverage ThoughtSpot and other BI tools to provide rapid, accurate insights while meeting strict deadlines
• Own and manage recurring compliance and statutory state reporting obligations, ensuring accuracy, timeliness, and adherence to all regulatory requirements
• Manage industry survey data submissions and responses
• Oversee and rationalize managed file transfer (MFT) data transmissions to external partners and vendors, ensuring proper data governance and protection against data breaches
• Review monthly contractor invoices to verify that billed hours are accurate and aligned with actuals, in coordination with the director
• Partner with vendor management and procurement as needed to ensure contract compliance and cost efficiency

Requirements

• 3+ years of experience in Business Intelligence, data engineering, analytics, or a related discipline
• Strong SQL proficiency with hands-on experience querying and manipulating data in enterprise database environments
• Demonstrated experience with BI and analytics platforms, specifically SAP Business Objects and ThoughtSpot
• Working knowledge of Snowflake and Oracle database environments
• Proficiency in Microsoft Excel and familiarity with Microsoft Copilot
• Proven ability to manage multiple competing priorities in a deadline-driven, regulated environment
• Excellent problem-solving skills with the ability to analyze complex data sets and translate findings into actionable insights
• Strong written and verbal communication skills with the ability to present to stakeholders at all levels
• Experience managing or leading teams, including blended onshore/offshore and employee/contractor models
• Direct experience in Employee Benefits insurance (group life, disability, absence management, or related lines of business) preferred
• Experience leading BI platform migrations or large-scale reporting transformation programs
• Familiarity with Agile delivery methodologies and participation in value streams or product teams
• Exposure to Generative AI, Agentic AI, or advanced analytics concepts as they apply to BI delivery
• Business Intelligence certifications (e.g., SAP, ThoughtSpot, Snowflake, or equivalent)

Tech Stack

• Oracle
• SQL

Benefits

• Other rewards may include short-term or annual bonuses
• long-term incentives
• on-the-spot recognition