Data Engineer

UC San Francisco (UCSF); San Francisco (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

UC San Francisco (UCSF) is seeking a seasoned Data Analyst to collaborate with EIA, governance, and business teams. You will design analytics solutions, develop dashboards, and translate complex data into actionable insights to improve operational performance and leadership decision-making.

You will work on data pipelines and analytics initiatives, utilizing SQL, SSIS, DataStage, Databricks, and Azure Data Factory, and ensure data integrity across healthcare datasets and enterprise systems.

Qualifications

• Ability to collaborate with business and technical stakeholders to understand data, reporting, and analytics needs.
• Design, develop, and deliver analytics solutions that support decision-making.
• Translate data into actionable insights for business operations and performance improvement.

Responsibilities

• Develop and maintain dashboards, reports, and visualizations to monitor key metrics.
• Participate in design and implementation of analytic solutions including data acquisition, processing, and reporting methodologies.
• Support data pipelines, ETL workflows, and data integration using SQL, SSIS, DataStage, GitHub, Databricks, or similar tools.
• Analyze complex datasets to identify trends and communicate findings clearly.
• Ensure data integrity and quality, identify anomalies, and support continuous improvement of data quality processes.
• Provide technical expertise in data storage, extraction, transformation, cleansing, and reporting methodologies.
• Assist in troubleshooting complex technical issues and collaborate with senior staff on escalated problems.
• Support enterprise data standards and metadata/documentation efforts.
• Identify opportunities to improve reporting processes, data quality, and user adoption.

Skills

data governance

dashboard development

data analysis

data modeling

stakeholder collaboration

Tools

SQL

SSIS

DataStage

GitHub

Databricks

Azure Data Factory

Job description

Certain terms and conditions of employment for this position, including the rate of pay, benefits, etc., are currently subject to negotiation with the appropriate union.

Applies skills as a seasoned, experienced data/information management professional with full understanding of industry practices and campus / medical center / OP and department methodologies, policies and procedures to resolve complex and wide-ranging issues where analyses of situations or data require a review of a variety of factors. Demonstrates competency in selecting methods and techniques to obtain solutions.

Specifically, the Data Analyst will work with EIA (Enterprise Information Analytics), data governance staff, business analysts, end users, data owners, and technical teams to:

• Collaborate with business and technical stakeholders to understand data, reporting, and analytics needs.
• Design, develop, and deliver efficient, standards-based analytics solutions that support operational and strategic decision-making.
• Translate data into actionable insights and recommendations to support business operations, performance improvement, and organizational objectives.
• Develop and maintain dashboards, reports, and visualizations that monitor key business metrics and provide meaningful information to leadership and operational teams.
• Participate in the design and implementation of analytic solutions, including data acquisition processes, business rules processing, data aggregation, and reporting methodologies.
• Support the development and maintenance of data pipelines, ETL workflows, and data integration processes using tools such as SQL, SSIS, DataStage, Github, Databricks, Azure Data Factory, or similar technologies.
• Analyze, design, develop, test, document, and support data warehouse and analytics solutions.
• Collaborate with data modelers, architects, and integration teams to support data architecture initiatives and contribute to end-to-end data and information delivery solutions.
• Utilize SQL and related technologies to extract, transform, validate, and optimize data for reporting and analytics purposes.
• Leverage Epic and other enterprise systems to extract, analyze, validate, and interpret healthcare data to support operational improvement and business objectives.
• Perform analysis of complex datasets, identify trends, develop visualizations, and communicate findings in a clear and compelling manner.
• Ensure data integrity and accuracy by identifying data anomalies, troubleshooting issues, and supporting continuous improvement of data quality processes.
• Provide technical expertise in data storage structures, data extraction, data transformation, data cleansing, and reporting methodologies.
• Support and use analytics and business intelligence technologies while assisting in the education of staff and customers regarding data, reporting, and analytics capabilities.
• Assist in troubleshooting complex technical issues and partner with senior staff to resolve escalated problems.
• Participate in data governance activities and support enterprise data standards, definitions, and stewardship practices.
• Collaborate with stakeholders to identify opportunities to improve reporting processes, data quality, reporting performance, and user adoption.
• Support the development and maintenance of metadata, business definitions, technical documentation, and data dictionaries.
• Research emerging analytics, reporting, and data management technologies and support the team in product