Database Specialist - (SQL & Python)

Database Developer (SQL & Python) – Infrastructure Platform

Location: ASB C:Drive, Albany, Tāmaki Makaurau Auckland

Mō Mātou | About us

At ASB, we’re more than a bank, we’re a purpose-led organisation helping people, communities, and our environment thrive together. With a proud history and a clear vision to support New Zealanders in getting one step ahead, our work is guided by the values of Courage, Care, and Curiosity. We’re bold in challenging the status quo, we genuinely care about those we work with and serve, and we’re always exploring new ideas to improve how we work.

As one of Aotearoa’s most trusted banking partners, we offer the scale and stability of a large organisation, while recognising and valuing each person’s contribution. Your ideas, growth, and impact matter here and you’ll be supported to do meaningful work every day.

Mō te Tūranga | About the role

This role sits within a team responsible for building and maintaining database solutions that support core data processes. As a Database Developer, you will focus on SQL Server development, supported by Python scripting and workflow automation. The work includes developing reliable database structures, improving performance, and supporting integrations with internal and external data sources.

You will spend most of your time working on SQL Server and Python-based solutions, including API-driven data extraction and automated workflows. The role involves hands-on development, operational support, and collaboration with others working across data, engineering, and delivery teams. The emphasis is on building solutions that are robust, well maintained, and fit for purpose.

Key Responsibilities

• Develop, optimise, and maintain complex TSQL queries, stored procedures, views, and functions
• Design and maintain SQL Server database structures, schemas, and indexes
• Perform performance tuning, troubleshooting, and optimisation of SQL workloads
• Support system integrations and backend data flows that rely on SQL Server
• Maintain and improve existing SQL Server environments, schedules, and operational jobs
• Build Python scripts for data processing, transformation, validation, and automation
• Develop API-based data extraction scripts using REST and JSON endpoints
• Create reusable Python modules to support consistent and reliable data ingestion
• Develop and maintain Airflow DAGs to orchestrate SQL and Python workflows
• Automate recurring data processes, reporting tasks, and ingestion pipelines
• Implement monitoring and alerting to support workflow health and timely execution

Ō Pūkenga | About you

You are an experienced database developer who is comfortable working deeply in SQL Server and confident using Python to support data processing and automation. You have practical experience building and maintaining database solutions in production environments and understand the importance of performance, reliability, and clear structure.

You work in a methodical way, paying close attention to detail and code quality. You can work independently on defined problems, while also contributing clearly and constructively when working with others. You are comfortable operating in an Agile or DevOps environment and understand how your work fits into wider systems and delivery outcomes.

We’re Looking For Someone With

• At least 5 years of hands-on experience in a Database Developer or similar role
• Strong experience with SQL Server, SQL, and TSQL development
• Proven experience with database performance tuning and optimisation
• Practical Python experience, including scripting, automation, and API integration using REST and JSON
• Understanding of ETL and ELT concepts and backend data processing
• Experience working in Agile or DevOps delivery environments
• Experience with Apache Airflow or similar orchestration tools, preferred
• Exposure to cloud data platforms such as Azure, AWS, or GCP, preferred
• Familiarity with Git-based source control and CI/CD practices
• Understanding of relational data modelling and database architecture
• Strong analytical and problem-solving skills
• Clear communication skills and the ability to work effectively with others
• High attention to detail and a focus on maintainable, reliable code

Te mahi ki ASB | Working for ASB

ASB's sense of who we are and what we stand for is grounded in our values. They guide our business in our day-to-day interactions with our team, customers and community. They are what makes ASB, ASB.

• Career Growth: Access to learning and development through training sessions, courses, and internal opportunities
• Inclusive Culture: Join values-led teams that celebrate diversity and support employee-led communities
• Health & Wellbeing: Southern Cross Wellbeing One health insurance, lifestyle and volunteering leave, and mental wellbeing support
• Meaningful Benefits: Enjoy discounted banking, insurance, and a generous parental leave top-up
• Impactful Work: Be part of a purpose-led organisation that makes a difference for New Zealanders

Ready to shape the future of technology at ASB?

If you’re passionate about creating exceptional customer experiences and want to make a real impact, we’d love to hear from you. Apply now and help us build the next generation of payment solutions for New Zealanders.