DeveloperJobs.io
← Back to all jobs

Job Description

Join Shirley Ryan AbilityLab in Chicago, where your work helps power a next generation data platform used by clinicians, researchers, administrators, and executives. This role sits on the Data Platform Engineering team and supports long-term, secure, and scalable use of hospital data through ETL pipelines, data infrastructure, data quality processes, and dependable platform operations.

What you’ll do

Collaborate across Data Platform Engineering, Data Analytics, Data Governance, other Information Services teams, executive leadership, external consultants, and hospital stakeholders to build secure, stable, scalable data plans for the flow of information across the organization.

  • Assist in creating scalable data infrastructure and platforms to collect and process large volumes of structured and unstructured data for clinical, research, and business use.
  • Define and implement methods to track data quality, completeness, redundancy, compliance, and operational performance, including ongoing improvement.
  • Develop strategies for data capacity planning, security, lifecycle management, scalability, and backup and archiving.
  • Create data source mappings, data movement flows, interfaces, and analytics pathways to support accurate downstream delivery and reporting.
  • Set engineering and architecture standards for securely 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 with multiple stakeholders.
  • Acquire and maintain data from primary and secondary data sources.
  • Identify and evaluate opportunities to enhance current data architecture and data management technologies.
  • Monitor and help ensure consistent uptime, availability, and access for the data platform and related systems.
  • Develop processes for deploying flexible, high-quality, and secure data management solutions, leveraging tools to automate key workflows.
  • Create instrumentation and metrics to track ecosystem health and support continuous improvement of KPIs.

What you’ll bring

  • Bachelor’s or master’s degree in computer science or computer engineering (or related area such as data science, mathematics, statistics, economics) with demonstrated proficiency in the skills below.
  • SQL expertise (5 years professional), including MySQL, PostgreSQL, and derivatives for complex query development, tuning, and optimization.
  • Professional experience with Python and/or Java (5 years), focused on data manipulation, database interaction, ETL automation, big data technologies, and performance optimization.
  • Knowledge of HIPAA and the ability to implement data security standards aligned with HIPAA, including interoperability with HL7 and FHIR.
  • At least 2–5 years establishing ETL/ELT processes for securely transporting data between cloud and local databases.
  • Experience with 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.
  • Demonstrated ability working with large data sets and relational databases, including data warehousing, scalability, reliability, and access/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-services.
  • Strong communication skills, including translating 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 projects or advocating incremental adoption of new technologies.
  • Familiarity with Oracle-Cerner EHR systems (Millennium data model and CCL) will receive strong consideration.
  • Familiarity with research CDMs such as OMOP, i2b2, and PCORnet will be strongly considered.
  • Experience with REST/RESTful APIs, streaming platforms, and role-based access and encryption will be strongly considered.

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

Compensation and benefits

Pay range: $71,278 - $124,500 per year (with reporting ranges also listed as $71,200 - $124,500). Actual compensation varies based on experience, qualifications, and internal equity.

  • A comprehensive benefits program competitive with industry peers in the geographic location: https://www.sralab.org/benefits
  • Benefits and eligibility vary by position

Additional details

  • Location: Chicago, IL (onsite)
  • Reporting to: Director Data Platform Architecture
  • Working conditions: Normal office environment with little or no exposure to dust or extreme temperature

Similar Jobs