We now have a full time (36.25 hours) opportunity for a Data Engineer to join our world-leading institution at James Cook University as a fixed term appointment to 31st March 2022 with the potential to extend. This position is based at the Townsville campus in picturesque North Queensland, where you can enjoy a tropical lifestyle whilst achieving your career goals.
What you will achieve
Working within a sector leading business intelligence team, you will be responsible for the fast, efficient and accurate ETL processes that supports University reporting. You will also get to liaise with the Technical Architect Data Warehouse, to build upon and maintain an agreed set of ETL design principles, as well as providing ongoing insights into relevant ETL technologies and industry trends in order to best support the University’s long-term data warehouse vision.
Using your experience with relational databases you will design, implement and maintain efficient and timely data flows to uphold the integrity of JCU’s enterprise data warehouse by providing in-house technical expertise and supportive ETL documentation.
What you can bring
Having 3 to 5 years’ experience working within relational databases you can write complex SQL queries and PL/SQL scripts derived from high-level business requirements. You will have proven experience in SQL Query Optimisation and thorough understanding of the complexities involved when loading and transforming large amounts of relational data, preferably within Oracle databases.
You can also bring a strong understanding of concepts such as integrity constraints, parallel execution and indexing. Experience in Data Warehousing and tools such as Materialised Views and Query Rewrites, as well as Dimensional Modelling techniques such as Star Schemas and OLAP reporting combined with a basic understanding of UNIX scripting would be highly regarded.
Consistently ranked in the top 2% of universities worldwide, JCU is one of the world’s leading institutions focusing on the tropics and offers a culturally diverse working environment with opportunities for professional and personal growth. JCU prides itself on being dedicated to teaching, learning and research that is not only of high quality, but also delivers practical benefits to the peoples and industries of the region.