Job Description
Join to apply for the Data Warehouse Architect role at UCSF Health
Continue with Google Continue with Google
3 days ago Be among the first 25 applicants
Join to apply for the Data Warehouse Architect role at UCSF Health
Get AI-powered advice on this job and more exclusive features.
Sign in to access AI-powered advices
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Continue with Google Continue with Google
Job Summary
The Data Warehouse Architect in Enterprise Information & Analytics (EIA) designs the Scuba data warehouse ecosystem with a focus on ambulatory-related data. The role involves leading data warehouse operations, collaborating with stakeholders, providing technical direction, optimizing performance, driving innovation, and establishing data governance and standardization to align with business objectives.
- Architecture: Design both backend and frontend of the Scuba data warehouse ecosystem, including specialized data assets like DART, focusing on ambulatory-related data models and visualization solutions. Design and implement efficient and adaptable data models to support data exploration, data science, and analytics, resulting in insights that inform key business decisions.
- Operations: Lead data warehouse operations in collaboration with EIA colleagues. Design, develop, and optimize ETL workflows to support ambulatory business functions.
- Technical Leadership: Provide technical direction for analysts and developers in EIA, guiding them in creating trusted data assets and conducting code reviews. Serve as a subject matter expert in data warehouse concepts such as Kimball, star schema, snowflake schemas, and normalized and dimensional data models.
- Stakeholder Collaboration: Serve as a valued partner to stakeholders in the ambulatory business unit, offering data and analytics solutions while demonstrating a deep understanding of their business goals and operational objectives. Collaborate with departmental data stewards and technical system owners to establish a comprehensive understanding of the organization’s processes and data, ensuring alignment with ambulatory business needs.
- Communication: Translate business requirements from the ambulatory unit into technical specifications, ensuring alignment with organizational goals and addressing business needs.
- Performance Monitoring and Optimization: Proactively monitor and analyze performance to identify and recommend optimizations, enhancing system performance.
- Innovation: Stay current with the latest trends in data and analytics technologies, and drive innovation for the Scuba data warehouse ecosystem.
- Governance and Standards: Play an active role in establishing data governance and standardization, ensuring new and existing data assets conform to UCSF standards with appropriate access controls.
IT EIA Health Quality
Full Time
85321BR
Job Summary The Data Warehouse Architect in Enterprise Information & Analytics (EIA) designs the Scuba data warehouse ecosystem with a focus on ambulatory-related data. The role involves leading data warehouse operations, collaborating with stakeholders, providing technical direction, optimizing performance, driving innovation, and establishing data governance and standardization to align with business objectives.
- Architecture: Design both backend and frontend of the Scuba data warehouse ecosystem, including specialized data assets like DART, focusing on ambulatory-related data models and visualization solutions. Design and implement efficient and adaptable data models to support data exploration, data science, and analytics, resulting in insights that inform key business decisions.
- Operations: Lead data warehouse operations in collaboration with EIA colleagues. Design, develop, and optimize ETL workflows to support ambulatory business functions.
- Technical Leadership: Provide technical direction for analysts and developers in EIA, guiding them in creating trusted data assets and conducting code reviews. Serve as a subject matter expert in data warehouse concepts such as Kimball, star schema, snowflake schemas, and normalized and dimensional data models.
- Stakeholder Collaboration: Serve as a valued partner to stakeholders in the ambulatory business unit, offering data and analytics solutions while demonstrating a deep understanding of their business goals and operational objectives. Collaborate with departmental data stewards and technical system owners to establish a comprehensive understanding of the organization’s processes and data, ensuring alignment with ambulatory business needs.
- Communication: Translate business requirements from the ambulatory unit into technical specifications, ensuring alignment with organizational goals and addressing business needs.
- Performance Monitoring and Optimization: Proactively monitor and analyze performance to identify and recommend optimizations, enhancing system performance.
- Innovation: Stay current with the latest trends in data and analytics technologies, and drive innovation for the Scuba data warehouse ecosystem.
- Governance and Standards: Play an active role in establishing data governance and standardization, ensuring new and existing data assets conform to UCSF standards with appropriate access controls.
The final salary and offer components are subject to additional approvals based on UC policy.
Your placement within the salary range is dependent on a number of factors including your work experience and internal equity within this position classification at UCSF. For positions that are represented by a labor union, placement within the salary range will be guided by the rules in the collective bargaining agreement.
The salary range for this position is $129,600 - $303,800 (Annual Rate).
To learn more about the benefits of working at UCSF, including total compensation, please visit:
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 achieves 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.
- Possesses advanced knowledge of professional IT concepts. Broad knowledge of the IT environment.
- Advanced skills associated with programming design, modification and implementation. In-depth knowledge of secure software development. Requires in-depth knowledge of applications programming technologies, development tools and protocols.
- Demonstrated advanced knowledge, skills and abilities associated with system problem identification and resolution. Knowledge necessary to design, set up, operate and correct malfunctions involving technology systems. Experience in incident response and digital forensics, including data collection, examination and analysis.
- In-depth knowledge of business and process analysis functions. Knowledge of the design, development and application of technology and systems to meet business needs. Demonstrated ability to create software specifications.
- Demonstrated experience with database administration. Advanced knowledge of complex database management systems and standards. Knowledge relating to extremely highly complex database system design. Advanced database querying and modeling skills working with moderately complex databases. In-depth knowledge of conceptual database design. Skills necessary to develop procedures and standards relating to database management systems. Skills associated with implementing database enhancements that improve performance and reliability of the system at the software, hardware and operating system level.
- Familiarity with logical data design and data mapping or data conversion.
- In-depth knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Expert knowledge of computer security tools, best practices and policies including demonstrated experience securing server-based software. Demonstrated skill at analyzing and preventing security incidents of high complexity. Strong security skills for protecting the operating system, software, data and hardware.
- Expert knowledge of test application code in client server environment.
- Ability to write technical documentation in a clear and concise manner.
- Demonstrated comprehensive understanding of how system management actions affect other systems, system users and dependent / related functions. Experience in data integration and the specification of data services. Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.
- Familiarity with data quality and governance issues and requirements.
- Technical skill to develop, implement and test disaster recovery functions using backup technologies.
- Demonstrated expert project management s]]>
Job Tags
Full time, Work experience placement,