Developer, Extract Transform Load/ETL

UNIVERSITY OF ARIZONA; Hyde Park Township (IL); Remote; USD 86,000 - 113,000; Full time

Job summary

An established industry player is seeking a skilled ETL Developer/Data Engineer to join their team. This role involves designing and implementing ETL processes for data warehousing, working closely with subject matter experts to transform business requirements into actionable data solutions. The ideal candidate will have extensive experience with IBM InfoSphere DataStage and AWS Glue, along with a strong understanding of database modeling techniques. This position offers a collaborative environment and numerous benefits, making it an exciting opportunity for those passionate about data engineering and analytics.

Benefits

Health Insurance

Dental Insurance

Vision Insurance

Paid Vacation

Tuition Reduction

Retirement Plans

Access to Recreation Activities

Qualifications

• 5+ years of relevant work experience in ETL processes.
• Ability to design and troubleshoot ETL/ELT jobs.
• Experience with AWS Cloud services.

Responsibilities

• Develop and maintain ETL jobs for the institutional Data Warehouse.
• Assist with deployment of data models in Oracle BI tools.
• Provide support for upgrades and capacity planning.

Skills

ETL/ELT Platforms

IBM InfoSphere DataStage

AWS Glue

Database Modeling Techniques

Communication Skills

Education

Bachelor's Degree

Tools

IBM InfoSphere DataStage

AWS Glue

Oracle RDBMS

Control-M

Job description

Position Highlights ETL Developer/Data Engineer position will primarily focus on designing, developing, and implementing the ETL/ELT 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.

Candidates working anywhere in Arizona may be considered for a remote assignment.

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; 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.
• Participate in the development of coding standards for IBM InfoSphere DataStage.
• Act as an ETL consultant for other areas or teams.
• Develop AWS Glue jobs for the ETL/ELT Processes as part of the Datawarehouse Modernization Initiative.
• Develop and maintain reports and dashboards as needed.
• Assist in supporting the nightly jobs already in production at the University.
• 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.
• Performance Tuning of the ETL/ELT Processes.
• 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 and AWS Glue.
• Ability to design, implement, and troubleshoot ETL/ELT jobs.
• Knowledge of scheduling tools 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.
• Demonstrated knowledge of Higher Education PeopleSoft HCM and CSW modules
• Demonstrated knowledge of Higher Education Kuali Financial and Kuali Coeus modules

Minimum Qualifications

• Bachelor's degree or equivalent advanced learning attained through professional level experience required.

AND

• Minimum of 5 years of relevant work experience, or equivalent combination of education and work experience.

Preferred Qualifications

• Four or more years of experience creating jobs in IBM InfoSphere DataStage ver. 9+
• Two or more years of experience creating AWS Glue ETL/ELT jobs
• Work experience with AWS Cloud services like Glue, S3, Redshift, Athena, Lambda, Step Functions, AppFlow, Cloud Formation and Code Pipeline
• Three or more years of experience with Oracle RDBMS
• One or more years of experience with PeopleSoft EPM
• Demonstrated knowledge of Higher Education PeopleSoft HCM and CSW modules
• Demonstrated knowledge of Higher Education Kuali Financial and Kuali Coeus modules
• Experience using Control-M to schedule Datastage jobs and AWS Glue jobs
• Work experience in human resources, financial and/or student system column definitions
• Experience with Oracle Business Intelligence Enterprise Edition Reporting and Visualization tools
• Strong technical understanding of ERP data structures and how they relate to establishing data warehousing, data management, and analytics architecture
• Experience developing business requirements and translating them into a data warehouse dimensional model

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 $86,870 - $112,932

Compensation Type salary at 1.0 full-time equivalency (FTE)

Grade 11

Compensation Guidance The Rate of Pay Field represents the University of Arizona’s good faith and reasonable estimate of the range of possible compensation at the time of posting. The University considers several factors when extending an offer, including but not limited to, the role and associated responsibilities, a candidate’s work experience, education/training, key skills, and internal equity.

The Grade Range represent a full range of career compensation growth over time. The university offers compensation growth opportunities within its career architecture. To learn more about compensation, please review our Applicant Compensation Guide and our Total Rewards Calculator .

Career Stream and Level PC3

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 [e-mail]

Open Date 4/30/2025

Open Until Filled Yes

Documents Needed to Apply Resume and Cover Letter

Special Instructions to Applicant

Notice of Availability of the Annual Security and Fire Safety Report In compliance with the Jeanne Clery Disclosure of Campus Security Policy and Campus Crime Statistics Act (Clery Act), each year the University of Arizona releases an Annual Security Report (ASR) for each of the University’s campuses.Thesereports disclose information including Clery crime statistics for the previous three calendar years and policies, procedures, and programs the University uses to keep students and employees safe, including how to report crimes or other emergencies and resources for crime victims. As a campus with residential housing facilities, the Main Campus ASR also includes a combined Annual Fire Safety report with information on fire statistics and fire safety systems, policies, and procedures.
Paper copies of the Reports can be obtained by contacting the University Compliance Office at [e-mail].