Sr Enterprise Cogito Data Platform Admin

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 role is primarily focused on Epic Clarity and Caboodle administration and will participate in the planning and transition to Cogito Cloud. As such, experience with Azure cloud technologies and best practices is preferred.

This is a Stanford Health Care job.

A Brief Overview
The Senior Analyst I, ETL Developer, Clinical and Business Analytics is responsible for designing, developing, testing, tuning, and deploying Extract, Transformation, and Load (ETL) processes for a moderate number of projects related to:
• Datasets within the Epic Clarity reporting environment, and/or
• Data sources within the core data model of the Enterprise Data Warehouse (EDW).
• Subject area data marts within a defined Clinical Program or Clinical Support Service.

Locations
Stanford Health Care

What you will do

• 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 …