Job Category: Banking and Financial ServicesDo you want to be part of using the business of banking as a force for good? Do you want to create a 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 at 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.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 doingDelivery of core data source extracts (MS SQL SSIS/SSAS) for data visualisations (Power BI) and/or other system use according to business requirementsCollaborate with Technical Lead on infrastructure improvements that increase scalability and fault tolerance, while reducing data usageCreate and maintain optimal data pipeline architectureIdentify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalabilityBuild 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) technologiesBuild processes supporting data transformation, data structures, metadata, dependency and workload managementPro-actively work with business teams to capture, understand and refine business requirements regarding data and visualisations in line with a data programDrive standardised data design for the Implementation of SSRS and Power BI reports utilising Power BI Report Server on-premise versionAssist in the conversion and creation of business reports utilising various visualisation tools over new data architecture.What you will bringPrevious experience in delivering various Data Sources using MS SQL SSIS, PowerShell & Python scripts according to business requirementsPrevious experience in implementing internal process improvements such as automating manual processes, optimising data deliveryStrong experience with index optimisation, table partition automation and database securityAn understanding of Temporal & In-Memory Tables, with exposure to PolybaseA deep understanding of Data Warehouse conceptsWorking knowledge of message queuing, stream processing, Python/R language, and highly scalable ‘big data’ data storesPrevious experience in a project to migrate databases to either AWS or AzureExperience within the banking/financial sectorProficiency in DAX & M languages for Power BI and be able to deliver a wide variety of Report VisualisationsExperience in business analysis, capturing requirements for data and reporting solutions and working with stakeholders to refine requirementsExperience in Power BI in the Cloud / O365, Data Factory, Databricks and other Azure cloud base applications/toolsExperience with creating reports & sub-reports using Tabular & Multidimensional SSAS CubesBe able to benchmark report performance and monitor report reliabilityUnderstand design lifecycle & be able to maintain Frontend Security in conjunction with Database SecurityTertiary qualification in Information TechnologyAppropriate certified courses relevant to Microsoft BI stack skills - desirableCommitment 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.
#J-18808-Ljbffr