Data Engineer - 6 Months Fixed Term

A great place to work
When you join Capricorn, you become a part of something bigger than a typical company, because as a co-operative we exist to improve the lives of our Members by supporting them in building stronger businesses - not the other way around.
We are purpose-led and are committed to empowering our community to thrive. Our community includes our employees, and we know what is important to them, because we asked! And here's our commitments to you:

• Provide a diverse and inclusive workplace - because we know how important it is for everyone to be treated fairly and with respect.

• Give you flexibility - it's important to recognise we are all unique and need to create work life balance.

• Offer paid parental leave - that supports both parent's leave and their transition back to work.

• Create a fun environment - our social calendar is full up with a range of different virtual and face-to-face events to keep us connected.

• Work perks - that our employees actually use, such as a fantastic reward and recognition program, wellness program, additional leave purchase and so much more!

Role Purpose
We are actively seeking a dynamic and passionate Data Engineer to join our team. The Data Engineers are responsible for designing and, building, and maintaining solutions for collecting, storing, and analysing data at scale and ensuring it is in a highly usable state by the time it reaches data scientists and analysts of the business units within Capricorn, as well as supporting the legacy Data Warehouse stack.
This hands-on role requires technical expertise to deliver data and analytical services, including data ingestion, transformation, storage, and reporting, and strives to continuously develop new and improved Data Engineering capabilities.
Key Accountabilities

• Creates and implements Data Engineering solutions using modern software engineering practices

• Creation of databases optimized for performance, implementing schema changes, and maintaining data architecture standards across all the business's databases

• Development and implementation of scripts for database maintenance, monitoring, and performance tuning

• Designing and developing scalable ETL packages

• To oversee large-scale data platforms and to support the fast-growing data within the business

• Enabling and running data migrations across different databases and different servers, for example, data migration from SQL servers to MySQL

• Defines and implements data stores based on system requirements and consumer requirements

• Codify best practices for future reuse in the form of accessible, reusable patterns, templates, and codebases

• Implements well designed, testable and efficient data pipelines

Skills, Knowledge and Attributes

• Strong Data Warehousing experience utilising SSAS, SSIS and SSRS Reporting, performance tuning, as well as replication and scaling.

• Expertise in SQL and ETL automation, including experience with Microsoft SQL Server database engine and an understanding of database concepts and the ability to create and maintain complex SQL queries.

• Proven ability to interpret business requirements into technical and analytical solutions.

• Solid understanding of the full development life cycle.

• Knowledge of Agile development methodologies.

• Source control knowledge for continuous integration and continuous development.

• Experience in Denodo will be an advantage.

Qualifications

• Ideally, a bachelor's degree in computer science, Information Systems, or equivalent experience

Who are we?
Capricorn is a member-based financial services organisation which exists to improve the lives of over 25,000 Members across Australia and New Zealand by supporting them in building stronger automotive businesses. We provide products and services including trade credit, risk protection, equipment finance, trade events, travel services, fuel cards and more. Last financial year Member purchases exceeded $2.93 billion and Member returns exceeded $72.5 million.
The next steps
If you think you are the right person for this role and you believe in a Member first culture, then please apply now. Applications will be reviewed as they arrive, so it is better to apply sooner rather than later. If you need any assistance or adjustments to fully participate in the application process, please contact HR on +618 6250 9500.
For further information and detail on Capricorn, please visit our website at www.capricorn.coop/careers.