What are the responsibilities and job description for the Senior Programmer Analyst position at Roswell Park Comprehensive Cancer Center?
Title
Senior Programmer Analyst
Job Type
Regular
Company
Roswell Park Comprehensive Cancer Center
Department
Information Technology
Time Type
Full time
Weekly Hours
40
Fte
1
Shift
First Shift (United States of America)
Summary
The Sr. Programmer/Analyst is part of an interdisciplinary team focused on improving patient care, optimizing workflows, ensuring patient safety, supporting the data needs of clinical and business stakeholders throughout the organization, and developing innovative software solutions. They are responsible for developing and maintaining web-based tools, server-based processes, and cloud-hosted applications to support business, operational, research, and reporting needs. The candidate will support maintenance and development of our Enterprise Data Warehouse (EDW) API, EDW integrations for extracting and transforming data from multiple source systems and help to maintain a warehouse containing a rich set of cross-functional data to enable reporting across the organization. They will also work with other technical staff and subject matter experts throughout the organization to develop and maintain complex software solutions. They will work with a variety of technologies including back-end application infrastructure and APIs, database systems, ETL processes, Power BI, Intersystems platform, and other enterprise data management tools such as Snowflake and Microsoft Fabric. They may also handle special projects tied to urgent patient safety issues, executive priority work, audit requests, and government regulation.
Qualifications
Required Education and Experience
Required degrees must have been granted by an accredited school, college or university or one recognized by Roswell Park Comprehensive Cancer Center as following acceptable educational practices.
Preferred Qualifications
Candidates must have experience developing applications with python and PHP using Git/Gitlab for source code revision management. The candidate should have experience performing code reviews and mentoring junior developers. Relational database experience with MySQL/MariaDB or MS SQL Server is required including design and development of complex data warehouse schemas and data queries. The ideal candidate will also have development experience with the Microsoft Fabric platform including Power BI, Data Marts, Data Flows, and Warehouses. Familiarity with Intersystems HealthConnect and manipulating HL7 messages is advantageous. Preferred candidates will have experience developing and consuming REST APIs in PHP/python and be familiar with docker containers including their creation and deployment The preferred candidate will have excellent communication and analytical skills and will have experience working with subject matter experts to gather requirements, test, and maintain software over time.
Equal Employment Opportunity Statement
Roswell Park Cancer Institute Corporation (RPCIC) and Health Research Inc. (HRI) Roswell Park Division believe that all persons are entitled to equal employment opportunities, and we do not discriminate against our employees, applicants or job seekers because of their race, color, religion, sex, sexual orientation, gender identity or expression, national origin, creed, age, disability, pregnancy-related condition, military or veteran status, marital or familial status, domestic violence victim status, citizenship status, genetic information, individual’s relationship or association with a member of a protected category or any other protected group status as defined by law.
Reasonable Accommodation Request
RPCIC and HRI are committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please email HR-PayAndBenefits@RoswellPark.org and let us know the nature of your request and your contact information.
Our Core Values
RPCIC and HRI are committed to providing an environment where patients, families, employees and community are treated with courtesy and respect. We support an inclusive environment that nurtures the talents, skills and abilities of each individual to embody and reflect our core values: Innovation, Integrity, Teamwork, Commitment, Compassion and Respect.
Historical Compensation Information Statement
Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Governor’s Office of Employee Relations at (518) 474-6988 or via email at info@goer.ny.gov.
Senior Programmer Analyst
Job Type
Regular
Company
Roswell Park Comprehensive Cancer Center
Department
Information Technology
Time Type
Full time
Weekly Hours
40
Fte
1
Shift
First Shift (United States of America)
Summary
The Sr. Programmer/Analyst is part of an interdisciplinary team focused on improving patient care, optimizing workflows, ensuring patient safety, supporting the data needs of clinical and business stakeholders throughout the organization, and developing innovative software solutions. They are responsible for developing and maintaining web-based tools, server-based processes, and cloud-hosted applications to support business, operational, research, and reporting needs. The candidate will support maintenance and development of our Enterprise Data Warehouse (EDW) API, EDW integrations for extracting and transforming data from multiple source systems and help to maintain a warehouse containing a rich set of cross-functional data to enable reporting across the organization. They will also work with other technical staff and subject matter experts throughout the organization to develop and maintain complex software solutions. They will work with a variety of technologies including back-end application infrastructure and APIs, database systems, ETL processes, Power BI, Intersystems platform, and other enterprise data management tools such as Snowflake and Microsoft Fabric. They may also handle special projects tied to urgent patient safety issues, executive priority work, audit requests, and government regulation.
Qualifications
Required Education and Experience
- Doctorate degree in computer science, engineering, data science, management information systems or a related field; or
- Master's degree in computer science, engineering, data science, management information systems or a related field and the equivalent of two (2) years of full-time software development experience; or
- Bachelor’s degree in computer science, engineering, data science, management information systems or a related field and the equivalent of four (4) years of full-time software development experience; or
- Associates degree in computer science, engineering, data science, management information systems or a related field and the equivalent of six (6) years of full-time software development experience; or
- High School diploma or High School Equivalency diploma with a diploma or certificate in a computer science, or related field and the equivalent of eight (8) years of full-time software development experience.
Required degrees must have been granted by an accredited school, college or university or one recognized by Roswell Park Comprehensive Cancer Center as following acceptable educational practices.
Preferred Qualifications
Candidates must have experience developing applications with python and PHP using Git/Gitlab for source code revision management. The candidate should have experience performing code reviews and mentoring junior developers. Relational database experience with MySQL/MariaDB or MS SQL Server is required including design and development of complex data warehouse schemas and data queries. The ideal candidate will also have development experience with the Microsoft Fabric platform including Power BI, Data Marts, Data Flows, and Warehouses. Familiarity with Intersystems HealthConnect and manipulating HL7 messages is advantageous. Preferred candidates will have experience developing and consuming REST APIs in PHP/python and be familiar with docker containers including their creation and deployment The preferred candidate will have excellent communication and analytical skills and will have experience working with subject matter experts to gather requirements, test, and maintain software over time.
Equal Employment Opportunity Statement
Roswell Park Cancer Institute Corporation (RPCIC) and Health Research Inc. (HRI) Roswell Park Division believe that all persons are entitled to equal employment opportunities, and we do not discriminate against our employees, applicants or job seekers because of their race, color, religion, sex, sexual orientation, gender identity or expression, national origin, creed, age, disability, pregnancy-related condition, military or veteran status, marital or familial status, domestic violence victim status, citizenship status, genetic information, individual’s relationship or association with a member of a protected category or any other protected group status as defined by law.
Reasonable Accommodation Request
RPCIC and HRI are committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the employment process, please email HR-PayAndBenefits@RoswellPark.org and let us know the nature of your request and your contact information.
Our Core Values
RPCIC and HRI are committed to providing an environment where patients, families, employees and community are treated with courtesy and respect. We support an inclusive environment that nurtures the talents, skills and abilities of each individual to embody and reflect our core values: Innovation, Integrity, Teamwork, Commitment, Compassion and Respect.
Historical Compensation Information Statement
Pursuant to Executive Order 161, no State entity, as defined by the Executive Order, is permitted to ask, or mandate, in any form, that an applicant for employment provide his or her current compensation, or any prior compensation history, until such time as the applicant is extended a conditional offer of employment with compensation. If such information has been requested from you before such time, please contact the Governor’s Office of Employee Relations at (518) 474-6988 or via email at info@goer.ny.gov.