Data Analyst- SQL

**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

**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.