Job Description Fixed term contract Hybrid work - blend of work from home and in the office Brand new circular quay offices Established in 1988, Rest is one of Australia’s largest profit-to-member superannuation funds. We support nearly two million members, with around $86 billion of funds under management and are recognised as a responsible investment leader*. We believe when members understand and engage with their super, they’re more likely to get a better retirement outcome. Everything we do at Rest is underpinned by our values and behaviours, we want to Be Daring, Keep it Simple, Take Action and Have Grit. To put it simply we want our people to thrive and love the work they do. The Test Lead will work within the Rest DTD, Quality Assurance team to provide a range of testing services to ensure the successful release and deployment of software to the wider Rest business. This role exists to ensure the quality and reliability of software by leading the planning, execution, and management of testing activities within Agile & waterfall projects. This role is crucial in identifying and mitigating risks early, ensuring that defects are promptly addressed, and contributing to the delivery of high-quality software that meets business and user needs. Key Accountabilities/Responsibilities Exposure to Data Warehouse Testing Should be familiar with ingestion, Conformed / Transformed Layers, Models and Reporting layer testing Hands-on experience with testing different transformation patterns in Data warehouse like SCD – Slowly changing Dimension, CDC- Change data capture, business temporal pattern, dimensions and measures. Should be able to interpret Source to Target mapping document and convert them to required testing queries Understanding of different Data Quality Dimensions and implementing as part of test coverage Strong SQL skills and technical analysis especially to interpret data transformations. Exposure to Snowflake or similar data warehouse tool Hands-on experience with DBT – Data Build Tool or other similar ETL tool Data Test Automation experience – Experience with prior test automation framework on data warehouse space and CI/CD integration for data platforms Strong expertise in SQL, Python, and data testing framework (Great Expectations, dbt test) Expected to adopt given framework and build required test scripts using both standard and local project libraries. Python scripting experience is must with exposure to pytest and pandas libraries. Familiar with Code versioning tool, preferably Git, handling PR reviews and other best practise around version control and maintenance of source code repositories. Technical comprehension of application ecosystems, including various integrations, data flow, and access control Ability to manage test data and environments for multiple streams of delivery work Knowledge of data security and privacy best practices and testing approaches Exposure to AWS cloud resources is preferrable