Envision Employment Solutions is currently looking for a Data Modeler for one of our partners, a global leader in the IT Services and IT Consulting.
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
Requirements
- 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
