Senior Data Engineer, Enterprise Data, Full-time, Days

Company Description

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?

Job Description

The Senior 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.

The Senior Data Engineer uncovers insights that drive strategy and optimal decision making for the executive team and leaders across the organization.  In this role, you will be charged with understanding the ‘who, what, and whys’ of our business – working cross-functionally to realize the value of NM’s data assets.

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 Senior 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 projects and be accountable for collaborating with the business to gather requirements, execute to provide 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. 

Qualifications

Required:

• Bachelor’s degree or equivalent experience in relevant field.  
• 7+ years of experience in a role querying, analyzing data, and/or data modeling/architecture.
• 4+ years in enterprise, application, technical, or information architecture design. 
• 4+ years with developing and maintaining ETL / data pipeline (e.g., Microsoft SSIS, Azure Data Factory, Databricks). 
• Demonstrate strong technical knowledge of application delivery methods and familiarity with how portfolios of systems work together to create enterprise solutions. 
• Demonstrated results managing/ influencing/ member of virtual teams and serving as role model/ mentor. 
• Must have demonstrated knowledge on a domain specific area (i.e., coding languages such as C, C++, JAVA, .NET, C# etc.; networking; Applications such as Cerner, Epic, Peoplesoft, Kronos; Technology such as Microsoft, AIX, VMWare, SAN, Exchange; data).
• Experience working in a matrixed organization. 
• The Sr. Data Engineer needs to have expertise in design methodologies and business functions. 
• Need to have working knowledge of Unified Modeling Language (UML) or other architecture modeling notations.
• Ability to work effectively in a team environment.

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.

If we offer you a job, we will perform a background check that includes a review of any criminal convictions. A conviction does not disqualify you from employment at Northwestern Medicine. We consider this on a case-by-case basis and follow all state and federal guidelines.