Healthcare Data Analyst #11172

ECCO Select is a talent acquisition and advisory consulting company specializing in providing IT solutions. They are seeking a detail-oriented Data Analyst with strong experience in healthcare eligibility data to analyze, validate, and map raw data while collaborating with internal stakeholders to ensure data accuracy and integrity.

Responsibilities:

• Analyze, validate, and compare healthcare eligibility data from multiple sources, including hospital facilities, EDI files, and internal enrollment systems
• Design, write, and optimize T-SQL queries, stored procedures, and scripts to extract, transform, and analyze data
• Produce recurring and ad-hoc reports related to membership, eligibility status, attribution, enrollment trends, and data quality metrics
• Investigate data anomalies, discrepancies, and eligibility mismatches; provide root-cause analysis and corrective recommendations
• Maintain data accuracy and completeness across eligibility datasets
• Work with data engineers to improve data pipelines, file-processing jobs, and database performance
• Partner with operations, IT, revenue cycle, and compliance to ensure eligibility data supports business processes
• Translate business questions into analytical requirements and provide clear, actionable insights
• Ensure all data handling aligns with HIPAA, PHI, and internal security policies
• Maintain documentation for eligibility data structures, data flows, and SQL processes
• Create user-friendly definitions of eligibility fields, metrics, and logic for non-technical stakeholders

Requirements:

• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Health Informatics, or a related field; or equivalent experience
• 3+ years of experience working with healthcare eligibility, enrollment, or membership data
• Strong PostgreSQL and MSSQL experience, including T‑SQL scripting, query optimization, joins, indexing, and stored procedures
• Familiarity with EDI formats such as 270/271, 835, or payer roster files
• Proven ability to analyze large datasets and identify patterns, trends, and data quality issues
• Experience working within HIPAA‑regulated environments and handling PHI
• Strong communication skills, including the ability to explain technical concepts to non‑technical users
• Experience with ETL tools (Matillion ETL, SSMS/SSIS, Azure Data Factory, Informatica, etc.)
• Knowledge of healthcare payer systems, provider networks, ACO/IPA environments, or value‑based care programs
• Understanding of relational database design, normalization, and performance tuning
• Experience with data visualization tools (Power BI, Tableau, Looker, etc.)