Careers at yourtown

ETL Developer

Job no: 493220
Work type: Permanent (Full-Time)
Location: Milton
Categories: Information Technology

  • Salary packaging of up to $15,990 (visit https://remserv.com.au for more information)
  • WFH /onsite (40/60)
  • Financial assistance for educational activities 

 

About the role

It’s an exciting time to join the Information Digital & Technology (ID&T) team as we have just begun yourtown’s Digital Transformation journey. We call it Program LEAD (Leading Experiences Across Digital).

Program LEAD will directly and significantly contribute to achieving yourtown’s strategic goals to:

  • Help more young people, by modernising our digital footprint and enabling greater outreach
  • Help young people more deeply, by enabling us to offer integrated services, informed and personalised through improved data capture
  • Become a more efficient and effective organisation, enabling automation, making it faster to get information, and will streamline the ways in which we work
  • Increase funding, through reaching more financial stakeholders and engaging them more effectively.

 

As the ETL Developer you will be responsible for the ingestion, transformation and, integration of data and deliver structured data to a scalable data warehouse platform.

Your key responsibilities will include:

  • Project setup: work closely with the Business Analyst to understand the client’s requirements with full end-to-end responsibility for the ETL processes
  • Map data, analyse, document, and understand the source system and integration with Azure Power Platform
  • Deliver data migration activities including the development of queries to transform source data ready for load
  • Assess data quality by writing source-to-template QA scripts, and cleansing scripts (if required)
  • Develop SQL scripts/Stored Procedures for data migration
  • Develop & maintain documentation to support the understanding of where data is stored, ETL during data migration and defects within the knowledge base

 

About you

To be successful in this role you have:

  • Experience with:
    • Microsoft SQL Server
    • T-SQL skills including creating stored procedures, views, and indexes as well as performance tuning queries
    • BI tools (including Power BI), Data/Analytics, Reporting, Data Integration and Master Data Management
    • Azure DevOps release pipelines
  • Experience with some of the Microsoft Azure data products including:
    • Data Factory
    • Data Lake
    • Analysis Services
  • Strong analytical, problem-solving and communication skills.

For a full Position Description please visit: www.careers.yourtown.com.au

 

Benefits

  • Salary Packaging
  • Employee Assistance Program
  • Educational Assistance Program
  • Discounted corporate gym membership 
  • MLC super and health & lifestyle offers
  • Discounts on Westpac products and services
  • Discounted Private Health Insurance

 

About yourtown

At yourtown, we believe every young person has the right to a brighter future and aim to be part of the solution by delivering services that get results. Our services include Kids Helpline, training and employment services for young people, parent education and specialist accommodation for families. We are one of the largest not-for-profit providers of services for young people in Australia with sites across Queensland, New South Wales, South Australia and Tasmania. The community with yourtown’s Art Unions funds most of what we do. At yourtown you will be part of the solution.

Contact: Miranda Dal, Senior Talent Acquisition Specialist on 0466 576 547

In line with yourtown's diverse workplace culture, Aboriginal and Torres Strait Islander people are encouraged to apply.

yourtown is committed to providing services that protect and keep children, young people and adults at risk free from harm. The appointment of successful applicants will be subject to satisfactory screening for child-related employment including the completion of a National Criminal History Check and retention of a valid Working with Children Check. 

"In our team we value diversity, inclusivity and people who want to make a difference"

yourtown supports vaccination as the best way to keep our people and our communities safe from Covid-19. We require all employees, volunteers, students and contractors to be fully vaccinated against Covid-19 as a condition of employment.

Position Description


Advertised: E. Australia Standard Time
Applications close:

Back to search results Apply now Refer a friend

Share this:

| More

Refine search

Locations

Categories

Work type