DW/BI Developer
Opportunity
Stable and secure permanent full-time role Competitive salary and benefits Flexibility + access to professional development Immediate start $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 to interpret business specifications, technical designs and build, maintain and modify the code for BI applications using Microsoft Power BI stack, Tableau, PL SQL, Oracle, DBA and Python programming.
Key Responsibilities:
As a DW/BI Developer, you will support the project to:

• 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 for the business 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 solution using standard guidelines and ensuring the applications perform to the 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.
• Experience with Cloud platforms such as: AWS, Azure and GCP
• Experience with Dev Ops / Continuous Integration frameworks with configuration management tools such as Puppet (Chef, Salt, Docker also relevant).
• Experienced with automation and orchestration concepts/skills
• Infrastructure as Code: Terraform, ARM Templates, Cloud Formation, AWS CDK, Serverless Framework and Pulumi
• Build / Release Tools: Git Hub, Azure Dev Ops, Bitbucket and Team City
• Databases: MS SQL, Cosmos, Postgre SQL, SQl, PL SQL
• Serverless: AWS Lambda, Azure Functions
• Containers: Docker, Kubernetes
• Must have ITIL/ITSM certification. Defect/incident handling and triage skills. 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

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
Job Type: Full-time
Pay: $70,000.00 – $85,000.00 per year
Schedule:

• 8 hour shift

Work Location: Hybrid remote in Ballarat, VIC 3350
Application Deadline: 23/06/2024