Sr. Enterprise Data Engineer

Stanford Health Care; California (MO); On-site; USD 140,000 - 210,000; Full time

Job summary

Stanford Health Care is seeking a Senior Enterprise Data Engineer to design and create complex data pipelines and curated data structures for use across the organization. You will drive data ingestion to the SHC Enterprise Data Platform and enable data products that improve patient outcomes and operations.

You will collaborate with analysts, clinicians and leadership, maintain standards for data modeling and DevOps, and explore new technologies to deliver scalable, automated solutions.

Qualifications

• BS/BA DEGREE IN INFORMATION TECHNOLOGY, INFORMATION SYSTEMS, BUSINESS MANAGEMENT, BUSINESS ANALYTICS, BUSINESS ADMINISTRATION OR A DIRECTLY RELATED FIELD FROM AN ACCREDITED COLLEGE OR UNIVERSITY REQUIRED.
• 7 (SEVEN) OR MORE YEARS' OF EXPERIENCE IN REPORTING, ANALYTICS, BUSINESS INTELLIGENCE OR HEALTHCARE TECHNOLOGY.
• OR 3 (THREE) OR MORE YEARS' DEVELOPMENT EXPERIENCE IN CLOUD DATALAKE TECHNOLOGIES (I.E., PYSPARK NOTEBOOKS/PIPELINES ON DATABRICKS) UTILIZING DEVOPS, CI/CD, ORCHESTRATION PROCESSES REQUIRED.
• Advanced knowledge of relational database concepts and design.
• Advanced data modeling skills, translate business requirements into designs.
• Develop solutions in cloud data platforms (Azure, DataBricks) with PySpark/Notebooks, GitHub.
• Expert SQL; relate data across multiple data domains.
• DevOps concepts/practices; CI/CD; performance tuning.
• Able to work without direct supervision; provide regular updates.
• Proven ability to complete complex projects.

Responsibilities

• Collaborates with leaders and users to create, test and implement complex stores, data pipelines and more.
• Researches, road maps and maintains performance of SHC's data modeling, DevOps and development tools.
• Explores new technologies to create solutions and improve efficiency.
• Performs analysis, development and testing of complex data marts and supports other data engineers.
• Builds strong relationships with users and team members including Directors and above.
• Participates in project work groups with analysts, clinicians and SHC leadership.
• Leads teams to define design and development standards and peer reviews.
• Defines analytics standards and supports training/adoption.
• Tune performance of complex solutions; troubleshoot and perform root cause analysis.

Skills

SQL

Data modeling

Cloud data platforms

PySpark / Databricks

DevOps / CI/CD

Notebooks

GitHub

Data governance

ETL / data pipelines

Stakeholder collaboration

Education

BS/BA degree in information technology, information systems, business analytics, business management or related field

Tools

Azure

Databricks

PySpark

Notebooks

GitHub

Job description

If you're ready to be part of our legacy of hope and innovation, we encourage you to take the first step and explore our current job openings. Your best is waiting to be discovered.

Day - 08 Hour (United States of America)

This is a Stanford Health Care job.

This role will develop data ingestion processes to the SHC Enterprise Data Platform (Lake), create data pipelines and other solutions, and automate development and operational processes to enable Data Products and solutions that improve the patient experience, patient outcomes, research capabilities, and operational results.

A Brief Overview

The Senior Enterprise Data Engineer is responsible for designing and creating complex pipelines and curated data structures/products for use by data analysts across the organization. This position is also responsible consultation and support of other data engineers in the design, development and implementation of data movement processes to populate the data structures designed.

This position exists to provide data solutions for broad and consistent use across the SHC enterprise.

Locations

Stanford Health Care

What you will do

• With advanced technical knowledge and skills, collaborates with leaders and users to create, test and implement complex stores , data pipelines, etc. based on understanding of business needs and requirements.
• Responsible for the research, road mapping and maintaining performance of SHC's standard data modeling, DevOps and development tools and processes.
• Explore and innovate with new technologies to create solutions, enhance development and/or operational efficiency, etc.
• Without supervision, performs analysis, development, and testing of complex data marts, and support other data engineers in performing these tasks, and encourages use of the solutions for data-driven decision making.
• Possesses an advanced understanding of many data domains across SHC and uses it to produce high quality solutions.
• Build strong working relationships with users and team members, including Directors and above. Gains trust and respect of key users.
• Understands advanced data governance principles and practices and actively participates as a technical data steward in metadata, data quality, and other data governance areas and activities. Assists in identification and resolution of data quality issues.
• Manage multiple complex activities. Manage tasks, dependencies, and user/team expectations regarding scope and timeline of solution delivery.
• Provides project management / project leadership as appropriate to drive timelines and deliverables of projects across multiple departments/functions
• Participates in and contributes to project working groups with team members, users, analysts, clinicians, and SHC leadership.
• Leads teams to define design and development standards and conduct peer reviews of solution designs for compliance with such standards.
• Defines analytics standards and best practices and support business data analysts in training and adoption of these standards.
• Participates in and actively contributes to SHC analytics community meetings
• Tune performance of complex solutions.
• Troubleshoots and performs root cause analysis of incidents and establishes countermeasures to improve supported solutions.
• Work is of

Education Qualifications

• BS/BA DEGREE IN INFORMATION TECHNOLOGY, INFORMATION SYSTEMS, BUSINESS MANAGEMENT, BUSINESS ANALYTICS, BUSINESS ADMINISTRATION OR A DIRECTLY RELATED FIELD FROM AN ACCREDITED COLLEGE OR UNIVERSITY REQUIRED.

Experience Qualifications

• 7 (SEVEN) OR MORE YEARS' OF EXPERIENCE IN REPORTING, ANALYTICS, BUSINESS INTELLIGENCE OR HEALTHCARE TECHNOLOGY.OR 3 (THREE) OR MORE YEARS' DEVELOPMENT EXPERIENCE IN CLOUD DATALAKE TECHNOLOGIES (I.E., PYSPARK NOTEBOOKS/PIPELINES ON DATABRICKS) UTILIZING DEVOPS, CI/CD, ORCHESTRATION PROCESSES REQUIRED.

Required Knowledge, Skills and Abilities

• Advanced knowledge of relational database concepts and design
• Advanced data modeling skills, ability to translate business requirements into logical and physical database designs for moderate to large complex projects.
• Ability to develop solutions in cloud data platforms (i.e., Azure, DataBricks, etc.) and technologies (i.e., PySpark, Notebooks, GitHub, etc.) to deploy production solutions in a secure and highly automated manner.
• Expert knowledge of SQL. Proficient with ability to relate and use data across multiple data domains.
• Expert knowledge and skills in SHC's standard development and design tools and general DevOps concepts/practices.
• Tune performance of moderately complex solutions.
• Troubleshoots and performs root cause analysis of incidents and establishes countermeasures to improve supported solutions.
• Able to work without direct supervision. Provides regular updates to supervisor on pending tasks, pain points, and potential roadblocks.
• Demonstrated ability for completing complex projects.