Data Engineer

At Northwestern Medicine, every patient interaction makes a difference in cultivating a positive workplace. This patient-first approach is what sets us apart as a leader in the healthcare industry. As an integral part of our team, you'll have the opportunity to join our quest for better healthcare, no matter where you work within the Northwestern Medicine system. At Northwestern Medicine, we pride ourselves on providing competitive benefits: from tuition reimbursement and loan forgiveness to 401(k) matching and lifecycle benefits, we take care of our employees. Ready to join our quest for better?

Description

Job Description

Deliver data warehouse and analytic solutions by ingesting, integrating, and curating data, building analytical solutions, and administering systems to deliver information to the health system. Create complex queries and stored procedures. Collaborate with the Architecture team in the design and execution of solutions. Ensures that new and existing data models, pipelines and databases are consistent with approved data architecture standards. Facilitate, analyze, design, and execute architecture solutions. Assists with ETL design, development and maintenance including data extraction, manipulation, reporting, analysis, source-target mapping, quality profiling, change data capture, code performance. Evaluate data quality and interpret results. Deploy data warehousing models and design fundamentals, including Kimball and Inmom. Technology: OLAP or Tabular cube software; Microsoft Power BI; Tableau; Crystal Reports; SSRS; SSIS; SSAS; Azure Data Factory; SQL; Agile environment.

Qualifications

Required Skills:

Bachelor’s degree in Computer Science/Engineering or related field plus five years of progressive experience in job offered or as data architect/ETL required. Required skills: 5 years with: data modeling/architecture; data warehousing models and design fundamentals (kimball & Inmom); OLAP/Tabular cube software; SQL for data extraction, manipulation, and reporting. Experience must include: Agile environment; complex SQL queries and stored procedures; Tableau; SSRS; SSIS; SSAS; developing and maintaining ETL/data pipeline. May work remotely at various locations in the Chicago area with ability to commute to HQ Chicago office as needed. Background check and drug test required.

Equal Opportunity

Northwestern Medicine is an affirmative action/equal opportunity employer and does not discriminate in hiring or employment on the basis of age, sex, race, color, religion, national origin, gender identity, veteran status, disability, sexual orientation or any other protected status.