Data Engineer

Shirley Ryan AbilityLab

Chicago (IL)

On-site

USD 71,000 - 125,000

Full time

3 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Benefits package

Job summary

Shirley Ryan AbilityLab is building a next-generation data platform, and the Data Engineer will play a central role within the Data Platform Engineering team. This onsite position in Chicago supports a cross-functional effort to turn hospital data into meaningful, secure, and reliable capabilities for clinicians, researchers, administrators, and executive stakeholders.

The role focuses on ETL pipelines, data infrastructure, data quality processes, and secure data management.

Qualifications

  • Bachelor’s or Master’s degree in computer science or computer engineering or related field with demonstrated proficiency.
  • 5+ years professional experience with SQL including tuning and optimization.
  • 5+ years professional experience with Python and/or Java for data manipulation and ETL automation.
  • Experience establishing ETL/ELT for securely transporting data between cloud and on-premise databases.
  • Knowledge of HIPAA data security standards, HL7, and FHIR.

Responsibilities

  • Collaborate with cross-functional teams and stakeholders across departments.
  • Develop secure, scalable long-term plans for hospital data flow.
  • Support scalable data infrastructure for large volumes of structured and unstructured data.
  • Track data quality, completeness, redundancy, and operational performance.
  • Define data architecture standards for naming, describing, and delivering data securely.

Skills

SQL
Python
Java
HIPAA compliance
ETL/ELT
Data governance
REST APIs
Data modeling

Education

Bachelor’s or Master’s in CS/CS Eng

Tools

MySQL
PostgreSQL
Snowflake
AWS RDS (Aurora)
Informatica
Power Apps

Job description

Shirley Ryan AbilityLab is building a next-generation data platform, and the Data Engineer will play a central role within the Data Platform Engineering team. This onsite position in Chicago supports a cross-functional effort to turn hospital data into meaningful, secure, and reliable capabilities for clinicians, researchers, administrators, and executive stakeholders.

The role focuses on ETL pipelines, data infrastructure, data quality processes, and secure data management. You will help shape long-term plans for the flow of hospital data while ensuring the platform remains available, performant, and scalable.

What you’ll do
  • Collaborate with the Data Platform Engineering team, Data Analytics and Data Governance teams, other Information Services teams, executive leadership, external consultants, and hospital stakeholders across departments.
  • Assist in developing secure, stable, scalable long-term plans for the flow of hospital data, primarily leveraging existing resources.
  • Support scalable data infrastructure and platforms to collect and process large volumes of structured and unstructured data for clinical, research, and business analysis.
  • Establish methods to track data quality and completeness, redundancy, compliance, improvement, and related operational performance.
  • Create strategies for data capacity planning, data security, life cycle data management, scalability, backup, and archiving.
  • Map data sources, data movement, interfaces, and analytics to support accurate downstream delivery and reporting.
  • Define engineering and architecture standards covering naming, describing, managing, modeling, cleaning, enriching, transforming, transferring, storing, searching, and securely delivering data within the hospital.
  • Assist data stewardship by tagging and defining data elements with subject matter experts and the Data Governance team.
  • Participate in data structure and information model design across multiple stakeholders.
  • Acquire and maintain data from primary or secondary data sources.
  • Identify and evaluate opportunities to enhance current data architecture and data management technologies.
  • Monitor, update, and help ensure consistent uptime, availability, and access for the data platform and other data systems.
  • Develop processes to support deployment of high-quality, flexible, and secure data management solutions.
  • Use available tools to drive automation of key data management processes.
  • Create instrumentation and metrics to measure ecosystem health and support continuous improvement of KPIs.
Required qualifications
  • Bachelor’s or master’s degree in computer science or computer engineering, or a related area (data science, mathematics, statistics, economics, etc.) with demonstrated proficiency in the skills below.
  • Expertise in SQL (5 years professional), including building complex queries plus tuning and optimization using MySQL, PostgreSQL, and derivatives.
  • Expertise in Python and/or Java (5 years professional) with a focus on data manipulation, database interaction, ETL automation, big data technologies, and performance optimization.
  • Knowledge of and ability to implement HIPAA data security standards, including interoperability with HL7 and FHIR.
  • At least 2-5 years of professional experience establishing ETL/ELT processes for securely transporting data between cloud and local databases.
  • Demonstrated experience handling large data sets and relational databases, including data warehousing, scalability, reliability, access, and provisioning.
  • Experience evaluating and leveraging AI utilities in data warehouse and data governance tools for model and pipeline development while ensuring quality data for the analytics layer and self-service.
  • Strong communication skills, including the ability to translate highly technical information for non-technical audiences through documentation and diagrams.
  • Ability to manage and see through long-term projects.
  • Proactive work habits, including proposing and developing new initiatives or advocating incremental adoption of new technologies.
  • Experience building REST/RESTful APIs, streaming platforms, and role-based access and encryption will be strongly considered.
Preferred experience (strong consideration)
  • Familiarity with Oracle-Cerner EHR systems, including the Millennium data model and CCL.
  • Familiarity with research CDMs such as OMOP, i2b2, and PCORnet.
  • Experience establishing ETL/ELT between Snowflake, AWS RDS (Aurora), OCI, Microsoft Power Apps, and using Informatica (a plus).
  • Experience with other AWS data utilities such as API Gateway and S3 (a plus).
Technologies you’ll work with
  • SQL, MySQL, PostgreSQL
  • Python, Java
  • HIPAA, HL7, FHIR
  • ETL, ELT
  • Snowflake, AWS RDS (Aurora), OCI
  • Microsoft Power Apps, Informatica
  • AWS API gateway, S3
  • AI utilities
  • Oracle-Cerner EHR systems, Millennium data model, CCL
  • OMOP, i2b2, PCORnet
  • REST/RESTful APIs, streaming platforms, role-based access, encryption
Reporting and work setting
  • Reports directly to the Director Data Platform Architecture.
  • Normal office environment with little or no exposure to dust or extreme temperature.
Compensation and benefits
  • Salary range: $71,278 - $124,500 annually (pay range listed as $71,200 - $124,500).
  • Benefits: Shirley Ryan AbilityLab offers a comprehensive benefits program competitive with industry peers in geographic locations: https://www.sralab.org/benefits.
  • Benefits and eligibility can vary by position; actual compensation may vary based on experience, qualifications, and internal equity.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Shirley Ryan AbilityLab • United States

On-site
USD 71,000 - 125,000
Senior Data Engineer
Senior Data Engineer

uniteus • United States

Remote
USD 145,000 - 170,000
Senior Data Engineer
Senior Data Engineer

Dell Medical School • Austin (TX)

On-site
USD 117,000 - 159,000
Data Warehouse Architect
Data Warehouse Architect

Hebrew Rehabilitation Center • Boston (MA)

Hybrid
USD 113,000 - 170,000
Senior Data Engineer
Senior Data Engineer

Moffitt Cancer Center • Tampa (FL)

On-site
USD 108,000 - 165,000
Data Engineer I
Data Engineer I

Duly Health and Care • Downers Grove (IL)

On-site
USD 65,000 - 85,000
Medical, dental, and vision benefits
Tuition reimbursement
Immediate 401(k) match
+1
Senior Data Engineer
Senior Data Engineer

CHG Healthcare • Salt Lake City (UT)

On-site
USD 117,000 - 225,000
401(k) retirement plan
Medical and dental coverage
Onsite health centers
+1
Data Engineer (4631)
Data Engineer (4631)

Hireclout • Los Angeles (CA)

On-site
USD 150,000 - 220,000
100% employer-paid medical, dental, and vision coverage
401(k) with employer match
Generous PTO policy
+1
Senior Data Engineer
Senior Data Engineer

SCP Health • Lafayette (LA)

On-site
USD 87,000 - 128,000
Comprehensive benefits package
Competitive compensation
401(k) plan with company match
+4
Senior Data Engineer
Senior Data Engineer

Harnham • Philadelphia

Hybrid
USD 160,000 - 180,000
Competitive equity
Health, dental, and vision benefits
Flexible PTO