Data Architect III - College of Medicine (Phoenix)
Posting Number: req18388
Department: COM Phx Campus Administration
Location: Greater Phoenix Area
Address: 650 E. Van Buren Street, Phoenix, AZ 85004 USA
Position Highlights
The University of Arizona College of Medicine - Phoenix is currently seeking applicants for a Data Architect III to develop, design, implement, and maintain an Enterprise College level Data Warehouse. As the Data Architect III, you will be responsible for managing the College's Data and Analytics platforms to meet our data and information demands. This position will partner closely with their peers of Business Analysts, Project Managers, Programmers and Application Architects to research and delivery optimum solutions. Manage and/or design user interfaces and will consult /advise users regarding accessibility, usability, and aesthetic appeal of . Assignments include If you are a self-starter and have technical skills to be a key player in a small team, we welcome your application!The College of Medicine Phoenix Information Technology Services team is committed to creating and delivering an environment that promotes and advances teaching, learning and research. Working collaboratively and cooperatively across organizational boundaries we design, implement and support a wide variety of solutions that improve and streamline operations and meets the needs of our multi-University student, faculty and staff population.
Outstanding UA benefits include health, dental, and vision insurance plans; life insurance and disability programs; paid vacation, sick leave, and holidays; UA/ASU/NAU tuition reduction for the employee and qualified family members; state and optional retirement plans; access to UA recreation and cultural activities; and more!
The University of Arizona has been recognized for our innovative work-life programs. For more information about working at the University of Arizona and relocations services, please click here.
Duties & Responsibilities
Data Warehouse Design and Modeling
- Build enterprise standard data models for analytics, reporting and application usage.
- Develop comprehensive data warehouse architecture, including data models, schemas, ETL/ELT processes and SQL objects (tables, views, stored procedures, functions).
- Research, apply and refine best practices for data warehouse architectures, methods and features.
- Work with users and business analyst to translate functional requirements into technical data warehouse solutions in a Cloud Computing environment.
- Ensure scalability, performance, and data integrity within the data warehouse.
Development and integration
- Design and implement ETL/ELT processes to integrate a variety of high-volume data stores from different sources into the data warehouse, capture changes and maintain current and historical information.
- Perform analysis and provide performance tuning recommendations for data structures, SQL code and ETL design to improve performance.
- Adapt ETL/ELT processes to accommodate changes in source systems and new business user requirements.
- Develop real-time/bulk data pipelines from a variety of sources (Streaming data, API's, data warehouse, messages, images, and videos).
- Actively apply best practices within DataOps (Version Control, P.R. Based Development, Schema Change Control, CI/CD, Deployment Automation, Test Automation, Shift left on Security, Loosely Coupled Architectures, Monitoring, Proactive Notifications).
- Utilize modern cloud technologies, follow established design patterns, and employ best practices from DevOps/DataOps to produce enterprise quality production SQL code with minimal errors.
- Troubleshoot and resolve data integration issues promptly.
Data governance and security
- Establish data governance policies and procedures to ensure data quality, consistency, and compliance with regulations (e.g., FERPA HIPAA).
- Implement robust security measures to safeguard sensitive data within the data warehouse.
- Collaborate with the team to manage access controls, design application interfaces and data encryption.
- Ensures the data warehouse environment meets or exceeds all UA Security Policies.
Performance Optimization
- Continuously monitor and fine-tune the data warehouse's performance.
Identify and address bottlenecks, optimizing SQL queries, and tuning database configurations.
Implement best practices for indexing, partitioning, and caching.Data governance and security - Establish data governance policies and procedures to ensure data quality, consistency, and compliance with regulations (e.g., FERPA HIPAA).
- Implement robust security measures to safeguard sensitive data within the data warehouse.
- Collaborate with the team to manage access controls, design application interfaces and data encryption.
- Ensures the data warehouse environment meets or exceeds all UA Security Policies.
Documentation and training
- Maintain comprehensive documentation of data warehouse architecture, ETL/ELT processes, and data flow.
- Provide training and support to data analysts, data engineers, and other stakeholders on data warehouse usage and best practices.
- Stay up-to-date with industry trends and emerging technologies in data warehousing.
Minimum Qualifications
- Bachelor's degree or equivalent advanced learning attained through professional level experience required.
- Minimum of five (5) years of relevant work experience, or equivalent combination of education and work experience.
Preferred Qualifications
* Master's Degree in related field of study
* 5 + years Data Warehouse, Data Lake, Data Analytics or Database Modeling experience required
* 5+ years' experience using SQL, Amazon Redshift or Snowflake.
* 5+ years' experience in Business Intelligence applications like Tableau, or PowerBI.
* 2+ years of experience in relational and dimensional data modeling required.
* AWS experience.
* Experience working in higher education, EdTech or other education-related organization(s).
* Working knowledge of Agile, Scrum, and Kanban.
* Ability to combine data from multiple sources when needed for analysis.
* Working knowledge of Software Engineering and Object Orient Programming Principles.
FLSA: Exempt
Full Time/Part Time: Full Time
Number of Hours Worked per Week: 40
Job FTE: 1.0
Work Calendar: Fiscal
Job Category: Planning and Analysis
Benefits Eligible: Yes - Full Benefits
Rate of Pay: $86,870 - $112,932, DOE
Compensation Type: salary at 1.0 full-time equivalency (FTE)
Grade
11
Career Stream and Level
PC3
Job Family
Data Analysis
Job Function
Planning & Analysis
Type of criminal background check required: Name-based criminal background check (non-security sensitive)
Number of Vacancies: 1
Contact Information for Candidates
College of Medicine-Phoenix, Office of Human Resources
Open Until Filled: Yes
Documents Needed to Apply: Resume and Cover Letter
Special Instructions to Applicant
Application: The online application should be completed in its entirety. Blank or missed information may be considered an incomplete submission.
Letter of Interest: Should clearly indicate how your skills and professional employment experience meet the Minimum and the Preferred qualifications (if applicable).
Diversity Statement
At the University of Arizona, we value our inclusive climate because we know that diversity in experiences and perspectives is vital to advancing innovation, critical thinking, solving complex problems, and creating an inclusive academic community. As a Hispanic-serving institution, we translate these values into action by seeking individuals who have experience and expertise working with diverse students, colleagues, and constituencies. Because we seek a workforce with a wide range of perspectives and experiences, we provide equal employment opportunities to applicants and employees without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or genetic information. As an Employer of National Service, we also welcome alumni of AmeriCorps, Peace Corps, and other national service programs and others who will help us advance our Inclusive Excellence initiative aimed at creating a university that values student, staff and faculty engagement in addressing issues of diversity and inclusiveness.
