Data Engineer

UCSF Health is an academic healthcare organization seeking a Data Engineer to support enterprise information and analytics initiatives across healthcare operations. The role designs, develops, and maintains data integration, data warehouse, business intelligence, reporting, visualization, governance, and analytics solutions while collaborating with business and technical stakeholders.

Responsibilities

• 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 evaluations, pilots, and proof-of-concept activities
• Participate in dissemination of best practices, standards, and process improvements across the analytics community
• Contribute to project planning activities including requirements gathering, effort estimation, testing, implementation, and post-production support
• Partner with business stakeholders, business analysts, project managers, and technical teams to understand business requirements and translate them into scalable data and analytics solutions
• Analyze source systems and data structures to identify effective approaches for data acquisition, transformation, integration, and delivery
• Design, develop, test, document, and maintain ETL workflows and data integration processes using SQL, DataStage, SSIS, Azure Data Factory, GitHub, and related technologies
• Develop and maintain logical and dimensional data models, data marts, schemas, and supporting database structures to enable reporting and analytics solutions
• Design and implement data transformation processes, data mappings, business rules, and data validation processes
• Develop, optimize, and troubleshoot complex SQL queries and stored procedures supporting operational and analytic workloads
• Collaborate with data architects, engineers, and integration teams to support enterprise data architecture and information delivery initiatives
• Monitor and improve data quality, integrity, completeness, and consistency across multiple source systems
• Perform root cause analysis and resolution of complex data integration and processing issues
• Develop technical specifications, ETL documentation, data lineage documentation, and metadata required to support enterprise analytics solutions
• Participate in data governance activities including maintenance of business definitions, metadata, and enterprise data standards
• Support analytics initiatives through data engineering, data modeling, data integration, and technical solution development activities
• Applies professional and broadly defined business analysis and data / information administration and data use concepts to manage and perform complex assignments
• Participate in the development of innovative uses of BI technologies in support of UCSF business objectives
• Facilitate and educate business and IT staff on the use of BI technologies for strategic and tactical decision-making
• Independently researches and evaluates new and emerging BI, analytic and data processing technologies that can help solve pressing UCSF business problems
• Collaborate with others or independently conducts data analysis methods and techniques, pioneering the use of data to drive decision-making and strategic initiatives
• Development, use, maintenance, and optimization of a repeatable enterprise analytics methodology and supporting set of tools and templates for performing data strategy, integration, and analytic projects
• Participate and facilitate maintenance of the semantic layer, metadata, reports, and report definitions
• Supports change agents and catalysts in enterprise data management and governance
• Contribute to development and maintenance of enterprise self-service analytics library and tools
• Serve as core member of cross-functional teams, projects, and initiatives related to data analysis and strategy
• Ensure all tools abide and adhere to UCSF enterprise security and privacy standards
• Support AI Scribe and Open Encounter Program
• Design, develop, test, and maintain dashboards, reports, scorecards, and visualizations using Tableau, Power BI, and other approved business intelligence tools
• Translate business requirements into actionable reporting and visualization solutions that support operational and strategic decision-making
• Perform analysis of complex healthcare and operational datasets to identify trends, opportunities, and performance improvement initiatives
• Conduct quality assurance testing and validation of reports, dashboards, ETL processes, and data assets to ensure accuracy and reliability
• Develop and maintain reporting documentation, report definitions, business rules, and user-facing documentation
• Support Epic reporting and analytics activities through extraction, validation, interpretation, and presentation of healthcare data
• Collaborate with customers and stakeholders to identify opportunities for reporting improvements, enhanced usability, and increased adoption of analytics products
• Troubleshoot reporting, dashboard, and visualization issues and implement corrective actions as appropriate
• Develop prototypes and proof-of-concept reporting solutions to evaluate business requirements and user needs
• As a technical leader and information resource, may provide support, troubleshooting, and problem solving at a proficient level, and may produce and deliver user training curricula

Preferred

• Master's degree in related area and / or equivalent experience / training
• Epic Clarity Certification
• Ability to produce high-quality reports and documentation
• Experience with analytics and data processing technologies such as Python, R, Databricks, or similar tools
• 1 year of experience in BI and analytics in healthcare
• Experience in the analysis, design, development, and implementation of ETL workflows using tools such as SQL, DataStage, Github, Databricks, SSIS, etc
• Good project leadership and management skills
• Experience in Agile/Scrum development methodology
• Experience creating and maintaining data visualizations standards
• Familiarity with data model patterns in one or more common business or academic domains
• Familiarity with logical data design and data mapping or data conversion
• Familiarity with data quality and governance issues and requirements
• Thorough knowledge of relevant rules, regulations and industry standards and best practices
• Related Master's Degree
• Report Writing
• Data Processing
• Python
• R
• Databricks
• Healthcare BI
• ETL Workflow Development
• DataStage
• GitHub
• SSIS
• Agile
• Scrum
• Data Visualization Standards
• Data Modeling
• Logical Data Design
• Data Mapping
• Data Conversion
• Data Quality
• Data Governance
• Industry Regulations
• Industry Standards
• Industry Best Practices
• Project Leadership
• Project Management

Benefits

• Flexible 1 Day On-Site

Company

• Integrated hospital and health care network
• San Francisco, California, USA
• https://www.ucsfhealth.org/
• Founded in 1990
• 5001-10000 employees

Qualifications

• Bachelor's degree in related area and/or equivalent experience/training
• 3+ years of experience designing, developing, testing, and implementing secure, scalable, and high-performance BI and analytic solutions; at least 3-5 years of experience as a Tableau / Power BI Developer or other BI tool
• 1-3 years of experience in skills associated with software specification, design, modification, implementation and deployment of medium-scale scope
• 2 years of experience with dimensional data modeling and relational databases
• 2 years of experience in SQL
• Self-motivated, detail-oriented professional with the ability to work independently and collaboratively, manage competing priorities, and meet deadlines
• Strong critical thinking and problem-solving skills to manage complex information, assess problems, and develop and effective solutions
• Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems
• Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail
• Ability to communicate effectively, both verbally and in writing, with technical and non-technical audiences at all levels of the organization
• Demonstrated interpersonal, collaboration, and customer service skills with the ability to work effectively with diverse team members and stakeholders
• Strong interpersonal, collaboration, and relationship-building skills with the ability to work effectively across business and technical teams
• Proficient in developing technical specifications, presentations, training materials, user documentation, and technical documentation
• Demonstrated success with software development lifecycle for enterprise-wide BI projects and ability to assess and solve technical problems
• Demonstrated ability to understand domain needs and how systems can support those needs. Demonstrated ability to participate in conversion and system implementation plans
• Detail oriented, with ability to manage time and organize competing priorities
• Master's degree in related area and / or equivalent experience / training
• Epic Clarity Certification
• Ability to produce high-quality reports and documentation
• Experience with analytics and data processing technologies such as Python, R, Databricks, or similar tools
• 1 year of experience in BI and analytics in healthcare
• Experience in the analysis, design, development, and implementation of ETL workflows using tools such as SQL, DataStage, Github, Databricks, SSIS, etc
• Good project leadership and management skills
• Experience in Agile/Scrum development methodology
• Experience creating and maintaining data visualizations standards
• Familiarity with data model patterns in one or more common business or academic domains
• Familiarity with logical data design and data mapping or data conversion
• Familiarity with data quality and governance issues and requirements
• Thorough knowledge of relevant rules, regulations and industry standards and best practices
• 1-3 years of experience in skills associated with software specification, design, modification, implementation and deployment of medium-scale scope.

Required skills

• SQL, Tableau, Power BI, Dimensional Data Modeling, Relational Databases, ETL Workflows, DataStage, SSIS, Azure Data Factory, Databricks, Epic Clarity Certification, Healthcare Analytics

Preferred skills

• Ability to produce high-quality reports and documentation, 1 year of experience in BI and analytics in healthcare, Good project leadership and management skills, Experience in Agile/Scrum development methodology

Experience

• 3+ years