Data Architect II

req13488

Univ Analytics and Inst Rsch

Main Campus

Tucson, AZ USA

Data Architect II supports the Data Warehouse maintained by the University Analytics and Institutional Research division. The Enterprise Data Warehouse combines data from various transactional systems including PeopleSoft HCM, PeopleSoft Campus Solutions (CS), Kuali KFS, and Kuali Coeus, among others. This position will primarily focus on designing, developing, and implementing the ETL processes for the PeopleSoft and Kuali contents of the data warehouse. This position requires understanding business requirements, strong analytic skills, creating and modifying ETL workflows, validating completeness and accuracy of data, testing and documenting modifications.

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.

• Develop, test, and maintain IBM InfoSphere DataStage 11.7 jobs for the institutional Data Warehouse.
• Assist the ETL team in developing and testing IBM InfoSphere DataStage 11.7 jobs for the institutional DataWarehouse.
• Work closely with ETL Development Team to debug existing jobs and help offload other ETL team member responsibilities.
• Creating and maintaining documentation relating to business processes translated into ETL/ELT jobs.
• Provides support to end users and handle support requests in a timely manner.
• Perform other related duties as required or assigned by ETL lead.
• Additional duties may include gathering and analyzing business, data and reporting requirements, plus documentation and specification of requirements.

Knowledge, Skills, and Abilities:

• Effective communication skills, both written and verbal
• Ability to design, implement, and troubleshoot ETL/ELT jobs
• Excellent collaboration and teamwork – ability to work cross functionally
• Ability to multi-task and meet negotiated timelines
• Demonstrated ability to work independently, as well as function as a team member

Exempt

Full Time

40

1.0

Fiscal

Planning and Analysis

Yes - Full Benefits

$65,936.80 DOE

salary at 1.0 full-time equivalency (FTE)

9

PC2

Data Analysis

Planning & Analysis

Fingerprint criminal background check (security sensitive due to title or department)

1

UITS-Jobs
uits-jobs@arizona.edu

2/8/2023

Yes

Resume and Cover Letter

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.