Westpac
Engineer - Data/ETL
To become number one for customer service
Software engineering
Full-time
Office | Sydney, NSW, Australia
Visa sponsorship · No
Mid Level · A role for someone with some well-developed knowledge and skills they can bring to the role and team. Typically within 2-5 years of experience.
·
Why Westpac
Westpac is Australia’s oldest bank and company, one of four major banking organisations in Australia and one of the largest banks in New Zealand. We provide a broad range of banking and financial services in these markets, including consumer, business and institutional banking and wealth management services.
About the role
How will I help? You will be part of our Group Technology, Wealth Technology, Digital & Innovation Team operates under the Westpac Group Business Division. The Business Technology team is accountable for the delivery and management of all technology services and solutions required by the Business divisions. This includes project delivery, application development & maintenance and technology thought leadership.
You will be performing migration activities using the ETL tools, participate in multiple workshops to understand the structure of the data and how that will work in the new system. Understand the source and destination applications and how the migration will fit into the new system and identify challenges of the program.
What’s in it for me? You’ll play a significant part of the future of a business that has been around for over 200 years. Our purpose is to create better futures together. So, we’ll back you in the development of your career, internal career prospects, and flexible working. You’ll also keep learning to grow your career, backed by a fantastic team of people with a can-do, supportive structure. Whatever shape your family takes, we offer generous paid and unpaid parental leave for your nominated primary and support carers. This includes leave to organise adoptions, surrogacy, and foster care arrangements. And we continue to pay your super contributions while you take all the time you need to get your new family settled.
What do I need? To be successful for this position you should have experience in the ETL tools as this program is highly focussing on data migration. Experience in client requirement Analysis, Physical, Logical design, development, debugging, testing, deployment, support and maintenance of business applications is essential for this position, and you should have strong knowledge in implementing backup/ restoration, crash recovery and disaster recovery strategies and have previously designed and implemented the regular procedure for backups as per best practice. As well as this you will be experienced in proactive monitoring and troubleshooting using monitoring tools and should have strong knowledge in database architecture, performance tuning, query tuning & optimization, database tuning techniques using monitoring tools.
What you'll be responsible for
- 🔀
Data Pipelines
Develop and maintain processes for the extraction, flow, and transformation of data
- 🔲
SQL and Databases
Use SQL to query databases to extract and process data
- 🤖
Scripting and Automation
Develop scripts and automated workflows to improve the efficiency and accuracy of repeated tasks
Skills you'll need
- 👥
Collaboration
Works with others by being open, clear in communication and listening to achieve goals
- 🧮
Numerical problem solving
Works with numerical information and performs mathematical calculations to solve problems
- 🔍
Attention to detail
Accurately identifies and rectifies discrepancies or errors that exists in information and deliverables
Meet the team
Provides Technical Leadership to a group of IT Developers and Support Analysts, with accountabilities mentioned below. It will attract someone with a keen interest in data and integration, who loves complex technical, data and business problems; and with a passion for supporting and mentoring junior technologists.