Principal Solution Engineer - Finance & Risk Datamarts

Architect and design robust, scalable, and secure finance and risk datamarts, ensuring alignment with business objectives and regulatory requirements. Lead the technical design and implementation of data integration strategies, including ETL/ELT processes, data warehousing, and data modeling for financial and risk data. Collaborate with business stakeholders, data scientists, and risk managers to deeply understand their analytical needs and translate them into effective data solutions. Develop and maintain comprehensive data governance frameworks, data quality standards, and metadata management for finance and risk data domains.

Desired Candidate Profile

Years of Experience * Minimum 8 years Required Skills * Strong hands-on Oracle Database, SQL and PL/SQL development/support, including packages, procedures, functions, troubleshooting and performance tuning. Strong L2/L3 application support: incident triage, service restoration, root-cause analysis, problem management, defect fixing and controlled production changes. Strong ETL/data-integration, source-to-target mapping, data lineage, reconciliation and high-volume batch-processing experience. Good functional understanding of banking products and their Finance/Risk data, including loans/advances, deposits, customer/account data, treasury/derivatives, securities/investments, trade finance and other relevant banking products. Understanding of product attributes such as balances, interest/rates, maturity/repricing, currencies, collateral, limits/exposure, classifications and accounting/risk treatment. Strong business-facing communication skills to clarify data and reporting issues with Finance and Risk stakeholders and translate business queries into technical analysis. Experience with audit/control observation remediation, evidence preparation and closure. Environment-readiness experience across Production/UAT/SIT/DR covering database/application health, schedulers, interfaces, access/connectivity, dependencies, capacity and release readiness. Working knowledge of ITIL incident/problem/change management, ServiceNow, JIRA and Confluence. Oracle/cloud database modernization knowledge is desirable. Required Experience / Knowledge Areas * 8+ years in enterprise application/data-platform support and engineering, with strong Oracle SQL/PLSQL experience, preferably within banking Finance or Risk technology. Proven L2/L3 production-support experience for business-critical Finance/Risk data marts, warehouses or reporting platforms operating under month-end, quarter-end and regulatory timelines. Strong exposure to banking product data across lending/advances, deposits, treasury/derivatives, securities/investments, customer/account and related Finance/Risk domains. Experience liaising directly with Finance and Risk users for business clarification, data analysis, reconciliation, incident resolution and reporting support. Experience with Oracle/ETL production support, audit observations, environment readiness, SIT/UAT, release deployment and DR activities. Experience supporting data-platform modernization or Oracle cloud migration is advantageous. Skills Oracle Database SQL/PLSQL ETL Employment Type Full-time

Keywords