Westpac Group Hiring for Data Analyst- SQL Job at Sydney Full Time

• Data Analyst- SQL
  
• Data Platforms
  
• Sydney Based, Permanent Role
  

How will I help?

We have an exciting opportunity for someone who is energetic and self driven to join the Data Intelligence &nAnalytics Group – Discovery team. The Data Intelligence & Analytics Group provides services to the broader Westpac Group and our vision is to be a source of competitive advantage through actionable information, insight, and advice.

The role is responsible for partnering with the wider business to deliver Data assets and analysis that will enable Dashboard development and Analysts to utilise consistent definitions across brands and portfolios.

In performing this role, you will be highly proficient in SQL (must), and it would be advantageous if you have base SAS experience. This will be supplemented with the required business skills to succeed (stakeholder mgmt., problem solving and analysis).

What you will do

• Maintain robust knowledge of the data environment(s), providing advice regarding each domain.
• Liaise with stakeholders, complete the design, development, and testing of components with the goal of providing reliable, stable, and operationally sound data assets that meet business requirements
• Using the data warehouse and database management software to conduct complex database queries together with reviewing other data sources to identify trends and predict patterns (as applicable to the business problem)
• Adhere to ETL processes and standards, and contribute to development of best practices involving but not limited to code reviews and performance optimisation
• Evaluate and undertake impact analysis, assess and manage associated risks
• Ensure data assets are developed with consistent maintainable code which supports risk and compliance management
• Able to understand conceptual models and translate into logical and physical data models
• Adhere to team-based standards for tools, techniques, and methods, including security guidelines, alignment to enterprise architecture, adoption of platforms and systems and ensuring that they are applied effectively
• Consistent use of, and adherence to, operational policies, standards, patterns, tools, and processes to ensure consistent application maintenance and fulfilment of regulatory obligations

What’s in it for me?

Joining Westpac has many benefits besides building a long and stable career. You’ll be able to purchase leave to facilitate your dreams or obligations and you’ll be encouraged to participate in the community through paid volunteer leave and secondments. You’ll also be entitled to a suite of online learning, training modules and career planning tools to grow with us.

What do I need?

• • Minimum 3 years of experience as an Data Analyst
  • Technical expertise working with SQL including Macros, Stored Procedures, Triggers and Functions and work with integrated data marts
  • Integrate and merge multiple data sources/environments.
  • Analysis, problem solving, troubleshooting and consultative skills
  • Experience providing quality review of code and leading quality control initiatives
  • Excellent verbal and written communication skills using an open, clear, and engaging manner combined with the ability to relate on all levels through the organisation
  • Working and conceptual knowledge of building and maintaining physical and logical data models
  • Tertiary level qualifications in Computer Science or relevant industry recognised certification
  • Teradata SQL
  • Knowledge of SAS (Base/DI)
  • Python/R
  • Experience with Business Intelligence tools such as Qlik / Power BI / Tableau
  • Exposure to Big Data technologies including Hadoop, Spark, Hive (AWS/GDP/Azure)
  • Prior experience with Banking or Finance Services industry

What is it like to work in Westpac?

We aim to provide one big, supportive team to help us reach our vision to become one of the world’s great service companies. Working with us you’ll discover new ways of working, and an exciting range of roles to showcase your skills. As an equal opportunity employer, we’re proud to have created a culture where people can be their best, in an environment that values diversity and flexibility. And one where everyone belongs.

How do I Apply?

Start here. Just click on the APPLY button.

As part of our commitment to creating a diverse and inclusive workplace, this role is open to experienced candidates seeking a discussion around workplace flexibility. We invite candidates of all ages, people with a disability and Indigenous Australians to apply. The health and wellbeing of our employees is our top priority. We’ve developed clear standards to ensure our people are confident, safe and healthy whether they’re working from a Westpac Group site or working from home. These are based on expert medical advice and Safe Work Australia guidelines.

The Westpac Group has implemented an Entry to Workplace Policy that requires employees and others entering our workplaces to be fully vaccinated against COVID-19 by relevant dates set out in the policy (subject to applicable medical exemptions). Our employees are required to comply with the policy regardless of whether they are in customer-facing or non-customer-facing roles (as employees in non-customer-facing roles are required to attend the workplace under our Hybrid Working Strategy). Further, the Westpac Group is required to comply with State/Territory issued public health orders/directions which require relevant workers to be vaccinated against COVID-19 to enter workplaces.

By applying for this role, you acknowledge that you are aware of our Entry to Workplace Policy, and if you secure employment with us, you will be required to comply with the policy.