ETL Analyst/Developer
| Reference | 253094 |
|---|---|
| Directorate | Information Services |
| Grade | 6 |
| Salary range | £28,331-£31,866 |
| Contract type | Fixed Term (15 months) |
|---|---|
| FTE | 1.0 (35 hours per week) |
| Holidays | 31 days + 11 statutory days |
| Closing date | Wednesday 23 October 2019 |
ETL Analyst/Developer
| Reference | 253094 |
|---|---|
| Directorate | Information Services |
| Grade | 6 |
| Salary range | £28,331-£31,866 |
| Contract type | Fixed Term (15 months) |
|---|---|
| FTE | 1.0 (35 hours per week) |
| Holidays | 31 days + 11 statutory days |
| Closing date | Wednesday 23 October 2019 |
An exciting opportunity has arisen within the University’s Enterprise Data Warehouse team for an ETL Analyst/Developer to work on a new project with key stakeholders to develop a Learning Analytics Datamart.
This project will provide the University with a solid foundation for high-quality Management Information/Business Intelligence reporting and allow the measurement of learning activities to facilitate senior management decision making for targets on strategic objectives for an outstanding Student experience.
The successful candidate will, preferably, have software development experience, possibly in a Data Warehouse or Data Integrations environment, showing technical knowledge, interests and possibly some experience in any of the following:
- Data Warehouse development preferably in an Oracle environment.
- ETL project development preferably with Oracle Data Integrator.
- Oracle 10g and above with PL/SQL and SQL.
- SQL Developer or similar.
- Dimensional Modelling and Database design.
Desirable to have but not essential:
- Data visualization development for analysis of datasets.
- Agile development using JIRA / Confluence
These skills are required to ensure the Directorate meets’ objectives to enhance the student experience. In return, you will receive ‘on-the-job’ training from a highly experienced team. You will contribute to a dynamic, motivated and supportive working environment, delivering highly innovative solutions for the University of Strathclyde enhancing your experience across all stages of the systems development life-cycle.
The successful candidate will experience a highly dynamic and motivating work environment, working with enthusiastic partners within the Education Enhancement department. You will work with senior developers supporting Myplace – the University’s Virtual Learning Environment - building requirements to develop extract, transform and load processes for the learning analytics data marts. The role sits within a growing data warehouse/business intelligence team developing management information solutions across the higher education landscape.
University Employee Benefits include a generous holiday package with the opportunity to apply for holiday purchase scheme, employer pension contributions as well as eligibility to apply/subscribe to facilities and incentives associated with being an employee of the University such as membership of the Sport Centre, on-site childcare, car parking and a cycle to work scheme.
Interviews are scheduled to take place during week commencing 28 November 2019.
For informal enquiries, please contact Mr Robert Anderson, Enterprise Data Warehouse Manager {robert.m.anderson@strath.ac.uk)