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.