Data Engineer Associate

The  Data Engineer Associate reflects the mission vision and values of NM adheres to the organizations 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 Associate 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.
• Applies knowledge of relational database skills including SQL knowledge and ability to create 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.
• 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.
• 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.

Qualifications :

Required:

• 0 3 years of experience in a role querying analyzing data and/or data modeling/architecture.
• 0 3 years of experience with developing and maintaining ETL / data pipeline (e.g. Microsoft SSIS Azure Data Factory).
• Experience using SQL for data extraction manipulation and reporting.
• Knowledge of relational database skills including SQL knowledge and the ability to create queries and stored procedures.
• Experience with report writing and data visualization tools such as: Microsoft Power BI Tableau Crystal Reports SSRS etc.
• 0-1 yrs Advanced proficiency in Python with demonstrated work experience developing data solutions using Python

Preferred:

• Bachelors degree or equivalent experience in relevant field.

Additional Information :

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.

Click on or copy and paste URL to your browser to view detailed benefits information

If sign-on bonus is included in a job posting eligibility is as followed:  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 as a Registered Nurse at NM may be eligible.

Remote Work :

No

Employment Type :

Full-time