Job Description :

Role & Responsibilities :

- Design and implement enterprise dimensional data models (conceptual, logical, and physical) aligned with BFSI business requirements.

- Develop and optimize Snowflake-based data warehouse solutions supporting analytical and reporting needs.

- Translate complex business requirements into scalable data architectures and data models.

- Build and maintain ELT pipelines using Snowflake, SQL, Oracle and modern data integration tools.

- Ensure data quality, governance, lineage, and consistency across enterprise data platforms.

- Collaborate with business teams including finance, risk, credit, and operations for requirement gathering and solution design.

- Implement performance tuning and cost optimization strategies in Snowflake environment.

- Design data marts for financial reporting, regulatory reporting, and MIS use cases.

- Work closely with data engineering, BI, and analytics teams to deliver end-to-end data solutions.

- Support audit, compliance, and regulatory data requirements in BFSI domain.

Preferred Candidate Profile :

- 8- 10 years in Data Modeling / Snowflake / Python / SQL.

- Strong experience in dimensional data modeling techniques (Star Schema, Snowflake Schema, Data Vault).

- Hands-on expertise in Snowflake data platform including performance tuning and optimization.

- Strong knowledge of Python pandas / Pyspark framework.

- Advanced SQL skills for data transformation and analysis.

- Experience with ETL/ELT tools like Talend or similar.

- Strong understanding of BFSI domain including loan lifecycle, finance, risk, and regulatory reporting.

- Knowledge of financial data structures like GL, P&L, balance sheet, and reporting hierarchies.

- Strong analytical, problem-solving, and communication skills.