• Job Description

  Req#: req13488

  Data Architect II
  Posting Number	req13488
  Department	Univ Analytics and Inst Rsch
  Department Website Link
  Location	Main Campus
  Address	Tucson, AZ USA
  Position Highlights	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. For more information about working at the University of Arizona and relocations services, please click here .
  Duties & Responsibilities	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
  Minimum Qualifications	Bachelor’s degree in Science, Technology, Engineering, Math (STEM) or related field Minimum of 3 years of progressive experience in IT technologies. Experience with any enterprise-scale relational database i.e. Oracle, Microsoft SQL Server, or IBM DB2 Experience developing jobs using ETL tools and technologies i.e. IBM Datastage, Informatica, Talend Experience using any coding/scripting languages i.e. Python, Bash shell, C++, C#, or Java Experience in data movement involving SOAP, REST, JSON, XML, or related technologies
  Preferred Qualifications	Experience in developing ETL jobs with IBM InfoSphere DataStage 9+ Experience writing Oracle SQL and PL/SQL scripts Experience with data modeling concepts, databases, and data integration Experience with batch scheduling tools i.e., Autosys, Tivoli, or Control-M
  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	$65,936.80 + DOE
  Compensation Type	salary at 1.0 full-time equivalency (FTE)
  Grade	9
  Career Stream and Level	PC2
  Job Family	Data Analysis
  Job Function	Planning & Analysis
  Type of criminal background check required:	Fingerprint criminal background check (security sensitive due to title or department)
  Number of Vacancies	1
  Target Hire Date
  Expected End Date
  Contact Information for Candidates	UITS-Jobs uits-jobs@arizona.edu
  Open Date	2/8/2023
  Open Until Filled	Yes
  Documents Needed to Apply	Resume and Cover Letter
  Special Instructions to Applicant
  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.

• About the company

  95194 The University of Arizona is a public land-grant research university in Tucson, Arizona.

Notice