Job description

Who We Are Point32Health is a leading not-for-profit health and well-being organization dedicated to delivering high-quality, affordable healthcare. Serving nearly 2 million members, Point32Health builds on the legacy of Harvard Pilgrim Health Care and Tufts Health Plan to provide access to care and empower healthier lives for everyone. Our culture revolves around being a community of care and having shared values that guide our behaviors and decisions. We’ve had a long-standing commitment to inclusion and equal healthcare access and outcomes, regardless of background; it’s at the core of who we are. We value the rich mix of backgrounds, perspectives, and experiences of all of our colleagues, which helps us to provide service with empathy and better understand and meet the needs of the communities where we serve, live, and work. We enjoy the important work we do every day in service to our members, partners, colleagues and communities. Learn more about who we are at Point32Health . Job Summary Harvard Pilgrim Health Care Institute is currently seeking a highly motivated individual to join our organization as SAS Programmer, who will work collaboratively with investigators, statisticians, and senior programmers. The SAS Programmer will work within the Division of Health Policy and Insurance Research (HPI) within the Department of Population Medicine (DPM). The SAS Programmer will perform a variety of activities to support the project team, including assisting with data cleaning, database development, dataset creation, software programming, data management, statistical analysis, and results reporting for internal and external research projects. The individual will primarily work with large health insurance claims data (e.g., CMS Medicaid claims data, All Payer Claims Data) under the direction of a senior programmer and project manager. The SAS programmer will work across a multi-project research portfolio examining effects of health policies on health outcomes, including work focused on maternal health, child health, and mental health. Their work will be done in collaboration with the larger research team, which includes health services researchers, biostatisticians, clinicians, economists, and epidemiologists. WHO WE ARE The Department of Population Medicine (DPM) is a research and teaching collaboration between Harvard Medical School (HMS) and Harvard Pilgrim Health Care. Our mission is to improve health care delivery and population health through research and education, in partnership with health plans, delivery systems, and public health agencies. As the nation’s first medical school appointing department based in a health plan, we are strategically positioned to improve population health and health care delivery locally, nationally, and internationally. DPM is home to five divisions and six Centers of Excellence, which facilitate collaborations across divisions. Researchers in DPM work closely with other Harvard faculty at HMS, at the Harvard T.H. Chan School of Public Health, and across the University, as well as many health systems, hospitals, and community partners. The Division of Health Policy and Insurance Research (HPI) is one of five divisions within DPM. Our researchers study state and federal policies, payment and insurance reforms, care delivery models, and digital health innovations – with a focus on both commercial (employer sponsored insurance, Marketplace) and public (Medicaid, Medicare) populations and payers – in core areas of: pharmaceutical policy and systems, maternal and child health, mental health and substance use, chronic disease, cancer, and health care workforce. We do so using quasi-experimental and other health services research methods, with large administrative data sources (claims data, EHR data, survey data), with an overarching focus on access, quality, affordability, and equity of care for marginalized populations. We work in close collaboration with local, national, and international partners. WHAT YOU WILL BE DOING • Use SAS software to clean, quality check, and troubleshoot health insurance claims data • Design, develop, test, execute, and maintain SAS programs to create cohorts and generate variables • Create and maintain analytic datasets using raw data files, including complex data linkages, merging, and transformation workflows • Generate descriptive data and conduct statistical analyses, in close consultation with investigators, statisticians, and senior programmers • Use Excel or other programs to display user-friendly results in graphical or numerical form • Utilize knowledge of analytic and statistical concepts, techniques, and methods in daily work • Participate in project meetings, both via telephone and in-person • Contribute to the development of manuscripts and reports • Perform out-of-the-box thinking, collaborate with others, and make a difference every day! QUALIFICATIONS REQUIRED • Bachelor’s Degree (BA, BS) • At least 2 years of full-time work as a programmer or equivalent SAS programming experience, including macro programming and PROC SQL • Experience transforming and analyzing large administrative health care data, including claims data (such as CMS Medicaid or Medicare claims, all-payer claims databases, commercial claims) • Experience with epidemiologic and biostatistics principles and methods • Ability to prioritize work, operate under tight deadlines, and meet deadlines • Proficiency with software packages, including Microsoft Office suite (e.g., Excel) • Excellent organizational skills, accuracy, and attention to detail. • Resilient, collaborative, flexible, and independent PREFERRED • Master's Degree in Public Health, Epidemiology, Biostatistics, Statistics, or another health-related field • Programming experience in at least one other programming language (e.g., Stata, R) • Knowledge of health care systems, health care delivery, or health policy • Experience with, and understanding of, claims-related elements such as ICD diagnosis codes and procedure codes • Experience conducting regression analyses WHAT MAKES US STAND OUT • Work-Life-Flexibility • Paid volunteer time off (up to 3 days annually) • Open Time Off • Annual Mini-Grant of $500 donated to a non-profit organization of the employee’s choice • Educational Reimbursement WORKING ENVIRONMENT Hybrid office environment based in Boston, MA. All faculty and staff are expected to be in the office on Thursdays. Job Description Salary Range $79,454.20 -$119,181.30 Compensation & Total Rewards Overview The annual base salary range provided for this position represents a range of salaries for this role and similar roles across the organization. The actual salary for this position will be determined by several factors, including the scope and complexity of the role; the skills, education, training, credentials, and experience of the candidate; as well as internal equity. As part of our comprehensive total rewards program, colleagues are also eligible for variable pay. Eligibility for any bonus, commission, benefits, or any other form of compensation and benefits remains in the Company s sole discretion and may be modified at the Company’s sole discretion, consistent with the law. Point32Health offers their Colleagues a competitive and comprehensive total rewards package which currently includes: 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 For more details on our total rewards programs, visit point32health.org We welcome all All applicants are welcome and will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. Scam Alert : Point32Health has recently become aware of job posting scams where unauthorized individuals posing as Point32Health recruiters have placed job advertisements and reached out to potential candidates. These advertisements or individuals may ask the applicant to make a payment. Point32Health would never ask an applicant to make a payment related to a job application or job offer, or to pay for workplace equipment. If you have any concerns about the legitimacy of a job posting or recruiting contact, you may contact TA_operations point32health.org

Requirements

Must-haves

Design, develop, test, execute, and maintain SAS programs to create cohorts and generate variables
Create and maintain analytic datasets using raw data files, including complex data linkages, merging, and transformation workflows
Generate descriptive data and conduct statistical analyses, in close consultation with investigators, statisticians, and senior programmers
Use Excel or other programs to display user-friendly results in graphical or numerical form
Utilize knowledge of analytic and statistical concepts, techniques, and methods in daily work
Participate in project meetings, both via telephone and in-person
Contribute to the development of manuscripts and reports
Perform out-of-the-box thinking, collaborate with others, and make a difference every day!
Bachelor’s Degree (BA, BS)
At least 2 years of full-time work as a programmer or equivalent SAS programming experience, including macro programming and PROC SQL
Experience with epidemiologic and biostatistics principles and methods
Ability to prioritize work, operate under tight deadlines, and meet deadlines
Proficiency with software packages, including Microsoft Office suite (e.g., Excel)
Excellent organizational skills, accuracy, and attention to detail.
Resilient, collaborative, flexible, and independent
Work-Life-Flexibility
Paid volunteer time off (up to 3 days annually)
Open Time Off
Annual Mini-Grant of $500 donated to a non-profit organization of the employee’s choice
Educational Reimbursement

Nice-to-haves

Master's Degree in Public Health, Epidemiology, Biostatistics, Statistics, or another health-related field
Programming experience in at least one other programming language (e.g., Stata, R)
Experience with, and understanding of, claims-related elements such as ICD diagnosis codes and procedure codes
Experience conducting regression analyses

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: workday
Effort: long

Benefits

Benefits detected in the listing.

Health Insurance

Dental

Vision

Paid Time Off