Product Analyst

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 the Product Owner.

Essential Functions:

• Represents the Product team on all active projects.
• Participates in daily application operations / development stand-up meetings.
• Supports data delivery for clients subscribed to the product.
• Works closely with teams and stakeholders to develop and deliver high-quality data products.
• Analyzes large US healthcare claims datasets to identify patterns, data-quality issues, coverage gaps, and product-improvement opportunities.
• Writes and optimizes SQL queries for data extraction, profiling, reconciliation, validation, and impact analysis.
• Compares datasets and product outputs to assess the impact of source changes, revised business rules, data-period changes, and product enhancements.
• Investigates complex data and product issues, performs root-cause analysis, assesses business impact, and recommends practical solutions.
• Analyzes medical claims, pharmacy claims, prescription, payer, formulary, and patient-level data across patient, claim, payer, plan, and other relevant levels.
• Supports the validation of product outputs, analytical processes, data transformations, and machine-learning-generated results.
• Creates and maintains product documentation, including data dictionaries, business rules, requirements, test scenarios, and validation results.
• Supports functional testing, data validation, regression testing, defect investigation, and user acceptance testing.
• Supports feasibility assessments and proof-of-concept initiatives for new healthcare data and analytics capabilities.

Qualifications:

• A Bachelor’s degree in engineering (B.E.) or in Technology (B. Tech). Degree in computer science or related fields is preferred.

Minimum Required:

• 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: medical, pharmacy claims, and patient-level data (e.g., McKesson Compile, Symphony PatientSource, Komodo Health).
• Formulary and market-access data (e.g., MMIT, DRG Fingertip).

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.
• Experience with Azure DevOps, Jira, or Agile product-development practices.
• Working knowledge of US Healthcare / Market Access would be an advantage.
• Experience developing in a HIPAA compliant ecosystem.

Other Required:

• May require travel domestically and/or internationally, including overnight stays up to 5%.

Competencies:

• Communication Skills: Written, Verbal, and Presentation. The candidate must be able to read, analyze, and interpret production data, financial reports, and legal documents. Excellent verbal, written, presentation, and interpersonal skills are required.
• Business Judgment and Strategic Thinking: Ability to think, act, and deliver value in the best interest of clients with respect to common practices of the healthcare consulting field.
• Analytic Skills: Framing macro problems into actionable work plans, structuring persuasive client presentations based on expansive data, and demonstrating interpretive and solution identification skills.
• Collaboration and Teamwork: Ability to give and receive constructive feedback and work effectively across the organization to accomplish team goals.
• Strategic Thinking: Conceptualizing how work contributes to and drives forward overall project goals.
• Solutions Oriented: Resourcefulness and confidence under pressure.
• Resilience: Ability to overcome obstacles and seek support.