Lead Data Analyst (QlikView)

Job Title: Lead Data Analyst (QlikView)

Location: Hartford, CT (Onsite)

Job Summary

Lead Data Analyst responsible for partnering with business stakeholders to deliver analytical reporting, dashboard solutions, KPI frameworks, and business insights. The role requires strong expertise in SQL, QlikView, data analysis, and reporting within large-scale enterprise environments.

Key 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 supporting strategic and operational decision-making.
• Support high-priority initiatives, including dashboard redesign, modernization, and analytical projects.
• 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 established timelines.
• Participate in requirements 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.

Required Skills

• Advanced SQL for data extraction, transformation, validation, and analysis.
• Data analysis, trend analysis, and business insights generation.
• Strong experience in 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 Microsoft Excel for analytical reporting and ad hoc analysis.
• Ability to use AI effectively for day-to-day activities.
• Strong written and verbal communication skills in a client-facing environment.
• Excellent stakeholder management and relationship-building skills.
• Strong analytical thinking and problem-solving abilities.
• Ability to present insights and tell compelling stories with data.
• Experience with work effort estimation, prioritization, and delivery planning.
• Ability to coordinate with offshore teams and review deliverables for quality and completeness.
• Customer-focused mindset with the ability to recommend data-driven solutions.
• Self-motivated, proactive, and capable of working independently in a fast-paced environment.

Preferred Skills

• 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

Qualifications

• 8 to 10 years of relevant experience in data analysis and reporting.
• Strong expertise in QlikView and Microsoft Excel.
• Experience working with enterprise reporting and analytics environments.
• Insurance domain knowledge, including policy, claims, billing, and operational reporting concepts, is preferred.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, citizenship status, age, disability, genetic information, protected veteran status, or any other characteristic protected by applicable law.

https://www.e-verify.gov/sites/default/files/everify/posters/IER_RighttoWorkPoster.pdf