Data Warehouse Developer | MS SQL & Power BI

Job Title: Data Warehouse Developer | MS SQL & Power BI
Contract Type: Contract
Location: Sydney
Reference: 763247
Job Published: July 23, 2021 10:45

Job Description

As Data Warehouse Developer your new role will involve a 50:50 blend of BAU activities and Evolving Existing Systems. Broadly, this role will be responsible for data modeling, reporting and business operations. The ideal candidate must have the flexibility to adapt to changing priorities, business, and organizational needs. The ability to operate independently in a fast-paced, small but growing environment and work proactively with various teams across the organization.

As a Data Warehouse Developer, your main responsibility is to support and manage the Data pipelines (ETL processes) both in on-prem and cloud environments. The data pipelines are critical for core business functions. This role will be responsible to develop and maintain data flows from operational data of industrial data assets into Operational DWH and business reporting data (such as Generation and consumption data) into Business DWH solutions. 
Someone with experience of working in large datasets will be well looked upon favorably. 

BAU 50% – Data Analysis & Backend Monitoring
Evolving Systems 50% – Business Operations & Business Workflow.  
Core Skills:
  • Develop complex Microsoft SQL queries, and have the ability to optimize them.
  • Building and troubleshooting complex Microsoft SSIS packages for data ingestion and integration – The organization has 50+ packages that are being evolved at the moment.
  • Building and optimizing Microsoft SSAS tabular models – These Cubes hold critical data for their customers, you will not be building these Cubes from scratch but you will be maintaining them.
  • Building and deploying PowerBI Reports via PowerBI Apps – They have been using Power BI for 4-5yrs and are very mature with this platform. You will be troubleshooting issues with data in Power BI, and will troubleshoot questions from the business in Power BI.
  • Code Version Control using GIT via Azure DevOps Repos – They control code using GIT, you do not need experience with Azure but should know GIT as a source control language and how to interact with it.   
On Offer:  
  • 5-month contract
  • Competitive daily rate
  • Workplace flexibility
  • Potential for a permanent position  
  • 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.