Sr. Enterprise Data Engineer

Stanford Health Care; California (MO); Hybrid; USD 190,607,000 - 252,557,000; Full time

Job summary

Stanford Health Care in California is seeking a Senior Enterprise Data Engineer to design and build complex data pipelines for the SHC Enterprise Data Platform. You will enable data products that improve patient outcomes and research capabilities while collaborating with data analysts and engineers.

The role emphasizes DevOps, data governance, and scalable solutions across the SHC environment, with hybrid work and opportunities to lead cross-functional initiatives.

Qualifications

• BS/BA degree in IT, information systems, business analytics or related field required.
• 7+ years in reporting, analytics, BI or healthcare tech; or 3+ years with cloud data lake tech and DevOps.
• Advanced SQL and data modeling skills; experience translating business needs into data designs.
• Experience deploying production solutions in cloud platforms with automation.

Responsibilities

• Design and build complex data pipelines and data marts for analysts.
• Maintain performance of data modeling tools and DevOps processes.
• Explore new technologies to improve development and operations efficiency.
• Lead and participate in cross-functional project teams across SHC.

Skills

SQL

Data modeling

Cloud platforms

PySpark

Notebooks

DevOps

Communication

Independent work

Education

BS/BA in IT or related field

Tools

Databricks

GitHub

Azure

Job description

1.0 FTE Full time Day - 08 Hour R2654873 Hybrid 108480015 TDS Enterprise Information Management Technology & Digital Solutions PALO ALTO, 1830 Embarcadero, California>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 OverviewThe 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.
LocationsStanford 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.

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.
• Work is of good quality with only rare problems or defects with moderate to complex solutions.
• Can successfully present moderately complex ideas and information to a variety of audiences, including senior managers and industry groups. Effective verbal, written, and interpersonal communication skills.
• Helps fulfill SHC's vision. Understands how their work supports the vision and proposes better ways to achieve the vision.

These Principles Apply To ALL EmployeesSHC Commitment to Providing an Exceptional Patient & Family ExperienceStanford Health Care sets a high standard for delivering value and an exceptional experience for our patients and families. Candidates for employment and existing employees must adopt and execute C-I-CARE standards for all of patients, families and towards each other. C-I-CARE is the foundation of Stanford’s patient-experience and represents a framework for patient-centered interactions. Simply put, we do what it takes to enable and empower patients and families to focus on health, healing and recovery.
You will do this by executing against our three experience pillars, from the patient and family’s perspective:
Know Me: Anticipate my needs and status to deliver effective care
Show Me the Way: Guide and prompt my actions to arrive at better outcomes and better health
Coordinate for Me: Own the complexity of my care through coordination

Equal Opportunity Employer Stanford Health Care (SHC) strongly values diversity and is committed to equal opportunity and non-discrimination in all of its policies and practices, including the area of employment. Accordingly, SHC does not discriminate against any person on the basis of race, color, sex, sexual orientation or gender identity and/or expression, religion, age, national or ethnic origin, political beliefs, marital status, medical condition, genetic information, veteran status, or disability, or the perception of any of the above. People of all genders, members of all racial and ethnic groups, people with disabilities, and veterans are encouraged to apply. Qualified applicants with criminal convictions will be considered after an individualized assessment of the conviction and the job requirements.The base Pay Scale: Generally starting at $66.52 - $88.14 per hour
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to, internal equity, experience, education, specialty and training. This pay scale is not a promise of a particular wage.