The Risk Adjustment Data Architect is responsible for building and maintaining a robust data infrastructure for health plan risk adjustment operations to support strategic reporting. This position will assist with the development, execution, and maintenance of risk adjustment specific data Infrastructure to enable accurate and timely risk modeling, CMS submissions, operations, and reporting.
Key Outcomes:
Assist in architecture, design and development of data infrastructure for risk adjustment to support operations including internal applications, submissions, and reporting
Collaborate with subject matter experts and end users in the design and development of appropriate solutions; translate user requirements into practical data models
Provide input on potential and current risk adjustment vendor activities as they relate to data, including transfers, submissions, and operational/reporting outputs
Responsible for data integrity, maintenance and troubleshooting of risk adjustment data
Review database architectures and designs to ensure data integrity, quality, performance, and scalability
Create and maintain documentation of data processes, procedures, and definitions
Collaborate with resources in IT and lines of business to prioritize immediate ad-hoc tasks and future development efforts to ensure mature, reliable, and flexible infrastructure
Partner with the Data and Analytics Architecture team to implement reliable solutions that are well understood across multiple resources to ensure redundancy and prevent single points of failure
Collaborate with colleagues in the Health Plan and Shared Services to jointly develop innovative data infrastructures that meet the evolving needs of the business
Education/Experience:
Bachelor’s degree or equivalent combination of relevant education and experience
Minimum of 3 years’ experience writing T_SQL code and procedures programming with SQL Server 2016 and SSIS
Prior experience building data warehouses and maintaining SQL Server databases
Experience with metadata management concepts, change management/version control concepts
Experience with CMS HCC risk adjustment strongly preferred
Skills/Knowledge/Competencies (Behaviors):
Demonstrates an understanding of and alignment with Martin’s Point Values
Understanding of data modeling and metadata concepts
Disciplined and collaborative data management practices
Comfortable working with a variety of stakeholders across the organization
Self-starter reliability and follow-through but with capacity for determining when issues need escalation or prioritization
Demonstrated ability to gather and communicate requirements
Internal Number: REQ-2021-045
About Martin's Point Health Care
in Martin's Point Health Care - an innovative, not-for-profit health care organization offering care and coverage to the people of Maine and beyond. As a joined force of "people caring for people," Martin's Point employees are on a mission to transform our health care system while creating a healthier community. Martin's Point employees enjoy an organizational culture of trust and respect, where our values - taking care of ourselves and others, continuous learning, helping each other, and having fun - are brought to life every day. Join us and find out for yourself why Martin's Point has been certified as a "Great Place to Work" since 2015.
