Connecting...

Banner Default Image

 

Data Warehouse Developer (SQL)

Job Title: Data Warehouse Developer (SQL)
Contract Type: Permanent
Location: Sydney
Industry: Technology, Digital & Projects
Salary: Upto $145,000 + Super + STI
Reference: 894391
Contact Name: Jason Ajai
Contact Email:
Job Published: 09 May 2022

Description

Summary

The Data Warehouse Developer (DWD) role involves application ownership for key business data repositories. The role requires full hands-on Application Life Cycle Management including activities such as data modelling, ETL design and deployment, plus identifying functionality gaps to define an application development roadmap.

The DWH owns the solutions and is expected to become the SME and advise the business on new projects and integrations. The role supports the operations team to troubleshoot the applications and make sure they remain stable and available.

Responsibilities

Application Life Cycle Management:
  • Develop and maintain an application feature roadmap for various Australian business data warehouses.
  • Own and maintain governance of energy market management systems, deploying new versions and evolving integration with business systems.
Business Operations:
  • Develop and troubleshoot ETL Processes, data warehouse applications and PowerBI reports within IT department.
  • Responsible for the proactive maintenance of IT and Business Applications, new versions rollouts following software development best practices and identifying system integration risks.
  • Ensure code governance and version control across application releases.
  • Oversight internal teams and support vendors, spreading best practices to the different teams.
Business Workflow:
  • Ability to make partnerships and collaborate with internal teams and external vendors to facilitate technology led data solutions.
  • Document, analyse and support data models and reporting of metrics throughout the organization.
  • Coordinate with domain experts and DBAs to develop and refine data management best practices, policies, and procedures that aligns with industry standard.
Backend Monitoring:
  • Review Monthly Reports on Azure vulnerabilities, follow up fixes and monitor cloud consumption limits.
  • Ability to advise appropriate methods to be followed to mitigate any foreseen risks within on-prem and Azure environments.
Essential Experience Required:
  • Develop complex SQL queries and the ability to optimize them.
  • Building and troubleshooting complex Microsoft SSIS and Azure Data Factories for data ingestion and integration.
  • Building and optimizing Microsoft SSAS tabular models.
  • Building and deploying PowerBI Reports via PowerBI Apps.
  • Code Version Control using GIT via Azure DevOps Repos.
  • Relevant experience in API development preferably using Azure Cloud solutions such as Azure Functions and APIM.
  • Proficiency in deploying Azure Data solutions. Any Microsoft Data Certifications are a plus.
  • Experience migrating batch systems into API interactions.
  • Understanding Information management including data lifecycle management, data modeling and data integration.
  • Build Business Intelligence functional designs.
On Offer:
  • Competitive salary + upto 18% STI
  • Workplace flexibility
  • An impressive office space located between Circular Quay and Wynyard station
If you are interested in this opportunity, please "APPLY" for the role and submit a copy of your CV. Please take time to fill in the selection criteria as part of your application and please understand that ONLY shortlisted candidates will be contacted for discussion regarding their application responses but please rest assured, your application will be considered and assessed by a real person.

Get similar jobs like these by email

By submitting your details you agree to our T&C's