Data Architect

Are you looking for a new challenge, to push yourself, and for great career growth opportunities? Do you enjoy working with data, but also love being part of a highly collaborative team that works on difficult and important work? Then consider joining the Office of Budget and Planning at the University of Arizona, as our next Data Architect.

This is a professional Data Architect within the University’s Office of Budget and Planning. This position assists the Office of Budget and Planning in data design for the institutional budgeting and planning software (Anaplan), automating business processes and SQL data builds, and supporting integrations.

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.

 Designing data structures for Institutional Budgeting and Planning Software:

• Designs and maintains data structure for datasets / requirements to support OLAP-based (data slice) and Relational-based reporting.
• Prepares detailed technical specifications.
• Designs and maintains forms, reports, and associated calculated fields for end-users and administration.
• Designs and maintains workflow automations and code data validations.
• Creates SQL builds.
• Creates and revises maintenance technical documentation.

Automating Business Processes and SQL Builds:

• Collaborates with subject matter experts to identify business and technical requirements.
• Partners with subject matter experts to create process documentation to be used in automating processes, ensuring alignment with process policies and procedures.
• Builds and customizes automated workflows and reports to support key stakeholders.
• Automates SQL data builds.
• Enables standardized processes over time.

Data Integration:

• Defines, designs, and builds dimensional database schemas.
• Defines and captures metadata and rules associated with ETL processes.
• Adapts ETL processes to accommodate changes in source systems and new business processes.

Knowledge, Skills, and Abilities:

• Intermediate Excel skills.
• Ability to think critically/analytically as well as exhibit an interest in learning and taking on challenging tasks.
• Ability to break down processes into detailed components.
• Ability to identify problems and their root cause.
• Ability to independently propose solutions to problems for manager review, requiring innovation and creativity.
• Ability to create structure in a dynamic, often ambiguous and/or complex environment.
• Ability to use independent judgment and work under minimal guidance to determine the best approach and use creativity to achieve maximum results and handle new situations.
• Strong organizational and time management skills with ability to focus on deadlines and deliverables.
• Knowledge of higher education administrative systems and related business principles.

• Bachelor’s Degree in Computer Science, Management Information Systems, or related field AND three years of experience with databases and programming OR any equivalent combination of experience, training and/or education.

• Experience with UAccess Enterprise Systems; Financials, Budget, Analytics, Employee, and Student
• Master’s Degree in Computer Science, Management Information Systems, or related field
• Demonstrated experience with database design, and SQL
• Experience with dimensional modeling
• Experience with Process Automation and SQL Procedures and Triggers