Job Search

SQL/ETL Developer

Job Title: SQL/ETL Developer
Location: Sydney
Reference: 3136508
Contact Email:
Job Published: June 07, 2020 11:45

Job Description

Well known financial services client is searching for a hybrid SQL Developer & ETL Developer to work in between the Data & BI team, scoping, documenting and delivering on BI requirements for the business. Includes use of running and updating ETL tools and SQL scripts

Pentaho experience will be held in high regard.

About the Role:
  • Responsible for the and delivery of data files from already automated processes
  • Troubleshooting BAU business critical processes
  • Ongoing support and administration of the databases and BI solutions
  • Perform research and analysis to support accurate and technically sound recommendations
  • Provide consultation services to the Actuarial team for general system related queries
  • Tracing data anomalies and general problem solving

 Other duties include:

  • Mapping processes to limit data duplication
  • Developing & supporting interfaces between core systems
  • Developing business cases for systems as required by the business
  • Developing functional and technical specification documents
  • Evaluating and recommend third party solutions as required
  • Developing standardised and ad-hoc solutions to deliver corporate information via web technologies
  • Designing and developing data warehouse technologies
  • Integration of disparate systems to reduce data duplication 
  • Consolidation of data stores

To be considered for this position, you will have demonstrable experience in the following:

  • Strong experience as a SQl & ETL developer in a large sized financial enterprise
  • Investigative work to interpret data structures, which may be undocumented and in diverse technologies
  • Enhancement and maintenance of existing DWs and ETL processes.
  • Creation of specifications, designs and other documentation to enable development and support of data warehouses and supporting applications
  • Development of quality assurance processes that ensure correct behaviour of ETL systems
  • Ensuring data is transported and landed in a secure and controlled fashion