Weill Cornell Medical College
Programmer Analyst II
Weill Cornell Medical College, New York, New York, us, 10261
Title: Programmer Analyst II
Location: Upper East Side
Org Unit: Health Policy and Economics
Work Days: Monday-Friday
Weekly Hours: 35.00
Exemption Status: Exempt
Salary Range: $105,500.00 - $123,167.00
*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices
Position Summary
Under occasional direction, this role provides dedicated data management support for research projects by querying databases and preparing datasets for analysis. This role also provides data cleaning and programming support to Research Biostatisticians on other research projects, as needed, and will have occasional direction but is expected to work independently on a number of projects. Ideal candidate will have experience analyzing health insurance claims data, preferably Medicare data specifically, and coding expertise in SAS.
Job Responsibilities
Queries large databases (millions of records) using SAS and SQL. Regularly meets with internal and external collaborators to discuss data requests and progress updates. For collaborations with Research Biostatisticians, performs data cleaning in R or SAS to prepare datasets for statistical analysis. Performs basic data analyses and produces data-related reports, as needed. Education
Master's Degree in related field Experience
Master's Degree in biostatistics, or Master's degree in another health-related discipline with a concentration or certificate in biostatistics/data analysis.
Minimum 2-3 years' experience providing data management/programming support in a collaborative health research setting.
Experience working with large datasets (millions of records) preferred.
Coding expertise in SAS
Experience analyzing health insurance claims data, preferably Medicare data specifically
Knowledge, Skills and Abilities
Fluency in SAS programming, including proficiency with macro language. Proficiency in SQL and R programming. Excellent time management skills and ability to work under tight deadlines and manage changing priorities. Meticulous coding and documentation of code. Effective communication and familiarity with clinical terminology. Ability to translate clinical questions into appropriate queries. Experience with PostgreSQL databases beneficial. Licenses and Certifications
SAS Certification preferred.
Working Conditions/Physical Demands
Weill Cornell Medicine is a comprehensive academic medical center that is committed to excellence in patient care, scientific discovery, and the education of future physicians and scientists in New York City and around the world. Our doctors and scientists - faculty from Weill Cornell Medical College, Weill Cornell Graduate School of Medical Sciences, and the Weill Cornell Physician Organization - are engaged in world-class clinical care and cutting-edge research that connect patients to the latest treatment innovations and prevention strategies. Located in the heart of the Upper East Side's scientific corridor, Weill Cornell Medicine's powerful network of collaborators extends to its parent university Cornell University; to Qatar, where an international campus offers a U.S. medical degree; and to programs in Tanzania, Haiti, Brazil, Austria and Turkey. Our medical practices serve communities throughout New York City, and our faculty provide comprehensive care at NewYork-Presbyterian Hospital/Weill Cornell Medical Center, NewYork-Presbyterian/Lower Manhattan Hospital, NewYork-Presbyterian Hospital/Brooklyn Methodist Hospital, NewYork-Presbyterian Hospital/Westchester Behavioral Health Center, and NewYork-Presbyterian/Queens. At Weill Cornell Medicine, we work together to treat each individual, not just their conditions or illnesses, as we strive to deliver the finest possible care for our patients - the center of everything we do. Weill Cornell Medicine is an Equal Employment Opportunity Employer. Weill Cornell Medicine provides equal employment opportunities to all qualified applicants without regard to protected status, including race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status, or genetic information.
Location: Upper East Side
Org Unit: Health Policy and Economics
Work Days: Monday-Friday
Weekly Hours: 35.00
Exemption Status: Exempt
Salary Range: $105,500.00 - $123,167.00
*As required under NYC Human Rights Law Int 1208-2018 - Salary range for this role when Hired for NYC Offices
Position Summary
Under occasional direction, this role provides dedicated data management support for research projects by querying databases and preparing datasets for analysis. This role also provides data cleaning and programming support to Research Biostatisticians on other research projects, as needed, and will have occasional direction but is expected to work independently on a number of projects. Ideal candidate will have experience analyzing health insurance claims data, preferably Medicare data specifically, and coding expertise in SAS.
Job Responsibilities
Queries large databases (millions of records) using SAS and SQL. Regularly meets with internal and external collaborators to discuss data requests and progress updates. For collaborations with Research Biostatisticians, performs data cleaning in R or SAS to prepare datasets for statistical analysis. Performs basic data analyses and produces data-related reports, as needed. Education
Master's Degree in related field Experience
Master's Degree in biostatistics, or Master's degree in another health-related discipline with a concentration or certificate in biostatistics/data analysis.
Minimum 2-3 years' experience providing data management/programming support in a collaborative health research setting.
Experience working with large datasets (millions of records) preferred.
Coding expertise in SAS
Experience analyzing health insurance claims data, preferably Medicare data specifically
Knowledge, Skills and Abilities
Fluency in SAS programming, including proficiency with macro language. Proficiency in SQL and R programming. Excellent time management skills and ability to work under tight deadlines and manage changing priorities. Meticulous coding and documentation of code. Effective communication and familiarity with clinical terminology. Ability to translate clinical questions into appropriate queries. Experience with PostgreSQL databases beneficial. Licenses and Certifications
SAS Certification preferred.
Working Conditions/Physical Demands
Weill Cornell Medicine is a comprehensive academic medical center that is committed to excellence in patient care, scientific discovery, and the education of future physicians and scientists in New York City and around the world. Our doctors and scientists - faculty from Weill Cornell Medical College, Weill Cornell Graduate School of Medical Sciences, and the Weill Cornell Physician Organization - are engaged in world-class clinical care and cutting-edge research that connect patients to the latest treatment innovations and prevention strategies. Located in the heart of the Upper East Side's scientific corridor, Weill Cornell Medicine's powerful network of collaborators extends to its parent university Cornell University; to Qatar, where an international campus offers a U.S. medical degree; and to programs in Tanzania, Haiti, Brazil, Austria and Turkey. Our medical practices serve communities throughout New York City, and our faculty provide comprehensive care at NewYork-Presbyterian Hospital/Weill Cornell Medical Center, NewYork-Presbyterian/Lower Manhattan Hospital, NewYork-Presbyterian Hospital/Brooklyn Methodist Hospital, NewYork-Presbyterian Hospital/Westchester Behavioral Health Center, and NewYork-Presbyterian/Queens. At Weill Cornell Medicine, we work together to treat each individual, not just their conditions or illnesses, as we strive to deliver the finest possible care for our patients - the center of everything we do. Weill Cornell Medicine is an Equal Employment Opportunity Employer. Weill Cornell Medicine provides equal employment opportunities to all qualified applicants without regard to protected status, including race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status, or genetic information.