ETL/BI Developer

All vacancies of AustraliaInformation & Communication TechnologyETL/BI Developer

Immediate Start! ETL/BI Developers! Govt Dept! Canberra!

Summary about this job

Developers/Programmers

Company: MTP Services

Location: ACT

Work type: Contract/Temp

Salary: n\a

Phone: +61-8-8969-2203

Fax: +61-7-3331-2905

E-mail: n\a

Site:

Detail information about job ETL/BI Developer. Terms and conditions vacancy

MTP Services is currently seeking to engage an ETL/BI Developer for our Government client in Canberra. 

The successful candidate should have a keen interest in data with strong proficiency in SQL, Power BI and Excel and has experience in data systems, data visualisation and reporting. Business analysis experience and/or the ability to fit into a broader overall systems ICT related projects will also be highly considered. You must be able to critically analyse and link data to program requirements, investigating and challenging ideas when encountered.

Contract

3 month contract + possible 9 month extension
  
Overview  
This is a technical role where the successful candidate will need to have a keen interest in data with strong technical proficiency in SQL, Power BI, Excel, ETL Tools and PowerShell. The candidate should also have experience in data analysis, consolidating data sources, scoping data projects and identifying opportunities for business improvement.
  
The candidate must be able to critically analyse and link data to program requirements, investigating and challenging ideas when encountered.
  
Role Description
In this role, as an ETL/BI Developer, you will need to have a keen interest in data with strong proficiency in technical tools such as SQL (including SSIS) and Power BI and experience in data system improvements, data visualisation and reporting. You must have experience in business analysis be able to critically analyse and link data to program requirements, investigating and challenging ideas when encountered.
  
You will engage with internal ICT areas including database administrators, ICT security and Data Management to build supportable solutions. The ability to engage effectively with a broad range of stakeholders is required as you will work with private companies, contractors, and consultants.
  
This is a highly agile role that will require you to be adaptable and be responsive to change. In return, you will have opportunities to challenge thinking and solutions in areas that make a direct contribution to process improvement. 
  
Key tasks may include
  • Be able to rapidly get an understanding of the business needs
  • Be able to build and document a SQL DB to hold reporting data
  • Build ETL processes to load data via PowerShell from legacy spreadsheets as a once off to the SQL DB
  • Build automated and ongoing ETL processes to load XML data from Smartforms to the SQL DB
  • Build tabular models for the SQL DB
  • Determine requirements for, and build Power BI reports for the business area to use for reporting and compliance using the tabular models
  • Train the Venture Capital business area on how to use tabular models so they can build their own Power BI reports
  • Document the technical solution in a detailed design
  • Facilitate the handover of the technical solution for support and maintenance
Desirable Skills and abilities
  • SQL Server: to build, document and maintain SQL databases
  • ETL Tool set: SSIS and SQL Task and ability to build tabular models
  • BI Tools: Power BI, Excel
  • PowerShell scripting
  • Use of VSTS for managing source code (Visual Studio Team Services)
  • Agile and waterfall methodologies highly regarded
  • Systems analysis and testing skills
  • Strategic thinking and creative problem solving skills
  • Strong team work, collaboration and negotiation skills
  • Experience in developing or delivering government policy
  • Excellent written and verbal communication skills
  
Security Clearance
To be eligible for this position, applicants must be Australian Citizens.  This position requires a Baseline security clearance. The successful applicant will be required to obtain and maintain a clearance at this level.
  
Role Due
Please send your updated CV to Dayne Lustri at [email protected] ASAP & prior to COB Thursday 28th June 2018.

Responds for ETL/BI Developer on FaceBook

Read all comments for ETL/BI Developer. Leave a respond ETL/BI Developer in social networks. ETL/BI Developer on Facebook, LinkedIn and Google+