Senior Data Engineer

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.

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.

Responsibilities

• Deliver data warehouse and analytic solutions by ingesting, integrating, and curating data, building analytical solutions, and administering systems to deliver information to the health system.
• Serve as a functional and content expert of the data warehouse to synthesize raw data into actionable information to be used in analytical solutions.
• Apply knowledge of relational database skills including advanced SQL knowledge and the ability to create complex queries and stored procedures.
• Collaborate with the Architecture team in the design and execution of solutions.
• Ensure 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.
• 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.
• Coach and mentor new and existing data engineers, helping them navigate technical and organizational challenges.
• Create comprehensive system manuals, documentation, and onboarding materials to support knowledge transfer and accelerate team learning.
• Provide guidance on best practices, troubleshoot complex issues, and foster a collaborative environment that encourages continuous professional development.
• Serve as a go-to resource for technical questions, ensuring that team members are equipped to deliver high-quality solutions and grow in their roles.

Qualifications

• 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 including 2 years on cloud platforms (e.g., Microsoft SSIS, Azure Data Factory, Databricks, AWS).
• Demonstrate strong technical knowledge of application delivery methods and familiarity with how portfolios of systems work together to create enterprise solutions.
• Demonstrate results managing/ influencing/ member of virtual teams and serving as role model/ mentor.
• 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.
• Able to work effectively in a team environment.
• 2-4 yrs Advanced proficiency in Python, with demonstrated work experience developing data solutions using Python.
• Familiarity with cloud security principles and best practices for data protection in cloud environments.