A Senior ETL Engineer working closely with data architects, business intelligence developers, and business analysts to create and maintain a variety of ETL data flows and data projects to support UCSF’s Self-Service Analytics initiative. Having significant knowledge and experience with Epic electronic medical record databases Clarity and Caboodle to develop and support ETL and data structures for self-service uses.  Responsible for the architecture, modeling, design, development, testing, implementation and maintenance of the ETL, procedures and structures which populate and grow our self-service databases, data marts and tables. Formulates strategies for accommodating complex data flows to solve problems having little or no precedent in the institution. Selects methods and techniques to obtain desired results while working with colleagues to ensure standards are applied as needed.  Uses healthcare data knowledge to profile data and determine best approaches for satisfying self-service analytic needs.  Is a leader in ensuring self-service analytic structures and processes reduce redundancy, improve access and use, centralize common data elements and improve our agility and speed in provisioning data for analytic uses. The ideal candidate possesses a wide range of development skills, having designed and implemented solutions in a medium to large healthcare setting. The Senior ETL Engineer applies advanced data management concepts and healthcare knowledge to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. Position requires excellent communication skills and ability to articulate system designs and patterns to varying levels of leadership.
JOB REQUIREMENTS

A Senior ETL Engineer working closely with data architects, business intelligence developers, and business analysts to create and maintain a variety of ETL data flows and data projects to support UCSF’s Self-Service Analytics initiative. Having significant knowledge and experience with Epic electronic medical record databases Clarity and Caboodle to develop and support ETL and data structures for self-service uses.  Responsible for the architecture, modeling, design, development, testing, implementation and maintenance of the ETL, procedures and structures which populate and grow our self-service databases, data marts and tables. Formulates strategies for accommodating complex data flows to solve problems having little or no precedent in the institution. Selects methods and techniques to obtain desired results while working with colleagues to ensure standards are applied as needed.  Uses healthcare data knowledge to profile data and determine best approaches for satisfying self-service analytic needs.  Is a leader in ensuring self-service analytic structures and processes reduce redundancy, improve access and use, centralize common data elements and improve our agility and speed in provisioning data for analytic uses. The ideal candidate possesses a wide range of development skills, having designed and implemented solutions in a medium to large healthcare setting. The Senior ETL Engineer applies advanced data management concepts and healthcare knowledge to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. Position requires excellent communication skills and ability to articulate system designs and patterns to varying levels of leadership.

NOTE: This position is 100 % Remote work

Required Qualifications :

Three to four years writing T-SQL.  Experienced in writing stored procedures and complex SQL
Bachelor’s degree in related area and / or equivalent experience / training
Demonstrated effective communication and interpersonal skills. Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization
Self-motivated and works independently and as part of a team. Able to learn effectively and meet deadlines.
Demonstrated complex problem- solving skills
Experience with EPIC electronic medical record databases Clarity and Caboodle
Advanced knowledge of the EPIC data such as clinical and financial data and how to use these data effectively in analytics, dashboards and reporting
Demonstrates the ability to design, code and test ETL routines
Understands the principles of good ETL design
Must possess experience and skills in understanding data models and developing databases and database objects
Experience developing and executing complex test plans
Familiarity with at least one ETL tool such as SSIS or DataStage
Experience with clinical and healthcare administration data
Expertise in creating technical specifications
Ability to create data flow diagrams, and ETL specifications
Flexibility to orient and work at all UCSF Health locations
Preferred Qualifications :

EPIC Clarity / Caboodle certification
Formal Education or Training in ELT development
Formal Education or Training in data modeling
Formal Education or Training in application development
Understanding of fact / dimension dart mart structure
Understanding of big data / cloud warehouses and technologies
Experience in Agile working environment
Knowledge of all InfoSphere modules is a plus. For example, FastTrake, IGC, Information Analyzer etc.
Able to work closely with application DBA to balance load on ETL and DB servers
Proficient utilizing SSIS tasks, T-SQL, and scripting, such as either VB.NET or C#.NET languages to be embedded in SSIS packages
Knowledge of Tableau
Advanced knowledge of secure software development
Highly advanced skills associated with software specification, design, modification, implementation and deployment of large-scale scope
Excellent project leadership and management skills
Ability to design and develop data extraction / integration solutions using Visual Studio.
Must be able to work with multiple RDBMS environments (e.g. Oracle and SQL Server)
Able to resolve and improve performance issues
1 to 2 years of DataStage ETL development experience. Experience with Version 11.5 and above is preferable
Should be able to design and develop data extraction / integration solutions using DataStage
At least 3 to 4 years of Microsoft Integration Services (SSIS) ETL development experience