DWH Business Analyst | NSW - Sydney

Job reference number: ALL/1265555/EXT

When you work at Allianz, you’re part of a strong global insurer, helping to protect over 3 million Australians. You’ll have opportunities to grow and drive your career your way, work with people from all different backgrounds, and feel free to bring fresh thinking. And you’ll get the support you need to have an enriching career and enjoy what really matters to you.

Data Warehouse Business Analyst - Sydney - Permanent

As our Data Warehouse Business Analyst, your role will be to provide the key interface between the Workers Compensation Data Warehouse team, other technical teams and business analysts. You will produce source to target data mapping documents and profile data as input to source to target transformation rules. This role will also see you be involved with business design of new and existing reporting and application enhancements and serve as a technical resource to determine the specific data required in the design of custom reporting utilising the current data sources and tools available.

Key Responsibilities in the role also include:

  • Developing common information models, including data definitions and transformations
  • Understanding and development of data dictionaries and terminologies
  • Mapping of data from sources to target to reports
  • Data profiling
  • Data and information modelling and usage of associated notations and tools
  • Testing of data-related solution components, including data migration;
  • Providing documentation to a high standard, such as data definitions, data descriptions and interface definitions;
  • Analysis of data using a variety of tools and techniques
  • Research and troubleshooting of issues relating to data
  • Support of the ETL Developers in resolving design issues during implementation to identify Risks and Issues with existing data
  • Must be flexible and willing to undertake a wide variety of tasks

It is expected that you will have the following experience and knowledge:

  • 5+ years experience in a Business Analyst role (including 3+ years in a Data Warehouse development/enhancement/support environment)
  • Data integration concepts and extract, transform and load (ETL) tools, especially Informatica PowerCentre (desirable)
  • Informational/Reporting Delivery tools, especially Cognos (desirable)
  • Advanced level of skills in using Excel / SQL
  • Sound knowledge of Object Orientated applications (desirable)

Come and work at a place where you matter.
Explore all our opportunities now at www.allianz.com.au/careers

Search Tips