DWH / Transversal IT Analyst (Temporary)

April 1, 2024

DWH / Transversal IT Analyst (Temporary)


  • Contractor/ Via Agency
  • AU-NSW-Sydney
Apply for this job

Position Purpose

  • The role of IT Analyst sits within the Technical Analyst team which is part of the Information Technology division of BNP Paribas Securities Services (BP2S). 
  • The IT Analyst is responsible for the analysis, design and testing activities for all application changes. Analyst is also required to support the respective interfaces, reports and excel spreadsheets used as part of the end to end process.
  • In their role, the IT Analyst works with data warehouse (Microsoft SQL server), internal web applications and Microsoft Biztalk server (middleware). These technologies are used to support a diverse range of business functions including fund administration, pricing, middle office, custody, regulatory reporting etc. 
  • The team works within a matrix structure, delivering into projects that are managed across all platforms. They communicate with internal and external stakeholders (including business stakeholders in operations, product and coverage, vendors, consultants, suppliers and occasionally BP2S clients).

Key Responsibilities

  • Business Analysis
    – Working with the business or client to understand the full scope of the requirement, taking into account all upstream / downstream impacts relevant to the business process.
    – To act as a consulted party in reviewing Business Requirements, providing feedback where applicable;
  • Functional Design
    – Working with relevant project stakeholders to understand the project goals and help develop a solution that is consistent with current design, scalable and client agnostic;
    – Developing user story based functional design in-conjunction with the business, architects, developers and service delivery staff 
    – Complying with the company IT standards & guidelines in the functional design
  • Testing
    – Develop and/or support system test case creation
    – Conduct and/or support system test execution
    – Providing UAT and production implementation support
  • General
    – Appropriately applying the development and project management methodology
    – Providing realistic estimates and delivering within these estimates (time and budget)
    – Complying with audit and security requirements

Competencies (Technical / Behavioral)

  • Technical – must have
    • 5+ years technical business analysis experience 
    • Experience working in projects in the Financial Services Industry preferably with a custodian, fund administrator, software vendor or similar. 
    • Experience working with data, data warehouse and writing SQL queries; some level of ability to read SQL procedures desired.
    • Experience mapping and documenting data flows between systems.
    • Agile experience would be preferred including use of any ALM tool would be of an advantage (QC, TFS, Jira)
  • Technical – desired 
    • Exposure to investment administration applications (e.g. HiPortfolio, Simcorp, Multifonds), unit pricing application (e.g. pControl) or similar. 
  • Behavioral
    • Analysis and problem solving: gathers and analyses information and uses it to develop effective solutions to difficult problems or situations
    • Drive for results: Continually focuses on achieving positive, concrete results contributing to BP2S’ business success
    • Collaboration and team work: Develops and maintains a good working relationship with others. Provide support to other team members and seeks the same from others.
    • Communication: Write, speak and present information effectively, relevantly and in a timely fashion
    • Innovation: Develop and implement original ideas, approaches and solutions to typical, unusual or difficult situations or problems
    • Negotiation & conflict resolution: Negotiates or mediates sound agreements in situations where there is disagreement or differences in interests
    • Strategic thinking: Understands the business, and anticipates business needs, reflecting this in the approach to current solutions

Specific Qualifications Required

  • Degree qualified in IT, Business, or related discipline; and / or relevant work experience in a similar role.


As the leading European Union bank, and one of the world’s largest financial institutions with an uninterrupted presence in the region since 1860, BNP Paribas offers a wide range of financial services for corporate, institutional and private investors spanning corporate and institutional banking, wealth management, asset management and insurance. 

We passionately embrace diversity and are committed to fostering an inclusive workplace where all employees are valued and encourage applicants of all backgrounds, including diversity of origin, age, gender, sexual orientation, gender identity, religion applicants who may be living with a disability. We have a number of internal employee networks in place to empower our staff to act and challenge the status quo.

•    BNP Paribas PRIDE is highly active in favour of the LGBTQIA+ community
•    BNP Paribas MixCity which fosters better representation of women at all levels of the organization
•    Ability, the mutual aid network for employees with a disability or a disabling or chronic illness
•    BNP Paribas CulturAll which celebrates diverse backgrounds

BNP is committed to financing a carbon-neutral economy by 2050. The Group is a founding member of the Net-Zero Banking Alliance and has set up its own Low Carbon Transition Group to support its clients through their energy transitions.


More information 
BNP Paribas – Diversity & Inclusion Journey
BNP Paribas – The Bank Of Green Changes

Offers you may be interested in