Perpetual Group is an ASX-listed company (ASX:PPT) headquartered in Sydney, Australia, currently consisting of 11 leading brands across three distinct businesses: Asset Management, Wealth Management and Corporate Trust.
Following the completion of a comprehensive Strategic Review in May 2024, it was announced that Perpetual Limited will become a standalone Asset Management business, and has entered into an agreement with an affiliate of Kohlberg Kravis Roberts (KKR) who will acquire the Corporate Trust and Wealth Management businesses.
About the role
An exciting opportunity to be part Perpetual Corporate Trust’s innovation company, Perpetual Digital as a Senior Engineer/Tech Lead (Backend). As a Senior Engineer/Tech Lead, your mission is to design, develop, and maintain robust database systems that support the company's data needs. You will ensure data integrity, performance, and security while working closely with cross-functional teams to deliver efficient, scalable, and high-performance backend solutions. Your role is crucial in optimizing database queries, managing data structures, and supporting data-driven applications to drive business success.
Perpetual Digital is responsible for the design and build of software products, platform services and infrastructure across a variety of cloud technologies supporting the banking and finance industry. Perpetual Digital is Perpetual Corporate Trust’s innovation company, leveraging more than 20 years of experience and a market leading position in Australian securitisation to deliver solutions to this sector.
If you have a proven hands on delivery experience and looking to be part of an exciting initiative delivering a product that is used and loved by small and large financial institutions, then this role might be for you!
* System Design and Architecture: Collaborating with stakeholders to design and implement scalable and efficient data processing systems and architectures that meet the organization's needs. Help to design and implement database schemas, tables, indexes, and views to meet application requirements where needed.
* Data Pipeline Development: Building and maintaining robust and scalable data pipelines to efficiently collect, transform, and load data from various sources into data storage and analytics platforms.
* Data Integration: Ensuring seamless integration of data from different sources and systems, ensuring data quality, consistency, and reliability.
* Data Transformation and Modelling: Developing and implementing data transformation and modelling techniques to optimize data for analysis and reporting especially PowerBI.
* Database Development and Maintenance: Develop complex SQL queries, stored procedures, and functions to support various business processes and reporting needs.
* Performance Optimization: Identifying and resolving performance bottlenecks in data processing and storage systems to ensure optimal performance and efficiency. Optimize database performance through indexing, query optimization, and database tuning.
* Team Leadership and Mentoring: Leading a team of engineers, providing technical guidance, mentoring, and fostering a collaborative and innovative work environment. Continuously improving your skills and helping the team improve its processes Helping to drive the engineering rhythm and process of the team from planning, design, coding, deployment, through to support
* Technology Evaluation and Adoption: Evaluating new technologies, frameworks, and tools in the data engineering space to drive innovation and improve data processing capabilities.
* Monitoring and Troubleshooting: Implementing monitoring and alerting systems to proactively identify and resolve issues in data pipelines and systems.
* Documentation and Knowledge Sharing: Documenting data engineering processes, best practices, and knowledge sharing to ensure the transfer of knowledge within the team and organization. Document database structures, processes, and changes for future reference and knowledge sharing.
About you
* Tertiary qualification in Computer Science, Information Systems, or 7 - 8 years of relevant industry experience.
* 5+ years of Database Development experience (SQL Server) supporting mission-critical relational databases
* Strong experience in SQL query tunning, server optimisation and management
* Experience with Database design and capable of creating SQL objects such as SQL functions.
* Hands-on experience with full Microsoft database stack (SSDB, SSAS, SSIS, SSRS, ADF, Power BI, etc.)
* System testing, automated testing of database functions and test-data creation
* Ideal have Databricks, Apache Spark and strong Python skills
* Experience building & managing database-focussed environments in Microsoft Azure cloud.
* Experience with CICD and Azure DevOps: Build Pipelines, Release Pipelines, and deployments generally
* Proficient understanding of Git and code management tools
* Excellent written and verbal communication skills, with a demonstrated ability to document complex technical problems
* Basic knowledge of Banking and Financial Markets would additionally be greatly advantageous
* Any Securitisation experience
It would be great to also have but not required:
* C#, .NET Core, ASP.NET programming experience
* Basic understanding of Web application architecture
* Exposure to building/consuming APIs using .NET Core.
How we work
Our unique culture is underpinned by our three organisational behaviours, Stretch, Own it, Make an impact which drive our approach of day-to-day interactions with colleagues and clients; the way we approach decision-making to the questions we ask and the problems we solve.
Employee benefits
* Work from anywhere in Australia for up to one month each year
* An annual allowance to empower you to prioritise your personal wellbeing
* Access to LinkedIn learning, study support and commitment to supporting professional development
* We have partnered with Jawun for over 10 years supporting regional Indigenous organisations
Diversity and inclusion
* WGEA Employer of Choice for gender equality since 2018
* Strong commitment to all aspects of Diversity and Inclusion through a robust 7 pillar strategy
* A growing number of employee-led networks who work to raise awareness and drive continued change
* We support over 50 First Nations Communities, helping to secure the communities future. We encourage applications from Aboriginal and Torres Strait Islander People
We’re committed to creating an inclusive workplace where diversity is celebrated. No matter your background or circumstances, we aim to provide an environment where you can thrive.