Lead Data Analyst

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 on-site, 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.

Mandatory Skills : Microstrategy, MS SQL Server