Data Engineer

Northwestern Medicine is a leader in the healthcare industry committed to providing exceptional service to patients and internal clients. The Data Engineer role involves delivering data warehouse and analytic solutions to support the health system's information needs.

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

Requirements:

• Bachelor's degree or four additional years of 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
• 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
• Experience with report writing and data visualization tools such as: Microsoft Power BI, Tableau, Crystal Reports, SSRS, etc
• 1-2 yrs Advanced proficiency in Python, with demonstrated work experience developing data solutions using Python
• 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