Data Modeler

Key Responsibilities:

• Develop complex SQL queries to satisfy complex KPIs
• Implement KPI calculation logic in collaboration with business stakeholders
• Build curated data models optimized for BI dashboards and analytics
• Ensure data quality, reconciliation, and consistency across KPIs
• Support performance tuning and scalability of KPI datasets

Key Skills:

• 5-7 years of experience in data modeling:
• Strong expertise in logical and physical data modeling for enterprise data warehouses in banking environments.
• Ability to design and maintain data models across different domains.
• Proficient in translating banking and KPI requirements into well-structured entities, attributes, keys, and relationships.
• Strong SQL skills to profile data, validate relationships, and ensure data consistency within the warehouse.
• Ability to align data models with ETL/ELT processes and transformation logic implemented using Informatica.
• Experience supporting BI tools