Fint Solutions - Technical Business Analyst - SQL/ETL

Responsibilities :

- Work with data architects to design dimensional models for banking data (star schemas, snowflakes)

- Define ETL/ELT requirements for loading banking transactions, customer data, and reference data

- Specify data validation rules and reconciliation processes

- Work with stakeholders (business users, IT teams, regulators) to document data and reporting requirements.

- Define source-to-target mappings for banking data (transactions, customer info, risk data etc) and analyze and validate data models (star schema, snowflake) for the warehouse.

- Design dashboards for risk management, customer analytics, and financial reporting and Support regulatory and compliance reporting needs

- Write complex SQL queries to extract, transform, and validate banking data.

- Exposure in ETL (Extract, Transform, Load) workflows align with business rules

- Support UAT (User Acceptance Testing) for new data feeds and reports.

- Define data quality rules (completeness, accuracy, consistency) and monitor them.

- Maintain data dictionaries and lineage for audit and governance.

- Bridge the gap between business users (risk, finance teams) and technical teams (ETL developers).

Technical Skills :

- SQL expertise (complex queries, performance tuning)

- Data warehouse concepts (star schema, slowly changing dimensions)

- Banking data knowledge (GL accounts, transactions, customer hierarchies)

- ETL tools ( ADF, Snowflake, INFORMATICA, DataStage, SSIS,)

- BI tools (Power BI,SSRS)

Domain Knowledge :

- Understanding of banking products and operations (Personal Banking, Business Banking, Commercial & Corporate Banking)

- Regulatory reporting requirements

- Risk management concepts and Customer segmentation methodologies