ETL Developer/Data Engineer

Location
Tucson, AZ
Posted
Aug 31, 2020
Institution Type
Four-Year Institution
ETL Developer/Data Engineer Posting Numberreq592 DepartmentUniv Analytics and Inst Rsch Department Website Linkhttps://uair.arizona.edu/LocationMain Campus AddressTucson, AZ USA Position HighlightsThe University of Arizona is looking for an experienced ETL Developer/Data Engineer to support the Data Warehouse maintained by the University Analytics and Institutional Research department, under the Division of the Chief Information Officer (CIO). 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. The incumbent in this position will work with subject matter experts and Business Intelligence Analysts to transform business requirements and deliver the data warehousing and business intelligence components essential for decision making. This position will also assist in the design, development and implementation of dimensional models, or other similar data structures as needed.

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 retirement plan; access to UA recreation and cultural activities; and more!

As a cost-saving measure related to the impact of COVID-19, a furlough and pay reduction program has been approved by the Arizona Board of Regents. All new hires subject to the plan will be notified in accordance with adopted furlough and pay reduction program guidelines and will be required to comply with all measures. To learn more about the furlough and pay reduction program and whether this position is affected, please visit hr.arizona.edu.

Duties & Responsibilities

Position requires varied work hours, which may include evenings, weekends, and holidays

Duties & Responsibilities

  • Develop, test and maintain IBM InfoSphere DataStage 11.7 jobs for the institutional Data Warehouse
  • Participate in the development of coding standards for IBM InfoSphere DataStage
  • Assist in supporting the nightly jobs already in production at the UA
  • Design, create and review dimensional data models
  • Act as an ETL consultant for other areas or teams
  • Provide input and support for upgrades, capacity planning, and “best practices”
  • Assist with deployment of data models in the Oracle Business Intelligence Enterprise reporting tool
  • Creating and maintaining documentation relating to business processes translated into ETL/ELT jobs
  • Develop and maintain reports and dashboards as needed
  • Additional duties may include gathering and analyzing business, data and reporting requirements, plus documentation and specification of requirements

 Knowledge, Skills, & Abilities

  •  Working knowledge with ETL/ELT platforms with IBM InfoSphere DataStage.
  • Ability to design, implement, and troubleshoot ETL/ELT jobs
  • Experience in using a scheduling tool to schedule ETL/ELT jobs
  • Knowledge of best practices in structured and unstructured databases, ETL design, and/or BI technologies
  • Knowledge in database modeling techniques and best practices such as Star, Snowflake, 3NF, etc.
  • Ability to communicate complicated technical knowledge in a way that non-technical data roles will be able to understand
  • Excellent interpersonal and communication skills, both written and verbal
  • Demonstrated productivity when working independently and as a team member
  • Ability to work in a highly collaborative and inclusive environment
  • Ability to multi-task and meet negotiated deadlines
Minimum Qualifications

Minimum Qualifications

  • Bachelor’s degree in Science, Technology, Engineering, Math (STEM) or related field
  • Five or more years of experience developing data warehouse ETL jobs
  • Two or more years of experience creating jobs in IBM InfoSphere DataStage ver. 9+

Preferred Qualifications

  •  Four or more years of experience creating jobs in IBM InfoSphere DataStage ver. 9+
  • Three or more years of experience with Oracle RDBMS
  • One or more years of experience with PeopleSoft EPM
  • Demonstrated knowledge of PeopleSoft HCM or CSW modules
  • Demonstrated knowledge of Kuali Financial or Coeus modules
  • Experience using Control-M to schedule Datastage jobs
  • Work experience in human resources, financial and/or student system fields
  • Experience with Oracle Business Intelligence Enterprise Edition
  • Strong technical understanding of ERP data structures and how they relate to establishing data warehousing, data management, and analytic architectures
  • Experience developing business requirements and translating them into a data warehouse dimensional models
Preferred QualificationsFLSAExempt Full Time/Part TimeFull TimeNumber of Hours Worked per Week40 Job FTE1.0Work CalendarFiscalJob CategoryPlanning and AnalysisBenefits EligibleYes - Full Benefits Range Minimum68801 Range Midpoint99380Range Maximum122314Rate of Pay$70,000 - $90,000Compensation Typesalary at 1.0 full-time equivalency (FTE) Grade11 Career Stream and LevelPC3Job FamilyData Analysis Job FunctionPlanning & Analysis Type of criminal background check required:Fingerprint criminal background check (security sensitive due to title or department) Number of Vacancies2 Target Hire Date Expected End Date Contact Information for CandidatesGrishma Chitrakar Open Date2/24/2020Open Until FilledYesDocuments Needed to ApplyResume and Cover LetterSpecial Instructions to Applicant Diversity StatementAt 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 an 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.