Join Shirley Ryan AbilityLab in Chicago and help build a secure, next-generation data platform that supports clinicians, researchers, administrators, and executives. You will work with the Data Platform Engineering team in a cross-functional environment, partnering with Data Analytics, Data Governance, Information Services, executive leadership, external consultants, and hospital stakeholders to turn hospital data into meaningful, reliable insights.
Location: Chicago, IL (onsite)
Compensation: USD 71,278 - 124,500 per yearly
Experience: 2+ years
Education: Bachelor’s or master’s degree in computer science or computer engineering, or a related area
What you will do
As part of the Data Platform Engineering team, you will assist in creating long-term, secure plans for how hospital data flows across systems. Your focus will include ETL pipelines, data infrastructure, data quality processes, and lifecycle approaches that support scalable collection and processing of both structured and unstructured data.
- Collaborate with Data Platform Engineering and partners across Data Analytics, Data Governance, Information Services, leadership, and stakeholders to develop a secure and stable data flow roadmap.
- Build scalable infrastructure and platforms to collect and process large-scale data for clinical, research, and business analysis.
- Define and implement methods to track data quality (including completeness and redundancy), compliance, and operational performance of data systems.
- Create strategies for data capacity planning, security, lifecycle data management, scalability, backup, and archiving.
- Develop data source mapping, data movement plans, interfaces, and analytics to support accurate downstream delivery and reporting.
- Establish engineering and architecture standards for secure data handling, including naming, describing, managing, modeling, cleaning, enriching, transforming, transferring, storing, searching, and delivering data.
- Support 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 and secondary sources.
- Identify and evaluate opportunities to enhance current data architecture and data management technologies.
- Monitor and maintain consistent uptime, availability, and access for performance and reliability.
- Develop processes to support deployment of flexible, high-quality, secure data management solutions.
- Use available tools to automate key data management processes and build instrumentation and metrics to track ecosystem health and drive continuous improvement of KPIs.
What you bring
- Demonstrated proficiency through a Bachelor’s or master’s degree in computer science or computer engineering, or a related area (data science, mathematics, statistics, economics, etc.).
- SQL expertise (5 years professional), including experience with MySQL, PostgreSQL, and derivatives for complex query building, tuning, and optimization.
- Python and/or Java (5 years professional) focused on data manipulation, database interaction, ETL automation, big data technologies, and performance optimization.
- Knowledge of HIPAA and ability to implement 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.
- Experience using or integrating with systems including Snowflake, AWS RDS (Aurora), OCI, Microsoft Power Apps, and Informatica is a plus.
- Experience with other AWS data utilities (such as API Gateway and S3) is a plus.
- Experience handling large datasets 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 for the analytics layer and self-service.
- Strong communication skills, including translating technical details for non-technical audiences through documentation and diagrams.
- Demonstrated ability to manage long-term projects and see work through to completion.
- Proactive approach to proposing and developing new initiatives and advocating for incremental adoption of new technologies.
- Strong consideration with familiarity with Oracle-Cerner EHR systems, including Millennium data model and CCL.
- Strong consideration with familiarity with research CDMs such as OMOP, i2b2, and PCORnet.
- Strong consideration with experience developing REST/RESTful APIs, streaming platforms, and role-based access and encryption.
Tools and technologies
- 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
Benefits and compensation
- A comprehensive benefits program competitive with industry peers in the geographic location: https://www.sralab.org/benefits
- Benefits and eligibility can vary by position.
- Compensation varies based on experience, qualifications, and internal equity.
Reporting to: Director Data Platform Architecture
Working conditions: Normal office environment with little or no exposure to dust or extreme temperature.