Data Architect Jobs

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.

Designing data structures for Institutional Budgeting and Planning Software:

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

Automating Business Processes and SQL Builds:

• Automates SQL data builds.
• Collaborates with subject matter experts to identify business and technical requirements.
• Enables standardized processes over time.
• 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.

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:

• Ability to break down processes into detailed components.
• Strong organizational and time management skills with ability to focus on deadlines and deliverables.
• Intermediate Excel skills.
• Ability to think critically/analytically as well as exhibit an interest in learning and taking on challenging tasks.
• Ability to independently propose solutions to problems for manager review, requiring innovation and creativity.
• Knowledge of higher education administrative systems and related business principles.
• 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.
• Ability to identify problems and their root cause.