ETL & API Developer

  • Australia
  • Melbourne
  • Contract
  • Negotiable

We are seeking an ETL & API Developer to join our IT team. This technical role is responsible for delivering solutions related to data transformation, mapping, automation, and API development. You will work closely with the data team to define and implement solutions, leveraging various data platforms and tools. Your role will require a solid understanding of data engineering, ETL pipelines, API development, and integration.

As a key member of the team, you will work under DevOps governance controls and processes to ensure the quality of deliverables.

Key Responsibilities

Data Reporting and Management:

  • Develop and support key performance measures and reporting tools.
  • Build effective controls, monitoring, and auditing solutions to ensure data quality, currency, and timeliness.
  • Assist in the development, optimization, and management of ETL/ELT pipelines using Oracle and other technologies.
  • Write and optimize SQL queries for data transformation and integration.
  • Support the creation of dashboards and visualizations using tools like Tableau or Power BI.

API Development:

  • Design, develop, and integrate RESTful APIs using OCI API Gateway, Oracle Functions, and OCI Service Mesh.
  • Manage API security, including IAM, OAuth2, JWT, and other best practices.
  • Integrate APIs with ETL pipelines and ensure effective data handling.

Teamwork & Project Delivery:

  • Contribute to IT data projects, including solution selection, design, and implementation.
  • Collaborate with internal and external stakeholders to understand requirements and ensure alignment with organizational goals.
  • Work in accordance with health, safety, environment, and quality systems.

Professional Development:

  • Continuously develop technical expertise and support the development of others.
  • Model professional conduct in line with values and the Code of Conduct.

Knowledge, Skills & Experience

Essential:

  • Strong proficiency in SQL/PLSQL, including advanced functions, stored procedures, and data transformation techniques.
  • Familiarity with Oracle technologies (e.g., Oracle GoldenGate, Oracle Autonomous Database).
  • Experience in API development, including designing and integrating RESTful APIs.
  • Solid understanding of ETL, data pipeline management, and cloud-based data platforms.
  • Exposure to BI tools (e.g., Tableau, Power BI).
  • Strong problem-solving and analytical skills.
  • Ability to work effectively with stakeholders and communicate technical concepts clearly.

Desirable:

  • Experience with reporting across multiple domains (e.g., health, finance, operations).
  • Knowledge of IT security practices and compliance.
  • Experience with system development life cycles and quality management best practices.

Special Conditions

As part of the team, you will be required to:

  • Undergo pre-employment drug and alcohol testing and be subject to random testing.
  • Maintain a minimum level of immunisation.
  • Complete medical examinations, functional capacity assessments, and background checks.
  • Hold a current Australian Driver’s License.

How to Apply

If you are passionate about making a difference and possess the skills and experience outlined above, we would love to hear from you. For further information feel free to give Ronald a call on 9236 7737.

Apply now

Submit your details and attach your resume below. Hint: make sure all relevant experience is included in your CV and keep your message to the hiring team short and sweet - 2000 characters or less is perfect.