Lead Data Analyst

Role description

Lead Data Analyst

Role Profile
• Experience: 8-10 years
• Location: United States, Eastern Time Zone

Primary Technical Skills
• Advanced SQL for data extraction, transformation, validation, and analysis.
• Data analysis, trend identification, and generation of actionable business insights.
• QlikView dashboard development, data visualization, data modeling, scripting, and performance optimization.
• Requirements gathering and business analysis.
• KPI development, metric definition, and reporting-framework design.
• Experience working with large-scale enterprise datasets.
• Data-quality analysis and data reconciliation.
• Strong understanding of data warehousing and reporting concepts.
• Advanced Excel skills for analytical reporting and ad hoc analysis.
• Effective use of AI tools to support day-to-day analytical activities.

Preferred Technical Skills
• Qlik Sense.
• Python for data analysis and automation.
• ETL and data-integration concepts.
• AWS analytics services.
• Insurance data and reporting experience.
• Agile and Scrum methodologies.
• Statistical analysis and forecasting techniques.

Key Responsibilities
• Partner with business stakeholders to define analytical, reporting, and dashboard requirements.
• Analyse large, 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 advanced analytical work.
• Translate business questions into actionable, data-driven insights and recommendations.
• Define, monitor, and improve KPIs and business metrics.
• Perform root-cause analysis, data validation, and reconciliation to ensure reporting accuracy and consistency.
• Prepare ad hoc analyses and executive-level presentations to support business decisions.
• Collaborate with business, technology, and offshore teams to deliver analytical solutions on schedule.
• 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, metric definitions, data lineage, and reporting solutions.

Professional and Domain Competencies
• Strong written and verbal communication skills suitable for an onsite, client-facing role.
• Insurance-domain knowledge, including 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 present compelling data stories and communicate insights to business and leadership teams.
• Experience with effort estimation, prioritization, and delivery planning.
• Ability to coordinate with offshore teams and review deliverables for quality and completeness.
• Customer-centric mindset with the ability to recommend data-driven solutions.
• Self-motivated, proactive, and able to work independently in a fast-paced environment.