Lead Data Analyst
Hartford - Connecticut - USAOn-siteFull-timeInformation Technology
Description
Role Lead Data Analyst Locaton Hartofrd CT On-site Experience 8 to 10 Years Technical Skills Primary 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 largescale 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 Technical Skills Secondary Nice to have NOT MANDATORY 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 Job Duties 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 highpriority initiatives including Redesign Dashboard 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 executivelevel 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 on-site client-facing role
Insurance domain knowledge with the ability to understand policy claims billing and operational reporting concepts
Excellent stakeholder management and relationshipbuilding 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 customercentric mindset with the ability to recommend data-driven solutions Self-motivated proactive and capable of working independently in a fast-paced environment
Requirements
Mandatory Skills : MS Excel, QlikView
Good to Have Skills : Python