Job Summary:
We are seeking an experienced Data Modeler with at least 5 years of relevant experience in data modeling and database design to support enterprise data initiatives. The ideal candidate will design, develop, and maintain scalable conceptual, logical, and physical data models that drive reporting, analytics, and operational systems.
This role requires strong expertise in data modeling methodologies, database architecture, data warehousing, and close collaboration with cross-functional technical and business teams.
Key Responsibilities:
- Design, develop, and maintain conceptual, logical, and physical data models aligned with business and technical requirements.
- Translate business requirements into scalable, high-performing data structures.
- Ensure alignment with enterprise data standards, governance frameworks, and best practices.
- Partner with data engineers and ETL developers to support integration and transformation processes.
- Develop and maintain metadata repositories, data dictionaries, and data lineage documentation.
- Optimize database schemas and structures to improve performance, scalability, and data quality.
- Support data warehousing initiatives, including dimensional modeling (star and snowflake schemas).
- Review and validate database designs for consistency, scalability, and compliance with architectural standards.
- Conduct impact analysis for data model changes and system enhancements.
Required Qualifications:
- Minimum of 5+ years of hands-on experience in Data Modeling and Database Design.
- Strong expertise in data modeling methodologies (conceptual, logical, physical).
- Hands-on experience with data modeling tools such as ERwin, ER/Studio, PowerDesigner, or similar.
- Solid understanding of relational and/or cloud-based database systems.
- Proficiency in SQL for data validation, analysis, and performance tuning.
- Strong knowledge of data warehousing concepts (fact tables, dimensions, star/snowflake schemas).
- Experience with ETL processes and data integration workflows.
- Understanding of metadata management and data governance principles.
- Strong analytical, problem-solving, and documentation skills.
- Excellent communication and stakeholder management abilities.
Work Setup: Hybrid Set up (TBD)
Shift: Day Shift
Location: BGC, Taguig
Salary: Open to discuss depending on the years of experience
