Techno Functional Data Modelling - BA

Mployee.me; Mumbai; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Medical insurance

Job summary

Acies is seeking an experienced data engineering professional for a full‑time onsite role in Dubai with 5+ years in banking data, ETL, and regulatory reporting. The candidate will design Oracle SQL/PLSQL solutions, build data pipelines, and translate regulatory updates into technical data schemas.

You will lead data validation, reconciliation, and testing cycles with Risk and Compliance teams, ensuring accurate, auditable data flows across Capital, Credit, and Liquidity reporting.

Qualifications

• - Graduate/Postgraduate in Data Science/Data Engineering/Software Engineering/Computer Applications.
• - Banking domain knowledge and understanding of Credit Risk, Liquidity Risk, ALM modelling and reporting.
• - 5+ years of experience in data engineering and regulatory reporting within financial services.
• - Experience with ETL, data warehousing, and data lineage and validation.

Responsibilities

• Design, optimize, and maintain Oracle SQL/PLSQL for data transformation.
• Develop high‑performance ETL/batch frameworks moving data from Core Banking to risk databases.
• Translate regulatory manuals into technical schema and validation logic.
• Create source‑to‑target mappings ensuring end‑to‑end data lineage and auditability.
• Configure and validate regulatory logic inside banking platform engines.
• Perform data reconciliation and validation dry‑runs across forms and modules.
• Lead SIT, UAT, and post‑go‑live technical validation with Risk and Compliance teams.

Skills

Data warehousing

SQL

PL/SQL

ETL

Data modeling

Regulatory reporting

Risk management

Education

Graduate/Postgraduate in Data Science/Data Engineering/Software Engineering/Computer Applications

Tools

Oracle

Informatica

Talend

SSIS

Temenos/Finacle

Job description

Highlights of the role:

Nature of role:

Full time

Number of years of experience expected:

5+ years

Onsite

- Dubai

Areas of past experience preferred:

Data Mart Development / implementation, Data Warehousing (DWH), ETL Development (Informatica, Talend, SSIS), SQL / Advanced SQL Programming, Data Modeling (Star Schema, Snowflake Schema), SupTech projects,Database Design, Big Data, Regulatory Reporting projects, System Design & Architecture, Data Pipelines & Data Engineering, Batch & Real-time Processing, Performance Tuning (SQL, ETL jobs), Data Lineage, Data Mapping, Data Validation and Reconciliation, Regulatory and Risk Reporting systems, Technical Solution Design.

Educational qualification expected:

Graduate/ Postgraduate in Data Science/Data Engineering/Software Engineering/Computer Applications

Preferred Qualifications:

MBA (Finance/Business Analytics/Data Analytics)

Preferred Certifications:

SQL / Advanced Database Certifications, Data Engineering certifications, Big Data (Spark, Hadoop) Certifications, Informatica / Talend certifications, Oracle / Teradata certifications, Microsoft Data / Power BI certifications

Preferred geography of previous work experience:

UAE / India / Europe / APAC / US Language requirements: Ability to write and speak fluently in English

Application experience required:

Banking domain knowledge, understanding of Financial products, understanding of Credit Risk, Liquidity Risk, Asset Liability Management (ALM) modelling and reporting.

Travel required:

Yes to UAE on a medium to long-term basis.

Key responsibility areas:

PL/SQL & Database Development:

Design, optimize, and maintain complex Oracle SQL and PL/SQL packages, procedures, functions, triggers, and views tailored for data transformation and aggregation.

Data Extraction & ETL:

Develop and execute high-performance ETL/batch integration frameworks to move financial records from Core Banking Systems (e.g., Finacle, Temenos) to specialized risk databases.

Functional Interpretation:

Translate updated CBUAE BRF manuals and circulars into technical schema and data validation logic.

Source-to-Target Data Mapping:

Author functional and technical specifications alongside comprehensive source-to-target data mappings to ensure end-to-end data lineage and auditability

Reporting Architecture Support:

Configure, test, and debug regulatory logic inside banking platform engines

Reconciliation & Validation:

Perform rigorous data reconciliation and validation dry-runs against cross-form dependencies (e.g., ensuring consistency between Capital, Credit, and Liquidity forms).

Testing Lifecycle: Lead System Integration Testing (SIT), User Acceptance Testing (UAT), and post-go-live technical validation alongside Risk and Compliance teams.

Work permit requirements:

Either Indian Citizen or having valid work permit to work in India / UAE

Period of engagement:

Full-time position

Probation period:

6 months

Compensation:

Compensation varies depending on the skill, fitment and role played by the person. Compensation discussions will take place post the selection process.

Performance incentives:

Typically, all roles at Acies have a performance incentive. Specific aspects will be discussed during the compensation discussion

Leave:

19 working days a year. Additional leaves for national holidays, sick leaves, maternity and paternity, bereavement and studies vary based on the city and country of engagement.

Other benefits:

Other employment benefits including medical insurance will be informed during the compensation discussion.

Career growth for full-time roles:

Acies believes in a transparent and data-based performance evaluation system. You are encouraged to clarify any questions you have with respect to career growth with Acies personnel you interact with during the selection process.

Career opportunities for part-time roles:

Conversion of part-time roles to full-time roles depends on both performance of the individual and business needs. You are encouraged to ask about the prospects as you interact with Acies personnel during the selection process.

Global mobility:

Acies encourages mobility across our offices. Such mobility is, however, subject to business needs and regulations governing immigration and employment in various countries.