ETL Programmer – Intermediate

Join one of the nations most comprehensive academic medical centersUChicago Medicine as anETLProgrammer Intermediatein ourIT Enterprise Architecturedepartment. This position will be primarily a work from home opportunity with the requirement to come onsite as needed. You will need tobe based in the greater Chicagoland area.

Under general supervision the ETL Programmer Intermediatewill solve complex BI and data analyticsneedsrelated to data acquisition cleansing and deliveringanalyticsdashboardsand reports. Additionally you will deliver projects and enhancement requests using traditional SDLCmethodology; 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 proactivelymonitorthe 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

• Bachelors degree or equivalent relevant certification in programming computer science and/or healthcare businessmanagementor 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 yearofexperience 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

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

Preferred Qualifications

• 1yearsof 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 andlarge amountsof 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

Weve 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. Were in this together: working to advance medical innovation serve the health needs of the community and move our collective knowledge forward. If youd like to add enriching human life to your profile UChicago Medicine is for you. Here at the forefront were 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.