ETL Programmer – Intermediate at University of Chicago Medicine

Job DescriptionJoin 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 FunctionsPerform data analytics build reports and data extract scriptsSetup/configure required monitoring and alerts to proactivelymonitorthe health of Production SystemsReview understand and build solutions as per system requirements and overall solution designPerform quality checks to ensure deliverables meet business requirementsExecute day-to-day development and support activitiesAdhere to IT standards and processes to ensure security and operational complianceProvide operational support and develop plans to ensure compliance with SLARequired QualificationsBachelors degree or equivalent relevant certification in programming computer science and/or healthcare businessmanagementor information systems2 years experience with systems analysis programming in SQL and RDBMS modeling2 years of hands-on ETL (Extract Transform Load) programming experience1 yearofexperience in technical documentation writingProven problem-solving skillsMust work well in a team environment and be able to partner with both business and technical team membersExcellent oral and written communication skills and good interpersonal skillsRequires strong multitasking skills; must be a self-starter and able to deliver results on a proactive and independent basisPreferred Qualifications1yearsof Microsoft SSIS and BI tool experience (Business Objects Tableau Cognos Google Analytics etc.)Experience with Data Extractions using SSISHealthcare experienceExperience with large enterprise systems andlarge amountsof dataProficient with NoSQL database & Real-time data analyticsExperience with Epic Clarity dataPosition DetailsJob Type/FTE: Full Time (1.0 FTE)Shift: DaysJob Location: Flexible (Darien)Unit/Department: IT Enterprise Architecture - Hyde ParkCBA Code: Non-UnionWhy Join UsWeve 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 OpportunitiesUChicago 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 OverviewUChicago 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. Key Skills Machine Shop,Drilling,CSSD,ADMA,Drafting,HR Employment Type : Full-Time Experience: years Vacancy: 1