ETL Programmer – Intermediate

Join one of the nation’s most comprehensive academic medical centers, UChicago Medicine, as an ETL Programmer – Intermediate in our IT Enterprise Architecture department. This position will be primarily a work from home opportunity with the requirement to come onsite as needed. You will need to be based in the greater Chicagoland area.   

Under general supervision, the ETL Programmer – Intermediate will solve complex BI and data analytics needs related to data acquisition, cleansing and delivering analytics, dashboards, and reports. Additionally, you will deliver projects and enhancement requests using traditional SDLC methodology; resolve production incidents, provide operational support, and develop plans to ensure compliance with SLA; and engage with business to understand system requirements and work with broader IT team to design and implement solutions.  

Essential Job Functions 

• Perform data analytics, build reports and data extract scripts 

• Setup/configure required monitoring and alerts to proactively monitor the health of Production Systems 

• Review, understand and build solutions as per system requirements and overall solution design 

• Perform quality checks to ensure deliverables meet business requirements 

• Execute day-to-day development and support activities 

• Adhere to IT standards and processes to ensure security and operational compliance 

• Provide operational support and develop plans to ensure compliance with SLA 

Required Qualifications 

• Bachelor’s degree or equivalent relevant certification in programming, computer science and/or healthcare, business management or information systems  

• 2+ years’ experience with systems analysis, programming in SQL, and RDBMS modeling 

• 2+ years of hands-on ETL (Extract, Transform, Load) programming experience 

• 1 year of experience in technical documentation writing 

• Proven problem-solving skills 

• Must work well in a team environment and be able to partner with both business and technical team members 

• Excellent oral and written communication skills and good interpersonal skills required 

• Requires strong multitasking skills; must be a self-starter and able to deliver results on a proactive and independent basis 

Preferred Qualifications 

• 1+ years of Microsoft SSIS and BI tool experience (Business Objects, Tableau, Cognos, Google Analytics, etc.) 

• Experience with Data Extractions using SSIS  

• Healthcare experience 

• Experience with large enterprise systems and large amounts of data 

• Proficient with NoSQL database & Real-time data analytics 

• Experience with Epic Clarity data  

Position Details  

• Job Type/FTE: Full Time (1.0 FTE)  

• Shift: Days  

• Job Location: Flexible (Darien)  

• Unit/Department: IT Enterprise Architecture - Hyde Park  

• CBA Code: Non-Union 

We’ve been at the forefront of medicine since 1899. We provide superior healthcare with compassion, always mindful that each patient is a person, an individual. To accomplish this, we need employees with passion, talent and commitment… with patients and with each other. We’re in this together: working to advance medical innovation, serve the health needs of the community, and move our collective knowledge forward. If you’d like to add enriching human life to your profile, UChicago Medicine is for you. Here at the forefront, we’re doing work that really matters. Join us. Bring your passion.

UChicago Medicine is growing; discover how you can be a part of this pursuit of excellence at: UChicago Medicine Career Opportunities

UChicago Medicine is an equal opportunity employer.  We evaluate qualified applicants without regard to race, color, ethnicity, ancestry, sex, sexual orientation, gender identity, marital status, civil union status, parental status, religion, national origin, age, disability, veteran status and other legally protected characteristics.

As a condition of employment, all employees are required to complete a pre-employment physical, background check, drug screening, and comply with the flu vaccination requirements prior to hire. Medical and religious exemptions will be considered for flu vaccination consistent with applicable law.

Compensation & Benefits Overview

UChicago Medicine is committed to transparency in compensation and benefits.  The pay range provided reflects the anticipated wage or salary reasonably expected to be offered for the position.

The pay range is based on a full-time equivalent (1.0 FTE) and is reflective of current market data, reviewed on an annual basis. Compensation offered at the time of hire will vary based on candidate qualifications and experience and organizational considerations, such as internal equity. Pay ranges for employees subject to Collective Bargaining Agreements are negotiated by the medical center and their respective union.

Review the full complement of benefit options for eligible roles at Benefits - UChicago Medicine.