Amazon Web Services (AWS), Best Practices, Business Analysis, Business Intelligence Software, Business Processes, Capacity Management, Coding Standards, Communication Skills, Consulting, Data Analysis, Data Modeling, Data Warehousing, DataArchitect Data Modeling Tool, Database Design, Database Extract Transform and Load (ETL), Documentation, Higher Education, IBM WebSphere DataStage, Identify Issues, Interpersonal Skills, Knowledge Modeling, Multitasking, Oracle, Peoplesoft, Performance Tuning/Optimization, Presentation/Verbal Skills, Reporting Dashboards, Snowflake Schema, Star Schema, Team Player, Test Plan/Schedule, Time Management, Writing Skills
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 ETLELT 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 ETLELT jobs.
Performance Tuning of the ETLELT Processes.
Gathering and analyzing business data and reporting requirements plus documentation and specification of requirements.
Key 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 ETLELT 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 ETLELT jobs.
- Performance Tuning of the ETLELT Processes.
- Gathering and analyzing business data and reporting requirements plus documentation and specification of requirements.
Requirements
- Working knowledge with ETLELT platforms with IBM InfoSphere DataStage and AWS Glue.
- Ability to design implement and troubleshoot ETLELT jobs.
- Knowledge of scheduling tools to schedule ETLELT 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.
Note
This job posting reflects the general nature and level of work expected of the selected candidates. It is not intended to be an exhaustive list of all duties and responsibilities. The institution reserves the right to amend or update this description as organizational priorities and institutional needs evolve.