Data Engineer @ University of California San Francisco - San Francisco, CA

Job Overview

2 days ago

Data Engineer

University of California San Francisco - San Francisco, CA

UCSF Health is a world leader in health care, known for innovative medicine, advanced technology and
compassionate care. For more than a century, it has offered the highest quality medical treatment. UCSF
Medical Center is consistently ranked among the top 10 best hospitals in the nation by U.S. News & World
Report, including top rankings in 11 specialties.

This position is responsible for the design, specifications, coding, testing, implementation, maintenance, documentation, debugging, and troubleshooting of data warehouse solutions. Its work includes analyzing source system data, designing dimensional data models, developing ETLs, and creating data visualization products such as reports and dashboards. The position plays a critical role in requirement gathering, project plan planning, technical architecture design, data security, go-live implementation, and ongoing system support. The role also includes participation in the management of and / or development of standard data practices and guidelines, dictionaries, registries and / or services to be shared and used by other UCSF data resources. In addition to these duties, the position is required to perform any other tasks assigned to support the department’s function.

As a preeminent health sciences campus, UCSF is dedicated to creating new knowledge from the exploding volume of clinical, discovery, and education data that it creates and manages. UCSF believes that the ability to leverage these data assets will be an important differentiator among academic health care centers in the near future and is critical to our drive towards Precision Medicine and to advance our strategy of Innovation at Scale.

A data engineer is responsible for designing, developing, testing, documenting, and maintaining data warehouse and analytics architecture to meet UCSF’s data and analytics needs.
  • Collaborate with business and technology partners to gather business requirements and create architectural designs.
  • Use business domain knowledge to profile data and determine the best approaches to extract data into data warehouses.
  • Apply the Kimball dimensional data modeling technique to build and enhance the enterprise data warehouse.
  • Design, develop, test, document, and support new and existing ETL processes using Microsoft SQL Server Integration Services (SSIS), Microsoft Azure Data Factory, IBM Infosphere DataStage, or other tools.
  • Demonstrate proficiency in SQL programming and performance tuning.
  • Participates to create optimal and scalable technology standards to be used within department and throughout UCSF data community
  • Serves as leaders in data community to provide consultation of technical standards / guidelines
  • Develop business intelligence products, such as reports and dashboards, using Tableau or other data visualization tools.
  • Document business rules and metadata in the data dictionary and keep the information updated.
  • Possess excellent communication skills and the ability to articulate system designs and patterns to varying levels of leadership.
  • Participate in project planning, including scoping backlogs and determining estimates.
  • Assume on-call duties to support the operation of reporting and analytics systems.
  • Maintain appropriate business domain knowledge in healthcare, education, research, finance, or business administration.

Involves technical acumen for planning, designing, developing, implementing and administering data-based systems that acquire, prepare, store and provide access to data and metadata. Maintains and optimizes systems and migrates data and systems as needed. Ensures integrity and completeness of data and workflow, manages and / or develops data practices, databases and information systems as well as guidelines, dictionaries, registries and / or services. May include interpretation of scientific research data artifacts as well as mediation across science and technology domains and long-term data care. As information architect and data steward, designs systems, data products and / or data production processes while focusing on data curation, data exchange, data security, data integrity and information environments. (Re)evaluates frameworks, strategies, standards and standards-making activities. May involve work with a project-level data repository, a center or an archive.

Department Description

The mission of the Enterprise Information and Analytics (EIA) department is to advance UCSF’s institutional priorities by enhancing access to and the use of data and analytics, including appropriate data platforms and data governance, in a manner that meets the unique needs across the education, research, and care mission areas. The department archives its goals by working with clinical, research, education, and business partners to organize, integrate, govern, and transform UCSF’s data assets into actionable insight and information.

Required Qualifications

  • Bachelor's degree in related area and / or equivalent experience / training.
  • At least 3 years writing T-SQL. Experienced in writing complex SQL queries and stored procedures. Understanding of query performance tuning.
  • Minimum of 3 years using at least one ETL tool such as Microsoft SQL Server Integration Services (SSIS), or Microsoft Azure Data Factory, or IBM Infosphere DataStage. Capable of designing and developing data extraction, integration, and transformation solutions. Demonstrate the ability to create, code, and test ETL routines. Possess an understanding of the principles of effective ETL design.
  • At least 3 years designing and creating reports, scorecards, and dashboards using Tableau, Power BI, or any data visualization tools.
  • Expertise in documenting business and functional requirements, and data flows. Able to document business rules and metadata.
  • Experience developing and executing complex test plans.
  • Must be able to work with multiple RDBMS environments such e.g. Oracle, SQL Server, MySQL, and so on.
  • Demonstrate effective communication and interpersonal skills. Demonstrate 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.
  • Demonstrate complex problem-solving skills.
  • Possess experience and skills in developing logical and physical dimensional data models with demonstrated understanding of fact and dimension design principles. Experienced in creating database objects and applying security.

Preferred Qualifications

  • Experience with clinical and healthcare administration data
  • Experience with healthcare, education, research, financial, or business administrative data.
  • Experience with the Epic electronic health record databases including Clarity and Caboodle.
  • Understanding of advanced statistical methods and data science principles.
  • Experience cloud computing and technologies.
  • Experience in Agile working environment is desired.
  • Experience in one programming language such as Python, R, Java, C++, C+, etc.
  • 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.
  • Able to resolve and improve performance issues. Experience in working with other technical and business teams to carry out system performance tuning.
  • Knowledge of the Epic data and workflows and know how to use these data effectively in data modeling, reporting, and analytics.
  • Experience with the data and business processes in ERP, CRM, business administration, tertiary education, research proposals/grants is a plus.
  • Formal Education or Training in ETL development
  • Formal Education or Training in data modeling (esp. Kimball Methodology)
  • Advanced degree preferred
  • Epic Clarity or Caboodle certification

About UCSF

At UCSF Health, our mission of innovative patient care, advanced technology and pioneering research is redefining what’s possible for the patients we serve – a promise we share with the professionals who make up our team.

Consistently ranked among the top 10 hospitals nationwide by U.S. News & World Report – UCSF Health is committed to providing the most rewarding work experience while delivering the best care available anywhere. In an environment that allows for continuous learning and opportunities for professional growth, UCSF Health offers the ideal atmosphere in which to best use your skills and talents.

Pride Values

UCSF is a diverse community made of people with many skills and talents. We seek candidates whose work experience or community service has prepared them to contribute to our commitment to professionalism, respect, integrity, diversity and excellence – also known as our PRIDE values.

In addition to our PRIDE values, UCSF is committed to equity – both in how we deliver care as well as our workforce. We are committed to building a broadly diverse community, nurturing a culture that is welcoming and supportive, and engaging diverse ideas for the provision of culturally competent education, discovery, and patient care. Additional information about UCSF is available at diversity.ucsf.edu

Join us to find a rewarding career contributing to improving healthcare worldwide.

Equal Employment Opportunity

The University of California San Francisco is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veteran or disabled status, or genetic information.

Organization

Health

Job Code and Payroll Title

000599 DATA SYS ANL 4

Job Category

Clinical Systems / IT Professionals

Bargaining Unit

99 - Policy-Covered (No Bargaining Unit)

Employee Class

Career

Percentage

100%

Location

Parnassus Heights (SF)

Shift

Days

Shift Length

8 Hours

Additional Shift Details

Monday - Friday

Similar Jobs

Senior Data Integration Engineer, AVP - Remote - California

MUFG

Sacramento, CA

Familiarity with data architecture, data integration, data governance, and data lineage concepts. Manage data analysis and data integration of disparate systems…

Staff Data Engineer- Data as a Service

Visa

Palo Alto, CA

Understand and own component security analysis, including code and data flow review. You will see the code written and moved to production within just a few…

Data Center Engineer - Level - Professional Services (Client Onsite)

Astreya

Sunnyvale, CA

A key element in this role will be communicating with multiple departments and leaders to provide technical support for a team of network engineers.

Staff Data Engineer - Platform as a Service

Visa

Palo Alto, CA

Expertise in design and management of complex data structures and data processes. Technical background in data with deep understanding of issues in multiple…

Google Cloud Senior Data Engineer

Deloitte

San Jose, CA

5+ years of experience with data cleansing tools, methods and practices. 5+ years of experience building data pipelines in traditional information systems…

Sr Staff Software Engineer (Big Data - Prisma Access)

Palo Alto Networks

Santa Clara, CA

Strong understanding of message queuing, stream processing, and highly scalable ‘big data’ data stores. We want passionate engineers who love to code and build…

Reliability Engineer - Enterprise Data Center (Colocation - North San Jose)

Astreya

San Jose, CA

A key element in this role will be communicating with multiple departments and leaders to provide technical support for a team of network engineers.

Software Engineer, Data, Global Engineering

Bain & Company

San Francisco, CA

You will learn and apply data engineering solutions to cutting-edge problems for variety of industries as a data engineer. Travel is required (~20%).

Software Engineer, Data, Global Engineering

Bain & Company

Palo Alto, CA

You will learn and apply data engineering solutions to cutting-edge problems for variety of industries as a data engineer. Travel is required (~20%).

Data Engineer

National University

San Francisco, CA

Responsible for maintaining metadata management and data quality activities so that data are accurate, reliable and documented.

Data Engineer

BitTorrent

San Francisco, CA

Iterate alongside other engineers and business leaders to continue to deliver on the promise of being a data-driven company.

Data Center Engineer

Leaseweb

San Jose, CA

Installation, relocation, and removal of server equipment at the data center. At least one year of hands-on experience working in a data center with servers.

Senior Software Engineer, Data Infrastructure

Pocket Gems

San Francisco, CA

After doing extensive benchmarking on several data warehousing solutions, we redid all our pipelines and migrated petabytes+ of data from Amazon Redshift to…

Principal Software Engineer, Data Platform

Okta

San Francisco, CA

Experience with reliability engineering specifically in areas such as data quality, data observability and incident management.

Data Engineer, Digital Marketing

ServiceNow

Santa Clara, CA

Experience with data processing flowcharting techniques. Experience in enterprise-level data integrations. Maintain high standards of data quality through the…

Data Engineer, Workplace Health and Safety

Amazon.com Services LLC

San Francisco, CA

Experience implementing data management, data privacy and data storage principles. Experience providing technical leadership and mentoring other engineers for…

Data Engineer

Brightseed

South San Francisco, CA

Develop and integrate data pipelines to streamline and automate scientific data collection, data quality control, data analysis and visualization for discovery…

Data Engineer

Sublime Wireless Inc

Mountain View, CA

Looking for those with a *strong/solid understanding of SW engineering, data engineering/data pipelining*. More so understanding of *SW engineering*, language…

Senior Data Engineer

Swish Analytics

San Francisco, CA

Experience developing automated data pipelines at production scale. Strong passion for sports and sports data. Worked in production coding environment 5+ years.

Data Engineer, Regulatory & Corporate Technology

First Republic Bank

New York, NY

Master's in data science or Analytics preferred. Help with cloud migration of data assets into AWS, Snowflake.

Lead Data Engineer

NexWave Talent Management Solutions Pvt Ltd.

Mountain View, CA

Around 7-10 years of experience. Experience in Cloud and Database technologies. Work closely with client team on managing technical day to day operations and…

Data Engineer

University of California San Francisco

San Francisco, CA

As information architect and data steward, designs systems, data products and / or data production processes while focusing on data curation, data exchange,…

Staff Data Engineer (Sr Data Analyst)

Visa

Foster City, CA

This position requires performing complex data analysis across multiple data sets to derive insights, metrics, evaluating completeness of data.

Senior Software Engineer - Big Data Technologies

Visa

Foster City, CA

Will delegate and review others engineers work on small projects. Strong foundation in computer science, with strong competencies in data structures, algorithms…