DW/BI Developer
Opportunity
Stable and secure permanent full-time role with a competitive salary and benefits, flexibility, and access to professional development. Immediate start with a salary of $70k - $85k p.a plus Superannuation.
About Us
We are an IT consulting and services company focusing on Data Analysis, Data visualisation, Big Data and Cloud services based in Victoria.
Role Description
As a DW/BI Developer, you will be responsible for interpreting business specifications, technical designs, and building, maintaining, and modifying the code for BI applications using Microsoft Power BI stack, Tableau, PL SQL, Oracle, DBA, and Python programming.
Key Responsibilities:
Develop and deliver business intelligence solutions, including reports and visualisations by interpreting system designs and technical specifications.
Develop and automate key database functionalities in Oracle and SQL server based on the requirements.
Maintain ASM and RAC on Oracle 10g, 11g, and 12c versions and AWS cloud.
Ensure the integrity, accuracy, and quality of the data sets used to analyse and present data to the business.
Testing, debugging, and fixing errors in BI solutions using standard guidelines and ensuring the applications perform to specifications.
Provide training and assistance to users for the generation of ad hoc reports.
Design and implement technology best practices, guidelines, and repeatable operational processes.
Establish and maintain code to build new data models, along with the technical data modelling.
Research, consult, analyse, and evaluate BI application program needs.
Develop proof of concepts to optimise the data warehouse performance and processes.
Skills and Experience:
To meet the challenges of this role, you will ideally be bachelor's degree qualified and possess the following skills and experience:
5+ years of experience in DW/BI design and database development/administration.
Experience with Cloud platforms such as AWS, Azure, and GCP.
Experience with DevOps/Continuous Integration frameworks and configuration management tools such as Puppet (Chef, Salt, Docker also relevant).
Experience with automation and orchestration concepts/skills.
Infrastructure as Code: Terraform, ARM Templates, Cloud Formation, AWS CDK, Serverless Framework, and Pulumi.
Build/Release Tools: GitHub, Azure DevOps, Bitbucket, and TeamCity.
Databases: MS SQL, Cosmos, PostgreSQL, SQL, PL SQL.
Serverless: AWS Lambda, Azure Functions.
Containers: Docker, Kubernetes.
ITIL/ITSM certification and superior skills in critical thinking, prioritisation, and problem-solving.
Experience working with Tableau and Power BI tools.
Experience in supporting mission-critical applications in production environments.
Good knowledge in databases including on-prem (SQL Server and Oracle) and cloud-native (Azure, AWS, GCP, and Snowflake) query design and performance tuning.
Project Management capabilities (scrum, agile, and waterfall) and good communication skills.
Job Type: Full-time
Salary: $70,000.00 – $85,000.00 per year
Benefits:
Hybrid work environment
Schedule:
8 hour shift
Ability to commute/relocate:
Melbourne VIC: Reliably commute or planning to relocate before starting work (Preferred)
Work Authorisation:
Australia (Preferred)
Date Posted: 15 Oct 2024
Work Location: Hybrid remote in Ballarat, VIC 3350
#J-18808-Ljbffr