Lead ETL Developer (53899)

Stanford Health Care

Redwood City,CA  

2020-01-20 2020-02-19

For over 160 years, Stanford Health Care has been advancing medicine together as fearless leaders and unstoppable patient advocates. Consistently ranked among the nation’s best hospitals, we are a team of pioneers, bringing groundbreaking medical research and patient care to the communities we serve every day.

We’re Stanford Health Care, home to health care professionals making the impossible a reality every day. We’re pushing the boundaries of what medicine can do, and that takes people who can lead fearlessly, challenge the expected, and inspire healing in everything they do. Your courage, your compassion, and your relentless pursuit of excellence are welcome here. We invite you to explore our current opportunities and discover the rewarding next step in your career.

**Lead ETL Developer (53899)**

+ Job Type:Full Time

+ FTE/Bi-Weekly Hours:1.0/80

+ Shift:Days

+ Hours in Shift:8

+ Location:Redwood City, CA

+ Req:53899

**Job Description**

Job Summary:

The Senior ETL Analyst is responsible for designing, developing, testing, tuning, deploying and operating Extract, Transformation, and Load (ETL) processes for a moderate number of projects related to:

Datasets within the Stanford School of Medicine reporting environment, and/or

Data sources within the core data model of the Stanford School of Medicine Data Warehouse (SoM DW),

The MedODS data management environment, supporting Stanford School of Medicine applications.

Essential Functions:

The essential functions listed are typical examples of work performed by positions in this job classification. They are not designed to contain or be interpreted as a comprehensive inventory of all duties, tasks, and responsibilities. Employees may also perform other duties as assigned.

Employees must abide by all Joint Commission Requirements including but not limited to sensitivity to cultural diversity, patient care, patient's rights and ethical treatment, safety and security of physical environments, emergency management, teamwork, respect for others, participation in ongoing education and training, communication and adherence to safety and quality programs, sustaining compliance with National Patient Safety Goals, and licensure and health screenings.

Employee must perform all duties and responsibilities in accordance with the C-I-CARE Standards of the Hospital. C-I-CARE is the foundation of Stanford's patient-experience and represents a framework for patient-centered interactions

Designs/Develops/Tests ETL processes that reflect best practices for error handling, operations logging and alerting, scheduling and job control, etc.

With little oversight, develops, tests, and deploys quality ETL processes with minimal post-production incidents.

Tune performance of complex solutions (both ETL queries and database structures).

Prepares clear and complete complex specifications, designs, test plans, and operations documentation from which ETL processes are developed.

Participates in work group sessions with users and other project stakeholders and actively contributes to the definition of requirements, data analysis to define reporting objectives and/or metric benchmarks, and review of in progress solution development.

Collaborate with source system development teams to conduct ETL modifications in response to large scale or complex source system (i.e., Epic) modifications, upgrades, patches, etc. such that reporting and analytical functionality of supported solutions (Clarity, EDW, etc.) is not impacted.

Participate in and conduct well organized and documented review sessions with CBA team members to validate designs and developed ETL processes.

Works with production support staff to enhance stability and maintainability of solutions that support a "lights out" production schedule with little or no human intervention, and minimize user outages and help desk incidents.

Troubleshoots incidents surrounding supported solutions, including after-hours escalations of major incidents.

Contributes to work effort & timeline estimation of projects and assists project managers in setting and meeting user expectations. Manages individual priorities and tasks to meet such timelines and actively contributes to project status reporting processes to identify and mitigate risks.

Understands and applies HIPAA standards and regulations to all areas of work.

Develops expertise with current ETL technologies, trends, and best practices.

Adheres to SHC standards, methodologies, and processes. Identifies possible improvements and champions revisions with appropriate standards owner. Participates in teams to define design and development standards and processes.

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.

National recognition in 10 specialties.

Watch our stories

"We have a culture of patient care first here, one that speaks to our mission and our values: to care, to educate, and to discover."

Brian L.Unit EducatorBSN, CMS RN

Did you know?

196Stanford Health Care uses 196 solar panels, powering 17% of the hospital's electricity.

17In 2015, we had 17 dogs in our Pet Assisted Wellness (PAWS) Program.

8We're proud to work with 8 All-time Stanford Medicine Nobel Laureates.

1,592Stanford Health Care exhibits more than 1,592 original art pieces.


Education: BS/BA in information or business-related field from an accredited college or university.

Experience: Four (4) years of experience with ETL design and development, with at least 3 years hands-on experience of ETL design and development with SSIS and/or Clarity ETL Console.

Certifications: One or more certifications in a relevant technology or field. Certification, or 2 years of equivalent work experience, in Epic or Microsoft ETL tools is preferred.

Knowledge, Skills, and Abilities

These are the observable and measurable attributes and skills required to perform successfully the essential functions of the job and are generally demonstrated through qualifying experience, education, or licensure/certification.

Experience delivering high quality Reporting & Analytics solutions that meet user requirements with minimal on-going maintenance and a low volume of production incidents (production failures, help desk calls, etc.).

Proficient with, and contributes to, best practices and common processes for developing solutions with, and/or administering, multiple standard SHC tools, including:

SAP BusinessObjects: BusinessObjects Enterprise (BOE), WebIntelligence, Crystal Reports, Xcelcius, BusinessObjects Data Services, CMC, SDK


Microsoft SQL Server: SQL Server, SSIS, Management Studio, Team Foundation Services (TFS)

Epic: Clarity ETL Admin Console (Compass), Clarity Data Model

Oracle: Oracle RDMS10/11, Oracle Client

Remedy/ITSM Service Management (Help Desk/Support) application

Deep experience implementing, ETL principles and best practices, including error handling, logging & alerting, scheduling and job control.

Demonstrated ability to troubleshoot, and perform root cause analysis of, production incidents and establishe countermeasures to improve supported applications.

2+ years of experience with SQL in an Oracle and/or SQL Server (preferred) environment. Proficient with complex SQL (multi joins, subqueries, unions) and creation of database objects (tables, views, materialized views, etc.).

Ability to utilize performance tuning utilities (Explain Plans, etc.) to optimize queries to meet user needs and improve normal operations.

Demonstrated proficiency in Data Definition Language (DDL) , Data Manipulation Language (DML), and Extraction, Transformation and Loading (ETL) design and development using SQL Server tools (SQL Management Studio, T-SQL, SSIS, Team Foundation, etc.), Oracle tools, and/or Epic Clarity Compass.

Complex ETL development with SHC standard tools.

Ability to work without direct supervision based on general direction provided by a superior, provide guidance to peers, and make recommendations to supervisors on best path forward. Provides regular updates to supervisor on pending tasks, pain points, and potential roadblocks.

History of proactive interactions up to Tier 4 management of the organization (Directors and VP's).

Demonstrated ability for completing multiple complex projects.

Actively seeks and embraces coaching and mentoring from team members and contributes to the success and development of the team through effective partnering.

Contributes to realization of SHC's vision. Understands how their work supports the vision and proposes better ways to achieve the vision. Articulates these ideas in a manner that builds consensus and influences decision making at the Director level.

Demonstrates expertise in multiple functional and/or technical domains and develops some cross-functional knowledge and skill outside scope of area of responsibility.

Ability to anticipate functional, design, or technical problems with standard recurring work or projects and negotiates a viable alternative before the issues manifests itself in production operations or development. Considers the "big picture" and develops solutions that address multiple problems or needs.

Ability to independently partner with multidisciplinary teams.

Track record of producing excellent work with limited problems or defects.

Competent utilizing Lean concepts including visibility walls, problem solving A3's, and Gemba rounding principles. Utilizes active daily management techniques.

Makes reliable operational internal decision independently and reliable tactical external decisions with limited supervision.

Successfully presents moderately complex ideas and information to a variety of audiences, including senior managers and industry groups. Effective verbal, written, and interpersonal communication skills.

SHC does not discriminate on the basis of Ancestry, Age, Color, Disability, Genetic information, Gender, gender identity, or gender expression, Marital status, Medical condition, Military or veteran status, National origin, Race, Religion, Sex, and Sexual orientation.
Apply Now View all Stanford Health Care jobs Similar jobs Jobs near Redwood City, CA