Do you want to be part of using the business of banking as a force for good? Do you want to create positive impact for people and the planet? Bank Australia is the bank for people who want to be part of a movement creating a fairer and more just world.

We’re growing fast as more people choose to align their banking with their values. We’re a customer owned, B Corp certified bank. We empower our staff and 185,000+ customers to be part of the clean money movement.

We currently have a two year, fixed term full-time opportunity for a BI Data Engineer to join our professional and highly engaged Data Analytics & Insights department within our growing Transformation division. This role will be based our Collingwood Head Office and will report to the Manager Data Engineering.

The BI Data Engineer will be responsible for expanding and optimising our data and data pipeline architecture, as well as optimising data flow and collection for cross functional teams. This role will deliver the bank’s data program of works through application of SQL database interrogation extracts and data transformation to a Microsoft BI stack for presentation and visualisations to an on premise Power BI System.

Why join us

• We have big plans to become Australia’s most trusted bank and a leading purpose-driven business.
• As a certified B Corp, we’re part of a global business community who meet the highest social and environmental standards, putting purpose over profit.
• Every role and person in our bank is essential to bringing our values, purpose and aspiration to life.
• We offer flexible working options, competitive salary and 13% super.
• Our staff have access to a range of meaningful benefits to support their physical and mental wellbeing including 24/7 free counselling, free flu vaccinations and discounted gym memberships.
• We also support staff with study assistance, paid parental leave (regardless of gender), volunteer, bereavement, gender affirmation and family violence leave; and the opportunity for bonus annual leave.
• We support our staff to grow their careers through learning and development and an organisational culture where we reward and recognise innovation and values, not long hours.
• We are committed to building an inclusive culture and a diverse workforce that reflects the Australian community.
• We care for a conservation reserve – where we work with key partner organisations to protect threatened species and involve staff in conservation.

What you will be doing

• Delivery of core data source extracts (MS SQL SSIS/SSAS) for data visualisations (Power BI) and/or other system use according to business requirements
• Collaborate with Technical Lead on infrastructure improvements that increase scalability and fault tolerance, while reducing data usage
• Create and maintain optimal data pipeline architecture
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Microsoft stack (MS SQL SSIS/SSAS) technologies
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Pro-actively work with business teams to capture, understand and refine business requirements regarding data and visualisations in line with a data program
• Drive standardised data design for the Implementation of SSRS and Power BI reports utilising Power BI Report Server on premise version
• Assist in the conversion and creation of business reports utilising various visualisation tools over new data architecture.

What you will bring

• Previous experience in delivering various Data Sources using MS SQL SSIS, PowerShell & Python scripts according to business requirements
• Previous experience in implementing internal process improvements such as automating manual processes, optimising data delivery
• Strong experience with index optimisation, table partition automation and database security
• An understanding of Temporal & In-Memory Tables, with exposure to Polybase
• A deep understanding of Data Warehouse concepts
• Working knowledge of message queuing, stream processing, Python/R language, and highly scalable ‘big data’ data stores
• Previous experience in a project to migrate databases to either AWS or Azure
• Experience within the banking/financial sector
• Proficiency in DAX & M languages for Power BI and be able to deliver a wide variety of Report Visualisations
• Experience in utilising Sybase Server databases
• Experience in business analysis, capturing requirements for data and reporting solutions and working with stakeholders to refine requirements
• Experience in Power BI in the Cloud / O365, Data Factory, Databricks and other Azure cloud base applications/tools
• Experience with creating reports & sub-reports using Tabular & Multidimensional SSAS Cubes
• Be able to benchmark report performance and monitor report reliability
• Understand design lifecycle & be able to maintain Frontend Security in conjunction with Database Security
• Tertiary qualification in Information Technology
• Appropriate certified courses relevant to Microsoft BI stack skills - desirable
• Commitment to Bank Australia’s purpose, aspiration, values and brand as well as the B Corp ethos.

By submitting an application you agree to Bank Australia’s Privacy Policy for applicants and confirm that you are legally able to work in Australia. Bank Australia is an equal opportunity employer committed to sustainable development. We encourage people from different backgrounds to apply, including Aboriginal and Torres Strait Islander people, people from different cultural backgrounds and people with disabilities because we want to reflect the diversity of our communities. We are committed to making reasonable adjustments to provide a positive, barrier-free recruitment process and supportive workplace.

Bank Australia reserves the right to withdraw this advertisement at any time. Candidates will be progressed as applications are received, rather than after the advertisement closure date. If you wish to be considered, please submit your application as soon as possible. Please note, the successful candidate will be subject to satisfactory background checks including but not limited to police and previous employment.