Data Engineer, Transplant/DOS

Northwestern Medicine; Chicago (IL); On-site; USD 95,000 - 130,000; Full time

Job summary

Northwestern Medicine is seeking a Data Engineer in Chicago to deliver data warehouse and analytic solutions by ingesting, integrating, and curating data for actionable insights. You will work with architecture to ensure standards and collaborate across teams while mentoring colleagues in analytic tools.

The role demands five+ years in data analysis/architecture, strong SQL, ETL experience (SSIS, Azure Data Factory), and hands-on use of Power BI or Tableau. On-call support is part of the duties.

Qualifications

• Bachelor’s degree or four additional years of experience.
• Five or more years of experience in querying, analyzing data, and/or data modeling/architecture.
• Experience with data warehousing models and design fundamentals (Inmon/Kimball).
• Experience with ETL/data pipelines (SSIS, Azure Data Factory).
• Experience with OLAP or Tabular cube software.
• Experience using SQL for data extraction, manipulation, and reporting.
• Experience with Power BI, Tableau, Crystal Reports, SSRS, etc.
• Previous experience in an Agile environment.
• Strong knowledge of relational databases and advanced SQL with complex queries and stored procedures.

Responsibilities

• Deliver data warehouse and analytic solutions by ingesting, integrating, and curating data.
• Synthesize raw data into actionable information for analytics solutions.
• Collaborate with Architecture team to design and execute solutions.
• Ensure data models and databases align with approved standards.
• Define solutions and ensure they are consumed across teams.
• Mentor staff and share analytics skills and tools.
• Provide training on analytics tools and assist with on-call support.
• Work with business users to gather requirements and deliver analytical solutions.

Skills

SQL

Python

Data warehousing

Agile methodologies

Data analysis

Education

Bachelor’s degree or equivalent

Tools

SSIS

Azure Data Factory

Power BI

Tableau

Crystal Reports/SSRS

Job description

Description

The Data Engineer, reflects the mission, vision, and values of NM, adheres to the organization’s Code of Ethics and Corporate Compliance Program, and complies with all relevant policies, procedures, guidelines and all other regulatory and accreditation standards.

Northwestern Medicine Information Services drives innovative, high-value solutions to transform health care.

We are committed to supporting the relentless pursuit of better medicine by providing exceptional service to our patients and guests as well as internal clients across the organization. To ensure excellence, our team goes to extraordinary lengths to ensure that our systems work together seamlessly.

Northwestern Medicine understands that technology plays an integral role in shaping the future of health care. Information Services strategically supports the organization by:

• Leveraging AI, automation and rollout of advanced cyber controls that support digital transformation strategies
• Implementing advanced technologies in clinical and administrative areas
• Furthering development of the end user support model to help enhance modern infrastructure

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.
• This position requires participation in an on-call support to ensure the availability and performance of our systems.

Qualifications

Minimum Requirements

Education

• Bachelor’s degree or four additional years of experience

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., Inmom 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
• Experience with report writing and data visualization tools such as: Microsoft Power BI, Tableau, Crystal Reports, SSRS, etc.
• 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
• 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

Equal Opportunity

Northwestern Medicine is an equal opportunity employer (disability, VETS) 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.

Background Check

Northwestern Medicine conducts a background check that includes criminal history on newly hired team members and, at times, internal transfers. If you are offered a position with us, you will be required to complete an authorization and disclosure form that gives Northwestern Medicine permission to run the background check. Results are evaluated on a case-by-case basis, and we follow all local, state, and federal laws, including the Illinois Health Care Worker Background Check Act.

Artificial Intelligence Disclosure

Artificial Intelligence (AI) tools may be used in some portions of the candidate review process for this position, however, all employment decisions will be made by a person.

Benefits

We offer a wide range of benefits that provide employees with tools and resources to improve their physical, emotional, and financial well-being while providing protection for unexpected life events. Please visit our Benefits section to learn more.

Sign-on Bonus Eligibility (if sign-on bonus offered for position)

Internal employees and rehires who left Northwestern Medicine within 1 year are not eligible for the sign on bonus. Exception: New graduate internal employees seeking their first licensed clinical position at NM may be eligible depending upon the job family.