Senior Data Engineer

About the American College of Surgeons

The American College of Surgeons (ACS) 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 Senior Data Engineer is responsible for architecting, deploying, and maintaining scalable data solutions on Microsoft Azure that empower analytics and applications across the organization. This role designs end-to-end data pipelines using Azure Data Factory and Azure Synapse Analytics, implements data storage on Azure Data Lake Storage Gen2, and leverages Azure Databricks for large-scale processing. By integrating various Azure services, the Senior Data Engineer accelerates data ingestion, transformation, and delivery to reporting and BI tools. They ensure data quality, security, and governance with Azure Purview and monitor pipeline health with Azure Monitor, enabling stakeholders to access reliable, high-performance data for informed decision-making.

This exempt position will report to the AVP, IT in the Division of Information Technology. It is based in our Chicago office and is a hybrid role: 3 days per week in the office/2 days per week remote.

The anticipated salary range for this position is $140,000 - $155,000 (commensurate with related experience).

Required Education and/or Experience:

• Bachelor’s degree or higher from an accredited college or university is required.
  
  
• At least 4-7+ years of similar or related experience is required.
  
  
• Understanding of Azure SQL Database, Azure Data Lake, Azure Data Factory, and Azure Synapse Analytics.
  
  
• Strong capabilities in strategic data modeling and advanced SQL for data manipulation.
  
  
• Expertise in creating visual reports and dashboards with tools like Power BI, integrated with Azure for real-time analytics.
  
  
• Experience with Reporting solutions such as Crystal Reports or SSRS.
  
  
• Skills in using ETL tools like Azure Data Factory and implementing data governance and security measures within Azure.
  
  
• Azure DevOps and/or other ticketing / pipeline tools

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
• Tuition Reimbursement
• 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

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.