Data Engineer Full-time Days

The Data Engineer 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 highvalue 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 emergingtechnologies.
• Independently work with business users to gather and scope requirements and recommendanalytical solutions to meet business needs.
• Assists with ETL design and development including data analysis sourcetarget mapping qualityprofiling 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 associatedmaintenance.
• Own analytics projects and be accountable for collaborating with the business to gatherrequirements execute to provide analytical solutions which exceed customer expectations.
• Work collaboratively with and support multidepartments efforts and projects.
• Mentor staff by sharing skills experience knowledge and expertise on analytic tools andsolutions.
• Serve as subject matter expert within the department.
• Provide training and support through the organization on the use of analytics tools. Performs otherduties and functions as assigned.

Qualifications :

Required:

• Bachelors degree or four additional years of experience
• Five or more years of experience in a role querying analyzing data and/or datamodeling/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 DataFactory)
• 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 abilityto create complex queries and stored procedures
• Experience with report writing and data visualization tools such as: Microsoft Power BI TableauCrystal Reports SSRS etc.

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

Additional Information :

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.

Remote Work :

No

Employment Type :

Fulltime