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. Location 680 Lake Shore Drive Job Description The 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 reporting Implements complex data transformations and develops data models independently, resolving moderate conflicts and ensuring alignment with established standards Ensures data quality and reliability by applying validation practices, troubleshooting issues, and maintaining accurate metadata, catalog, classification, and lineage information Monitors data pipelines proactively and troubleshoots and resolves operational issues to maintain system performance and continuity Applies security and access controls and implements infrastructure and deployment processes to ensure compliant and reliable data solutions Collaborates 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 members Delivers features end-to-end, following Agile practices, maintaining accurate documentation, and contributing to onboarding and continuous improvement of team processes Other 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. Education Pay Range $93,600.00-$154,440.00 Salary At 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. Benefit Statement Medical, dental and vision insurance Employer paid group term life and disability Employer contribution toward Health Savings Account Flexible Spending Accounts Paid Time Off (PTO), Paid Holidays and Paid Parental Leave 403(b) with a 5% employer match Various voluntary benefits: Supplemental Life AD&D and Disability Critical Illness Accident and Hospital Indemnity coverage Tuition assistance Student loan servicing and support Adoption benefits Backup Childcare and Eldercare Employee Assistance Program, and other specialized behavioral health services and resources for employees and family members Discount on services at Lurie Children’s facilities Discount purchasing program There's a Place for You with Us At 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. AI Notice Lurie 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 For questions about how to request an accommodation please contact: View email address on click.appcast.io 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. #J-18808-Ljbffr