Sr Data Analyst

Point32Health • Canton, MA

1d • $88,942 - $133,413 • Hybrid

About The Position

Under the supervision of a Manager for Reporting and Analytics, Government Programs, the Senior Data Analyst leads critical data submission activities for the Risk Adjustment Department (RAD). This role is accountable for the completeness, accuracy, and timeliness of Point32Health’s All‑Payer Claims Database (APCD) submissions across applicable markets, as well as supporting the encounter data submissions to Rhode Island EOHHS. The analyst oversees internal data reconciliations, manages data exchanges with external partners, and supports regulatory reporting requirements. Serving as the primary point of contact for APCD-related initiatives and supporting RI‑EOHHS encounter submissions, the role collaborates with internal teams, external stakeholders, and state agencies to ensure compliance and operational excellence. The ideal candidate demonstrates strong analytical and critical‑thinking skills, with the ability to independently analyze large and complex datasets, assess data quality, identify trends and root causes, and translate findings into clear insights for leadership. Advanced SQL proficiency is required, and healthcare data knowledge is strongly preferred.

Requirements

• Bachelor’s degree in health informatics, information technology, data management, or a related discipline.
• 5–7 years of experience in progressively responsible analytical and data management roles.
• Prior experience in the healthcare or health insurance sector (e.g., health plan, provider group, healthcare IT, or auditing firm), and/or experience working with large datasets in a technical capacity.
• Experience developing, maintaining, and updating detailed policies and procedure documentation.
• Expertise in data management and controls, IT processes, and analytical tools; comfortable working with large datasets from disparate sources and identifying meaningful patterns and trends.
• Advanced technical skills in SQL and proficiency in Microsoft Excel.
• Experience with database systems such as Teradata and Oracle
• Demonstrated ability to manage multiple projects simultaneously in a complex, fast‑paced environment.
• Demonstrated maturity and professionalism, with the ability to navigate complexity, ambiguity, and incomplete information.
• Engaged, critical thinker who is organized, detail‑oriented, resourceful, and self‑motivated; able to work independently and collaboratively.
• Strong verbal, written, and interpersonal communication skills, with the ability to influence without authority and work effectively with internal and external stakeholders.
• Team‑oriented, resilient, flexible, and committed to high‑quality processes and outcomes.
• Ability to quickly learn and adapt to new technologies and applications.

Nice To Haves

• Master’s degree preferred.
• Understanding of claims systems, provider data, and Medicaid, Medicare, and commercial products preferred.
• Prior experience with regulatory data submissions, including All‑Payer Claims Database (APCD) submissions, a plus.
• Experience with SAS, Alteryx, Databricks, Tableau, and knowledge of X12 837, 277, and 835 EDI transactions a plus.

Responsibilities

• Independently manage and execute monthly APCD data submissions to state agencies for Tufts Health Plan and Harvard Pilgrim Health Care commercial and government products.
• Support RI EOHHS encounter data submissions, including error analysis, reconciliation, remediation, and end‑to‑end submission support.
• Ensure compliance with regulatory requirements, business rules, data standards, and technical specifications; document requirements and data logic as needed.
• Monitor and analyze encounter and APCD response files to identify rejections, discrepancies, and data quality issues; perform trend analysis and root‑cause investigations and drive timely resolution.
• Lead prioritized data remediation efforts for encounter and APCD defects in collaboration with business and technical partners.
• Develop, enhance, and automate reconciliation and reporting processes using SQL, SAS, Alteryx, and/or other analytical tools.
• Partner with IT and data engineering teams on enhancements and production issue resolution, including requirements clarification, issue investigation, UAT, and post‑implementation validation.
• Support encounter and APCD data readiness for risk adjustment, financial reconciliation, actuarial reporting, and regulatory audits.
• Serve as a subject‑matter expert for encounter and APCD data submission logic, providing guidance and recommendations to cross‑functional teams.
• Lead change management efforts related to state‑issued specifications and internal enhancements impacting encounter and APCD data submissions.
• Perform end‑to‑end issue analysis, including root‑cause identification, documentation of business requirements, implementation of data or process changes, user acceptance testing (UAT), and post‑implementation monitoring.
• Identify inefficiencies and improvement opportunities in monthly data submission, reconciliation, and tracking processes, and drive continuous improvement initiatives.
• Monitor the effectiveness of implemented changes, make necessary adjustments, and ensure sustained regulatory compliance and operational stability.
• Develop and maintain submission dashboards and reconciliation reports using Tableau, Excel, and other reporting tools to track acceptance rates, trends, and performance metrics.
• Collaborate closely within the Risk Adjustment department and with cross‑functional partners including Claims, Member Operations, Information Technology, and Provider Information to ensure data submission processes and enhancements are effectively implemented and maintained.
• Partner with IT to support timely resolution of production issues, ensuring alignment between business requirements and technical solutions.
• Engage with external stakeholders, including state agencies, their consultants, vendor data management teams, and industry trade associations, to stay informed of regulatory updates, policy changes, and evolving submission requirements.
• Communicate findings, risks, and recommendations clearly to management and stakeholders to support informed decision‑making.
• Attend internal and external (state‑led) meetings; document key decisions; and track and manage follow‑up actions through completion.
• Develop, maintain, and update business policies, procedures, and knowledge repositories to support consistent operations, effective onboarding, and audit readiness.

Benefits

• Medical, dental and vision coverage
• Retirement plans
• Paid time off
• Employer-paid life and disability insurance with additional buy-up coverage options
• Tuition program
• Well-being benefits
• Full suite of benefits to support career development, individual & family health, and financial health

What This Job Offers

• Job Type: Full-time
• Career Level: Senior