Data Engineer II

Ann & Robert H. Lurie Children’s Hospital of Chicago provides superior pediatric care in a setting that offers the latest benefits and innovations in medical technology, research and family-friendly design. As the largest pediatric provider in the region with a 140-year legacy of excellence, kids and their families are at the center of all we do. Ann & Robert H. Lurie Children’s Hospital of Chicago is ranked in all 10 specialties by the U.S. News & World Report.Location680 Lake Shore DriveJob DescriptionThe Data Engineer II independently implements and maintains data systems, working with Product, Business Analysts, and peers to optimize performance and efficiency across operational and analytical workflows. The role manages responsibilities autonomously, making day-to-day technical decisions and completing work with appropriate guidance for more complex situations. The Data Engineer II implements and manages data ingestion, storage, and integration and contributes to highly integrated, complex data solutions through intimate knowledge of core data management solutions and architectures, including warehouse, lake, and medallion patterns, as well as hybrid deployments across on-premises and cloud environments. The Data Engineer II demonstrates a strong understanding of foundational data processes, including governance, master data management, and metadata management.Essential Job Functions:Implements and manages data ingestion, integration, storage, and processing workflows across systems to support operational and analytical use cases, including self-service analytics and reportingImplements complex data transformations and develops data models independently, resolving moderate conflicts and ensuring alignment with established standardsEnsures data quality and reliability by applying validation practices, troubleshooting issues, and maintaining accurate metadata, catalog, classification, and lineage informationMonitors data pipelines proactively and troubleshoots and resolves operational issues to maintain system performance and continuityApplies security and access controls and implements infrastructure and deployment processes to ensure compliant and reliable data solutionsCollaborates with Product, Business Analysts, IT, and business teams to deliver data solutions, communicating technical concepts clearly, aligning work to business goals, and providing guidance to less experienced team membersDelivers features end-to-end, following Agile practices, maintaining accurate documentation, and contributing to onboarding and continuous improvement of team processesOther job functions as assigned.Knowledge, Skills and Abilities: Bachelor’s degree in a related quantitative or technical field preferred.5+ years of relevant hands-on experience in data management or data engineering disciplines required, including areas such as data integration, data modeling, data optimization, data quality, or related responsibilities.Experience in a healthcare industry environment preferred.Strong working knowledge of modern data platforms and storage solutions, with the ability to design, implement, and optimize data solutions across systems using established patterns.Demonstrated ability to develop and manage data ingestion, integration, and orchestration workflows using standard ETL/ELT frameworks and tooling.Advanced working knowledge of SQL for querying, transforming, and optimizing data, with hands-on experience using scripting languages such as Python for data processing and automation.Applied understanding of data modeling, transformation, and visualization concepts to support scalable data solutions and downstream analytics and self-service use.Independently applies data quality, governance, and security practices in accordance with established standards and policies, including appropriate handling of sensitive data.Diagnoses and resolves data and pipeline issues independently, applying critical thinking and sound problem-solving practices.Collaborates effectively with Product, IT, and business stakeholders, communicates technical concepts clearly, and aligns data solutions to business needs and outcomes.Working knowledge of healthcare data concepts and environments preferred.EducationPay Range$93,600.00-$154,440.00 SalaryAt Lurie Children’s, we are committed to competitive and fair compensation aligned with market rates and internal equity, reflecting individual contributions, experience, and expertise. The pay range for this job indicates minimum and maximum targets for the position. Ranges are regularly reviewed to stay aligned with market conditions.In addition to base salary, Lurie Children’s offer a comprehensive rewards package that may include differentials for some hourly employees, leadership incentives for select roles, health and retirement benefits, and wellbeing programs. For more details on other compensation, consult your recruiter or click the following link to learn more about our benefits.Benefit StatementFor full time and part time employees who work 20 or more hours per week we offer a generous benefits package that includes:Medical, dental and vision insuranceEmployer paid group term life and disabilityEmployer contribution toward Health Savings AccountFlexible Spending AccountsPaid Time Off (PTO), Paid Holidays and Paid Parental Leave403(b) with a 5% employer matchVarious voluntary benefits:Supplemental Life, AD&D and DisabilityCritical Illness, Accident and Hospital Indemnity coverageTuition assistanceStudent loan servicing and supportAdoption benefitsBackup Childcare and EldercareEmployee Assistance Program, and other specialized behavioral health services and resources for employees and family membersDiscount on services at Lurie Children’s facilitiesDiscount purchasing programThere’s a Place for You with UsAt Ann & Robert H. Lurie Children’s Hospital of Chicago and its affiliates (collectively “Lurie Children’s”), we embrace and celebrate diversity and equity in a serious way. We are committed to building a team with a variety of backgrounds, skills, and viewpoints — recognizing that diverse identities strengthen our workplace and the care we can provide to the Chicago community and beyond. We treat everyone fairly, appreciate differences, and make meaningful connections that foster belonging and allyship. This is a place where you can be your best, so we can give our best to the patients and families who trust us with their care. Lurie Children’s and its affiliates are equal employment opportunity employers. We value diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity or expression, religion, national origin, ancestry, age, disability, marital status, pregnancy, protected veteran status, order of protection status, protected genetic information, or any other characteristic protected by law. For questions about how to request an accommodation please contact: View email address on click.appcast.io NoticeLurie Children’s utilizes certain AI-enabled features within our recruiting platform to support candidate engagement and assist recruiters in identifying and prioritizing applicants whose experience aligns with job requirements. All employment decisions are made by individuals.It is a civil rights violation with respect to recruitment, hiring, promotion, or employment for an employer to use artificial intelligence that has the effect of subjecting employees to discrimination on the basis of protected classes under the Illinois Human Rights Act or to use zip codes as a proxy for protected classes.For questions about the use of artificial intelligence in this process or any additional support, please contact: View email address on click.appcast.io: Streeterville, Chicago, ILType: Full time