American College of Surgeons
Database Programmer, Continuous Quality Improvement
American College of Surgeons, Chicago, Illinois, United States, 60290
About the American College of Surgeons
The American College of Surgeons is a professional and educational organization of surgeons that was founded in 1913 to raise the standards of surgical practice and improve the quality of care for surgical patients. The College is dedicated to the ethical and competent practice of surgery. Its achievements have significantly influenced the course of scientific surgery in America and have established it as an important advocate for all surgical patients.The College has more than 90,000 members and is the largest organization of surgeons in the world. For more information, visit www.facs.org.
Summary:
The Database Programmer, Continuous Quality Improvement (CQI) works with the department to provide oversight of the data conversion process and data sets for all CQI registries and special projects.This role focuses on data quality, data validations and security ensuring all registry data meets regulatory requirements.The position will work with the incumbents to update data structures, incorporate new variables in reports and support new projects.This position will understand and incorporate variables from data collection all the way through the process to reporting. It will also perform scheduled data imports, replication, validation, and exports.
This exempt position will report to the Senior Manager, CQI in the Division of Research and Optimal Patient Care.
It is based in our Chicago office and is a hybrid role: 3 days per week in the office/2 days per week remote.
Primary Responsibilities: Work with ACS registry and IT teams and external registry vendor(s) to ensure data marts are operating correctly and efficiently to meet program and participant needs. Continually evaluate and analyze operations related to data collection and management and make recommendations for improvements and modifications to ensure optimum functioning of the databases, including data automation.| Oversee the creation of data sets and dissemination of those data sets for ad-hoc reporting and high-level statistical reporting.Evaluate raw data to find issues with data integrity and data quality. Manage data collection, data processing, data validation, and warehousing for all CQI clinical registries, and work with internal resources and registry vendor(s) to ensure processes and methods use meet internal and external security and privacy standards. Update and implement Data Quality Assurance Plan. Work with team members to implement data quality checks for reports. Other duties as assigned. Required Education and/or Experience:
Bachelor's degree from an accredited college or university is required. At least 4+ years of similar data management experience is preferred. A high understanding and background in ETL, data architecture and creating reporting data tables is required. Must have Oracle database experience to independently code SQL and PL/SQL to create database objects such as tables, materialized views, triggers, procedures, packages, etc. Must be familiar with the extract, transform, load (ETL) processes, data marts, data analysis, security, and performance tuning. Must have strong written and verbal communication skills, along with excellent organizational skills. Experience in handling healthcare specific data such as PHI for HIPAA compliance a plus. Experience in data visualization, particularly in Power BI, Looker or other business intelligence tools is preferred. Must be proficient in all Microsoft Office applications, including Excel, Word, Sharepoint, Outlook, and Teams, and able to quickly learn new data platforms/applications. Comprehensive Benefits: We're committed to attracting and retaining top talent via valuable benefits!
Vacation, personal, and sick hours including 13 paid holidays per year Hybrid office schedule Medical-comprehensive coverage through BlueCross BlueShield Dental, Vision, and Prescription drug program 403(b) Matching Program Pension Plan Flexible Spending Medical/Dependent Care Employee Assistance Program Short Term/Long Term Disability Life Insurance Domestic Partner Coverage Plus many other great benefits!
The American College of Surgeons is committed to working with and providing reasonable accommodations 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 send an e-mail to recruitment@facs.org or call (312) 202-5000 and let us know the nature of your request and your contact information.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)
The American College of Surgeons is a professional and educational organization of surgeons that was founded in 1913 to raise the standards of surgical practice and improve the quality of care for surgical patients. The College is dedicated to the ethical and competent practice of surgery. Its achievements have significantly influenced the course of scientific surgery in America and have established it as an important advocate for all surgical patients.The College has more than 90,000 members and is the largest organization of surgeons in the world. For more information, visit www.facs.org.
Summary:
The Database Programmer, Continuous Quality Improvement (CQI) works with the department to provide oversight of the data conversion process and data sets for all CQI registries and special projects.This role focuses on data quality, data validations and security ensuring all registry data meets regulatory requirements.The position will work with the incumbents to update data structures, incorporate new variables in reports and support new projects.This position will understand and incorporate variables from data collection all the way through the process to reporting. It will also perform scheduled data imports, replication, validation, and exports.
This exempt position will report to the Senior Manager, CQI in the Division of Research and Optimal Patient Care.
It is based in our Chicago office and is a hybrid role: 3 days per week in the office/2 days per week remote.
Primary Responsibilities: Work with ACS registry and IT teams and external registry vendor(s) to ensure data marts are operating correctly and efficiently to meet program and participant needs. Continually evaluate and analyze operations related to data collection and management and make recommendations for improvements and modifications to ensure optimum functioning of the databases, including data automation.| Oversee the creation of data sets and dissemination of those data sets for ad-hoc reporting and high-level statistical reporting.Evaluate raw data to find issues with data integrity and data quality. Manage data collection, data processing, data validation, and warehousing for all CQI clinical registries, and work with internal resources and registry vendor(s) to ensure processes and methods use meet internal and external security and privacy standards. Update and implement Data Quality Assurance Plan. Work with team members to implement data quality checks for reports. Other duties as assigned. Required Education and/or Experience:
Bachelor's degree from an accredited college or university is required. At least 4+ years of similar data management experience is preferred. A high understanding and background in ETL, data architecture and creating reporting data tables is required. Must have Oracle database experience to independently code SQL and PL/SQL to create database objects such as tables, materialized views, triggers, procedures, packages, etc. Must be familiar with the extract, transform, load (ETL) processes, data marts, data analysis, security, and performance tuning. Must have strong written and verbal communication skills, along with excellent organizational skills. Experience in handling healthcare specific data such as PHI for HIPAA compliance a plus. Experience in data visualization, particularly in Power BI, Looker or other business intelligence tools is preferred. Must be proficient in all Microsoft Office applications, including Excel, Word, Sharepoint, Outlook, and Teams, and able to quickly learn new data platforms/applications. Comprehensive Benefits: We're committed to attracting and retaining top talent via valuable benefits!
Vacation, personal, and sick hours including 13 paid holidays per year Hybrid office schedule Medical-comprehensive coverage through BlueCross BlueShield Dental, Vision, and Prescription drug program 403(b) Matching Program Pension Plan Flexible Spending Medical/Dependent Care Employee Assistance Program Short Term/Long Term Disability Life Insurance Domestic Partner Coverage Plus many other great benefits!
The American College of Surgeons is committed to working with and providing reasonable accommodations 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 send an e-mail to recruitment@facs.org or call (312) 202-5000 and let us know the nature of your request and your contact information.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)