Data Modeller

Firstrand Bank India; Johannesburg; On-site; ZAR 800,000 - 1,100,000; Full time

Job summary

FirstRand Bank India seeks a senior Data Modeller to execute modelling standards and design end-to-end data models across banking domains. You will work with relational, dimensional and NoSQL databases to support payment systems, settlements and reconciliations.

You will develop conceptual, logical and physical models, adopt enterprise standards, and deliver test scripts and reports. Collaboration with stakeholders across business units is essential.

Qualifications

• Minimum 4 - 5 years' experience in a data environment with hands-on relational, dimensional and analytic experience.
• Experience with data warehouse, data lake and enterprise big data platforms in multi-data-center contexts.
• Proven experience in modeling end-to-end payment lifecycles, including clearing, settlement and reconciliation processes (e.g. Swift, ISO20022).
• Knowledge of logical data modelling, and use of industry data models (e.g. IBM, Teradata, etc.).
• Knowledge of dimensional data modelling using Kimball methodology.
• Understanding of the Inmon methodology.
• Developing data models in a banking environment with specific focus on payment systems.
• Understanding and experience in implementing data management domains and technologies (e.g. data modelling, metadata management, data quality and profiling, information architecture, etc.).
• #Post
• #FNB
• #LI-BL1

Responsibilities

• Execute data modelling standards, principles, frameworks and tools within area of accountability.
• Design and develop logical and physical data models and databases to meet business requirements.
• Develop and maintain conceptual, logical and physical data models.
• Identify and adopt an enterprise data model as a standard for designs.
• Monitor, measure and report data modelling quality levels.
• Amend data model designs as business processes change.
• Perform reverse engineering of physical data models from existing databases and SQL scripts.
• Ensure coverage of entities to respond to business requirements.
• Develop and manage stakeholder relations to promote data modelling awareness.
• Deliver test scripts for data models and supporting documents.
• Develop reports pertaining to data modelling and related activities.
• Drive automation of data modelling management processes.

Skills

Relational databases

Dimensional modelling

NoSQL

Kimball methodology

Inmon methodology

Payment lifecycles

Tools

SQL

Data warehouse

Teradata

IBM data models

Job description

To provide expertise, advice and support by executing data modelling standards, principles, frameworks and tools within area of accountability; under guidance and supervision designing and developing of logical and physical data models and databases to meet the needs of the organisation's information systems and business requirements; and coordinate and priorities data modelling within business area.

Design and implement data modelling solutions which include, but are not limited to, the use of relational, dimensional and NoSQL databases

Develop and maintain conceptual, logical and physical data models as required by the SARB business units and their various projects and business-as-usual operations

Identify and adopt an enterprise data model as a standard for data model designs to leverage best practice and fast-track modelling efforts.

Monitor, measure and report the data modelling and data development quality levels to ensure the correct entities and objects are captured as per business requirements.

Amend data model designs as well as update data entities and objects emanating from business process changes.

Perform the reverse engineering of physical data models from existing databases and SQL scripts.

Ensure that the coverage of entities necessary to respond to the business requirement is accounted for in the data models.

Develop and manage stakeholder relations effectively to promote data modelling awareness across the organisation and support reliable decision-making.

Deliver test scripts for the data models and see the data models through implementation.

Deliver all the necessary supporting documents relating to data modelling.

Develop reports pertaining to data modelling and associated activities.

Drive the automation of data modelling management processes and functions.

Qualifications and Experience

Minimum 4 - 5 years' experience in a data environment with hands-on relational, dimensional and analytic experience

Experience with data warehouse, data lake and enterprise big data platforms in multi-data-center contexts required.

Proven experience in modeling end-to-end payment lifecycles, including clearing, settlement and reconciliation processes (e.g. Swift, ISO20022).

Knowledge of logical data modelling, and use of industry data models (e.g. IBM, Teradata, etc.).

Knowledge of dimensional data modelling using Kimball methodology.

Understanding of the Inmon methodology.

Developing data models in a banking environment with specific focus on payment systems.

Understanding and experience in implementing data management domains and technologies (e.g. data modelling, metadata management, data quality and profiling, information architecture, etc.).

#Post

#FNB

#LI-BL1

All appointments will be made in line with FirstRand Group’s Employment Equity plan. The Bank supports the recruitment and advancement of individuals with disabilities. In order for us to fulfill this purpose, candidates can disclose their disability information on a voluntary basis. The Bank will keep this information confidential unless we are required by law to disclose this information to other parties.

FirstRand Bank India is a Mumbai-based licensed financial services provider, offering comprehensive banking solutions for clients engaged in the Indo-African corridor since 2009.

Banking Credit Intermediation Financial Services

Company size 51–200 employees

Company type Privately held Founded 2008

Total funding 0

Momentum

Team growth

Momentum

12% in 12 mo

57 employees on LinkedIn

Jan 23 Jan 26

Employee experience

What it’s like inside

4.0

41 reviews

97% would recommend

Culture & values

Culture & values 4.2

Work-life balance

Work-life balance 3.8

Career opportunities

Career opportunities 4.1

Compensation & benefits

Compensation & benefits 4.2

Capital

Funding history

Footprint

Where they work

101, 103A and First floor 103B First International Financial Centre C-54 and C-55, G Block, Near CBI office Bandra-Kurla complex, Bandra (east), Mumbai, 400051, IN

Apply For This Role

Company FirstRand Bank India

Location Johannesburg, Gauteng, South Africa