Sr. Enterprise Data Engineer

Stanford Health Care•Palo Alto, CA

1d•$67 - $88•Hybrid

About The Position

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.

Requirements

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, 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.

Responsibilities

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.