The Product Analyst is a data-driven and detail-oriented professional responsible for supporting the analysis, maintenance, and enhancement of healthcare data products.
The role combines US healthcare claims data analysis, product validation, requirements documentation, dashboard development, and cross-functional collaboration. The ideal candidate will have strong problem-solving abilities and hands-on experience using SQL, Power BI, and Excel to analyze complex datasets, investigate issues, assess business impact, and generate actionable insights.
The Product Analyst will work closely with Product Owners, Product Managers, Data Engineering, Machine Learning, Software Engineering, Engagement, and Account teams. This role will report to Product Owner.
Essential functions of the job include but are not limited to:
- Represents the Product team on all active projects.
- Participates in the daily application operations / development stand-up meetings.
- Supports data delivery for the clients subscribed to the product.
- Work closely with team and stakeholders to develop and deliver high-quality data products.
- Analyze large US healthcare claims datasets to identify patterns, data-quality issues, coverage gaps, and product-improvement opportunities.
- Write and optimize SQL queries for data extraction, profiling, reconciliation, validation, and impact analysis.
- Compare datasets and product outputs to assess the impact of source changes, revised business rules, data-period changes, and product enhancements.
- Investigate complex data and product issues, perform root-cause analysis, assess business impact, and recommend practical solutions.
- Analyze medical claims, pharmacy claims, prescription, payer, formulary, and patient-level data across patient, claim, payer, plan, and other relevant levels.
- Support the validation of product outputs, analytical processes, data transformations, and machine-learning-generated results.
- Create and maintain product documentation, including data dictionaries, business rules, requirements, test scenarios, and validation results.
- Support functional testing, data validation, regression testing, defect investigation, and user acceptance testing.
- Support feasibility assessments and proof-of-concept initiatives for new healthcare data and analytics capabilities.
Qualifications
- Bachelor’s degree in engineering (B.E.) or in Technology (B. Tech.). Degree in computer science or related fields preferred.
- 1 to 3 years of experience in healthcare analytics, product analysis, business analysis, data analysis, or a related role.
- Strong problem-solving skills, including the ability to structure ambiguous business questions, investigate data discrepancies, perform root-cause analysis, and recommend actionable solutions.
- Strong hands-on experience with SQL, Power BI, and Microsoft Excel.
- Hands-on experience analyzing US healthcare data, with exposure to one or more of the following datasets, data sources, or equivalent healthcare datasets:
- Medical, pharmacy claims, and patient-level data, such as McKesson Compile, Symphony PatientSource, Komodo Health or equivalent sources.
- Formulary and market-access data, such as MMIT, DRG Fingertip, or equivalent sources.
Preferred
- Hands-on experience with Snowflake.
- Understanding of medical and pharmacy claims, payer hierarchies, BIN-PCN-Group data, formulary data, market access, or patient-services analytics.
- Exposure to longitudinal patient analysis, treatment patterns, patient journeys, or payer-access analytics.
- Familiarity with Python, APIs, JSON, or machine-learning output validation.