Data Warehouse Architect
Data Warehouse Architect
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
$ 129600 - 303800
1 Vacancy
Job Description
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 organizations 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 $129600 - $303800 (Annual Rate).
To learn more about the benefits of working at UCSF including total compensation please visit: degree in related area and/or equivalent experience/training.
Equal Employment Opportunity
The University of California is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race color religion sex sexual orientation gender identity national origin disability age protected veteran status or other protected status under state or federal law.
Department Description
The mission of the Enterprise Information and Analytics (EIA) department is to advance UCSFs 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 UCSFs data assets into actionable insight and information.
About UCSF
At UCSF Health our mission of innovative patient care advanced technology and pioneering research is redefining whats 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
Join us to find a rewarding career contributing to improving healthcare worldwide.
Employment Type
Full Time
