This job has closed.

Northwestern Medicine · 1 month ago

Data Engineer, Enerprise Data, Full-time, Days

541 N. Fairbanks, Chicago, IL

Full-time

Onsite

Senior Level

$56/hr - $78.40/hr

5+ years exp

Northwestern Medicine is a leader in the healthcare industry focused on providing exceptional service to patients and internal clients. The Data Engineer will deliver data warehouse and analytic solutions, ensuring data integration and curation for the health system while collaborating with various teams to design and execute technical solutions.

Emergency MedicineHealth CareHospitalMedicalNutritionRehabilitation

H1B Sponsor Likely

Responsibilities

The Data Engineer is responsible for delivering data warehouse and analytic solutions by ingesting, integrating, and curating data, building analytical solutions, and administering systems to deliver information to the health system

Serves as a functional and content expert of the data warehouse to synthesize raw data into actionable information to be used in analytical solutions

Applies knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures

Collaborates with the Architecture team in the design and execution of solutions

Ensures that new and existing data models and databases are consistent with approved data architecture standards

Provide facilitation, analysis, design, and execution of architecture solutions and ensure solutions are leveraged. Create, document, and communicate the integration approach of all the components of the solution

Define key solutions and ensure they are managed for consumption by users and across teams. Research, analyze, determine capabilities and propose solution alternatives to address specific business needs and product/service strategies

Maintain knowledge of current trends and development in the field. Actively explores emerging technologies

Independently work with business users to gather and scope requirements and recommend analytical solutions to meet business needs

Assists with ETL design and development including data analysis, source-target mapping, quality profiling, change data capture, code performance

Evaluate data quality and interpret results in a clear, concise manner

Document all programming changes and design, system modifications and their associated maintenance

Own analytics projects and be accountable for collaborating with the business to gather requirements, execute to provide analytical solutions, which exceed customer expectations

Work collaboratively with and support multi-departments efforts and projects

Mentor staff by sharing skills, experience, knowledge, and expertise on analytic tools and solutions

Serve as subject matter expert within the department

Provide training and support through the organization on the use of analytics tools. Performs other duties and functions as assigned

Qualification

Data warehousing modelsETL / data pipelineAdvanced SQLData visualization toolsPythonAgile environmentHealthcare experienceStatistical analysisMentoring

Required

Bachelor's degree or four additional years of experience

Five or more years of experience in a role querying, analyzing data, and/or data modeling/architecture

Experience working with a variety of data warehousing models and design fundamentals (e.g., Inmon Kimball)

Experience with developing and maintaining ETL / data pipeline (e.g., Microsoft SSIS, Azure Data Factory)

Experience with OLAP or Tabular cube software

Experience using SQL for data extraction, manipulation, and reporting

Previous experience working in an Agile environment

Strong knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures

Experience with report writing and data visualization tools such as: Microsoft Power BI, Tableau, Crystal Reports, SSRS, etc

1-2 yrs Advanced proficiency in Python, with demonstrated work experience developing data solutions using Python

Preferred

Experience developing, designing and supporting applications and relational databases

Experience using a software package for statistical analysis (R, Python, etc)

Previous experience working with Epic Clarity data

Previous healthcare experience, ideally with a health system

Benefits

Tuition reimbursement

Loan forgiveness

401(k) matching

Lifecycle benefits

Company

Northwestern Medicine

Glassdoor3.7

Northwestern Medicine is the collaboration between Northwestern Memorial HealthCare and Northwestern University Feinberg School of Medicine around a strategic vision to transform the future of health care.

Founded in 1972

Chicago, Illinois, USA

10001+ employees

http://nm.org

H1B Sponsorship

Northwestern Medicine has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (75)

2024 (66)

2023 (70)

2022 (78)

2021 (35)

2020 (39)