Data Engineer II
About The Position
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.
Requirements
- 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.
- 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.
Nice To Haves
- Bachelor’s degree in a related quantitative or technical field preferred.
- Experience in a healthcare industry environment preferred.
- Working knowledge of healthcare data concepts and environments preferred.
Responsibilities
- 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.
Benefits
- 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
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
