Data Modeler

Job Description

Job Overview We are seeking a skilled Data Modeler to design, implement, and optimize our enterprise data architecture. You will bridge the gap between business requirements and technical database design. This role follows a hybrid work setup based in the client's office in Bonifacio Global City (BGC), Taguig . Key Responsibilities Design Core Schemas : Create conceptual, logical, and physical data models. Optimize Database Performance : Write and fine-tune complex SQL queries for relational systems. Architect Warehouses : Build scalable data warehousing architectures to support business intelligence. Govern Data Quality : Establish strict metadata management and data lineage workflows. Integrate Data Streams : Collaborate with engineers to design efficient ETL/ELT pipelines. Maintain Documentation : Update enterprise data dictionaries and architectural blueprints regularly. Required Technical Skills Data Model Concepts : Deep understanding of relational, dimensional, and Data Vault modeling. Data Modeling Techniques : Proven experience in normalization, denormalization, and time-variant data handling. Data Modeling Tools : Proficiency in industry tools like Erwin Data Modeler, SAP PowerDesigner, or hackolade. Database Systems : Hands-on expertise with RDBMS (e.g., PostgreSQL, SQL Server) and Cloud Warehouses (e.g., Snowflake, BigQuery). Advanced SQL : Mastery in writing, optimization, window functions, and stored procedures. Datawarehousing \& ETL : Strong grasp of OLAP design, staging environments, and ETL architecture mapping. Metadata Management : Experience managing data catalogs, data lineages, and business glossaries. Project Assignment: Exposed to insurance projects and/or have an insurance background as a Data Modeler. Qualifications \& Work Setup Experience : Minimum 4–6 years of dedicated data modeling or data architecture experience. Location : Baseline office in Bonifacio Global City (BGC), Taguig. Setup : Hybrid schedule (4-8 days onsite per month). Shift : Day shift (9AM-6PM) Contract Arrangement: Project-based engagement (6 months-1 year initial contract with possible continuous extensions; open for absorption but not guaranteed 100%) Benefits Statutory benefits (SSS, Pagibig, Philhealth, 13th month pay), Service Incentive Leaves, HMO after 6 months, completion bonuses Pay: Php70,000\.00 - Php130,000\.00 per month Benefits Additional leave Company Christmas gift Flexible schedule Flextime Health insurance Work from home Work Location: Hybrid remote in Taguig