Lead Data Analyst

About the role

Onsite role in Hartford, CT requiring 8–10 years of relevant experience.

Technical Skills

Primary

• Advanced SQL for data extraction, transformation, validation, and analysis
• Data analysis, trend analysis, and business-insights generation
• QlikView dashboard development and data visualization
• QlikView data modeling, scripting, and dashboard optimization
• Requirements gathering and business analysis
• KPI development, metrics definition, and reporting frameworks
• Experience working with large-scale enterprise datasets
• Data quality analysis and data reconciliation
• Strong understanding of data warehousing and reporting concepts
• Proficiency in Excel for analytical reporting and ad hoc analysis
• Using AI effectively for day-to-day activities

Secondary (nice to have)

• Qlik Sense
• Python for data analysis and automation
• ETL and data-integration concepts
• AWS analytics services
• Insurance data and reporting experience
• Agile/Scrum methodology
• Statistical analysis and forecasting techniques

Responsibilities

• Partner with business stakeholders to understand analytical reporting and dashboard requirements
• Analyze large and complex datasets to identify trends, patterns, risks, and business opportunities
• Design and develop interactive QlikView dashboards, scorecards, and reports that support strategic and operational decision-making
• Support high-priority initiatives including dashboard redesign, modernization, and analytical work
• Translate business questions into actionable, data-driven insights and recommendations
• Define, monitor, and enhance KPIs and business metrics
• Perform root-cause analysis and data validation to ensure reporting accuracy and consistency
• Create ad hoc analysis and executive-level presentations to support business decisions
• Collaborate with business, technology, and offshore teams to deliver analytical solutions within timelines
• Participate in requirement workshops, solution-design discussions, effort estimation, and prioritization activities
• Identify opportunities for reporting automation, process improvement, and enhanced data visualization
• Maintain documentation for business rules, metrics definitions, data lineage, and reporting solutions

Soft Skills

• Strong written and verbal communication skills as this is an onsite client-facing role
• Insurance domain knowledge with the ability to understand policy, claims, billing, and operational reporting concepts
• Excellent stakeholder management and relationship-building skills
• Ability to gather, clarify, and document business requirements from multiple stakeholders
• Strong analytical thinking and problem-solving abilities
• Ability to tell a compelling story with data and present insights to business and leadership teams
• Experience in work-effort estimation, prioritization, and delivery planning
• Ability to coordinate with offshore teams and review deliverables for quality and completeness
• Strong customer-centric mindset with the ability to recommend data-driven solutions
• Self-motivated, proactive, and capable of working independently in a fast-paced environment

Benefits

• Comprehensive medical plan covering medical, dental, and vision
• Short-term and long-term disability coverage
• 401(k) plan with company match
• Life insurance
• Vacation time, sick leave, and paid holidays
• Paid paternity and maternity leave