Data Modeler

Private Advertiser; Makati; On-site; PHP 1,500,000 - 2,500,000; Full time

Job summary

Private Advertiser in Metro Manila is seeking a senior data architect with 5–7 years of data modeling experience and at least 3 years in banking or financial services. The role focuses on enterprise-scale integration of 40+ source systems into a governed model, with a strong emphasis on data warehouse design and scalable architectures.

Applicants should be proficient in Inmon, Kimball, and Data Vault 2.0 approaches, 3NF normalization, and SQL validation against real data.

Qualifications

• Experience: 5–7 years in data modeling or data architecture, with 3+ years in banking/financial services.
• Enterprise Scale: integrates 40+ source systems into a single governed enterprise model.
• Data Warehousing: strong grounding in data warehouse and lakehouse design (Medallion architecture).
• Modeling Methodologies: Inmon, Kimball, and Data Vault 2.0 knowledge and application.

Skills

Data modeling

Data architecture

Banking data

SQL

ETL / data warehousing

Modeling frameworks

Communication

Tools

ERD tools

Data dictionaries

Mapping specifications

Job description

Required Qualifications

• Experience: At least 5–7 years in data modeling or data architecture, with at least 3 years in banking or financial services.
• Enterprise Scale: Proven experience modeling large enterprise landscapes integrating 40 or more source systems into a single governed enterprise model.
• Data Warehousing: Strong grounding in data warehouse and lakehouse design, including layered (Medallion: Bronze/Silver/Gold) architectures and ODS patterns.
• Modeling Methodologies: Deep, practical knowledge of Inmon (normalized enterprise data warehouse), Kimball (dimensional modeling, bus matrix, conformed dimensions), and Data Vault 2.0 (hubs, links, satellites) — and the judgment to choose between them per layer and use case.
• Normalization: Expert in Third Normal Form (3NF) and normalization/denormalization trade-offs.
• Dimensional Modeling: Expert in star and snowflake schemas, fact and dimension design, grain definition, degenerate and junk dimensions, and slowly changing dimensions (Types 1, 2, and others).
• SCD Type 2: Hands-on design of SCD2 structures, including effective datetime selection from business events vs. processing dates, and point-in-time reconstruction for audit.
• Referential Integrity: Strong command of key strategies, surrogate key generation, orphan handling, and integrity validation across distributed data.
• Financial Data: Working knowledge of banking data — CIF/party, CASA, time deposits, loans, cards, payments (InstaPay, PESONet, SWIFT), treasury deals, fees, and GL postings.
• SQL: Advanced SQL; able to validate models against real data and profile source systems.
• Tools: Experience with a data modeling tool and producing ERDs, data dictionaries, and mapping specifications.
• Communication: Able to explain modeling decisions to both technical and non-technical audiences, and to document decisions clearly.

Preferred Qualifications

• BIAN: Experience applying BIAN (Banking Industry Architecture Network) service domains and business object models to enterprise data domains.
• Platform: Experience with Azure Databricks, Delta Lake, Unity Catalog, ADLS, and PySpark.
• Master Data: Exposure to MDM/customer data mastering, CIF deduplication, and party-role modeling (customer, beneficiary, authorized signatory, employee, affiliate).
• Regulatory: Familiarity with Philippine regulatory and reporting contexts (e.g., BSP, BIR e-invoicing) and data privacy obligations.
• Governance: Experience with business glossaries, data catalogs, metadata management, and data quality frameworks.
• Certifications: CDMP (DAMA), Data Vault 2.0 certification, or Databricks certifications.