SAS Programmer Analyst

Harvard Pilgrim Health Care Institute, LLC; United States; Hybrid; USD 79,000 - 119,000; Full time

Benefits offered by this job

Work-Life-Flexibility

Paid volunteer time off

Open Time Off

Mini-Grant $500

Educational Reimbursement

Job summary

Harvard Pilgrim Health Care Institute is seeking a SAS Programmer to join the Division of Health Policy and Insurance Research. The role focuses on cleaning, processing, and analyzing large health insurance claims datasets under supervision by a senior programmer and project manager.

You will create analytic datasets, develop SAS programs to generate variables, and contribute to manuscript preparation for internal and external research projects.

Qualifications

• Bachelor's Degree (BA, BS) required.
• At least 2 years of full-time SAS programming experience, including macro programming and PROC SQL.
• Experience transforming and analyzing large administrative health care data (claims data).
• Knowledge of epidemiologic and biostatistics principles and methods.
• Ability to prioritize work and meet deadlines.
• Proficiency with Microsoft Excel and other MS Office tools.
• Strong organizational skills and attention to detail; collaborative and independent work style.

Responsibilities

• 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 with complex data linkages and transformations.
• Generate descriptive statistics and conduct statistical analyses with investigators and senior programmers.
• Display results using Excel or similar tools in graphical or numerical formats.
• Contribute to manuscript and report development and participate in project meetings.

Skills

SAS programming

Data analysis

Excel

Team collaboration

Education

Bachelor's Degree (BA/BS)

Tools

SAS macro programming

PROC SQL

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 have 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.

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 https://www.point32health.org/careers/benefits/

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.