Data Modeler with PostgreSQL

2 hours ago

Pasig, National Capital Region, Philippines Tata Consultancy Services Full time ₱900,000 - ₱1,200,000 per year

Scope of Work/Responsibilities

Data Modeling

  • Design and implement conceptual, logical, and physical data models for enterprise systems.
  • Ensure consistency and compliance with data architecture principles and naming standards.
  • Document models, relationships, and metadata.

Database Design and Optimization

  • Create and maintain database schemas, tables, indexes, and views in PostgreSQL.
  • Optimize queries, indexes, and storage structures for performance.
  • Support normalization and denormalization strategies as required.

Collaboration and Integration

  • Work closely with application developers, data engineers, and ETL teams to ensure alignment between data models and implementation.
  • Participate in data migration and integration projects, ensuring model integrity.

Governance and Documentation

  • Maintain data dictionaries and metadata repositories.
  • Establish best practices for database design and change management

Support and Review

  • Review and refactor existing database structures where necessary.
  • Provide support during testing, deployment, production and performance tuning phases.

Requirement and Qualification (Education & Work Experience)

Education and Work Experience

  • Bachelor's degree in Computer Science, Information Systems, or related field.
  • Minimum 5 years of experience in data modeling and database design.
  • Proven hands-on experience with
    PostgreSQL
    , including schema design, indexing, and query optimization.
  • Familiarity with data modeling tools (e.g., ERwin, ER/Studio, pgModeler, or similar).
  • Experience in data migration using ETL tools like ADF
  • Experience working with large-scale, complex datasets and data integration projects.
  • Strong understanding of normalization, data integrity, and relational database theory.
  • Excellent analytical, communication, and documentation skills.

Datailed Tasks/Expected Output

  • Conceptual, logical, and physical data models.
  • PostgreSQL database schema scripts and documentation.
  • Data dictionary and metadata documentation.
  • Performance optimization and tuning report.
  • Recommendations for ongoing database design improvements.

  • Data Engineer

    1 week ago

    Pasig, National Capital Region, Philippines Satellite Office Full time ₱40,000 - ₱80,000 per year

    We are looking for a skilled Data Engineer to design, build, and manage our data infrastructure. You will be responsible for constructing robust data pipelines that collect, process, and store data from various sources, enabling data-driven decision-making for our business units. Experience with modern cloud data platforms is highly valued.Key...

  • Risk Modeling Lead/Data Scientist

    2 weeks ago

    Pasig, National Capital Region, Philippines Viventis Search Asia Full time ₱2,000,000 - ₱2,500,000 per year

    Role ResponsibilitiesLead advanced analytics and modeling initiatives within the company's Risk Management function.Develop and enhance score models across multiple risk areas using: Traditional methods (Regression, Decision Trees, etc.) and AI/ML techniques (Gradient Boosting, NLP, etc.)Collaborate with the tech team to design ML Ops pipelines ...

  • Risk Modeling Lead/Data Scientist

    5 hours ago

    Pasig, National Capital Region, Philippines Viventis Search Asia Full time ₱2,000,000 - ₱2,500,000 per year

    Responsible for advanced analytics and modeling initiative within the company's Risk Management. She/ He will be responsible for developing and enhancing score models across multiple risk areas using traditional methods as well as new AI/ML techniques. Working with the tech team she/he will lay out the ML ops pipelines and structure for rapid rollout and...

  • DATA ARCHITECT

    4 hours ago

    Pasig, National Capital Region, Philippines Seven Seven Global Services, Inc. Full time ₱4,500,000 - ₱7,500,000 per year

    1. ExperienceTypically requires 8-10 years of experience in data, with at least 3-5 years in architecture roles or designing complex data systems.2. Data Modeling & DesignData Warehousing:· Mastery of Star Schema and Snowflake Schema· Dimensional modeling (Kimball methodology)· Data Vault 2.0 for enterprise environments· Slowly Changing Dimensions...

  • ECL Model Officer

    4 hours ago

    Pasig, National Capital Region, Philippines HCM Nexus Full time ₱1,000,000 - ₱3,000,000 per year

    About the RoleWe are seeking an ECL Model Officer to join our Risk Management team.This role is critical in developing and enhancing Expected Credit Loss (ECL) models across Consumer and SME products.You will ensure models are robust, compliant with regulatory standards, and provide insights that drive both risk and business strategies.Key...

  • Risk MIS and Model Risk Management Officer

    2 weeks ago

    Pasig, National Capital Region, Philippines City Savings Bank Full time ₱900,000 - ₱1,200,000 per year

    We are looking for a skilled and detail-oriented Risk MIS and Model Risk Management Officer to become a key member of our Risk Management Team. This vital position involves managing the hands-on execution of our essential PFRS 9 / ECL credit risk models (Probability of Default, Loss Given Default, Exposure-at-Default), providing key inputs that inform the...

  • Data Governance Analyst

    4 hours ago

    Pasig, National Capital Region, Philippines Ben Edictio Corporated Full time ₱1,200,000 - ₱1,800,000 per year

    This is 1 YEAR & 6 MONTHS CONTRACTUAL/PROJECT BASED EMPLOYMENT (It means that your contract will be under Ben Edictio but you will be assigned to our client. Ben Edictio will process your payroll/salary but you will be working with our client. After your 1 YEAR & 6 MONTHS contract, it depends if the company will absorb you or extend/renew your contract)....

  • Data Analyst Governance

    4 hours ago

    Pasig, National Capital Region, Philippines Ben Edictio Corporated Full time ₱360,000 - ₱504,000 per year

    This is 1 YEAR CONTRACTUAL/PROJECT BASED EMPLOYMENT (It means that your contract will be under Ben Edictio but you will be assigned to our client. Ben Edictio will process your payroll/salary but you will be working with our client. After your 1 YEAR &contract, it depends if the company will absorb you or extend/renew your contract). however, it seems like...

  • Data Scientist

    4 hours ago

    Pasig, National Capital Region, Philippines Satellite Office Full time ₱1,500,000 - ₱2,500,000 per year

    At OptiCloud, we're pioneering digital sustainability by redefining how businesses and individuals manage their data in the cloud era. Our AI-powered platform identifies and eliminates digital waste—unnecessary compute, redundant data, idle resources—turning inefficiency into actionable savings for businesses and measurable climate impact for the...

  • Data Engineer Lead

    2 weeks ago

    Pasig, National Capital Region, Philippines White Cloak Technologies, Inc. Full time ₱1,500,000 - ₱3,500,000 per year

    Job Title: Data Engineer LeadReports To: Enterprise Data Group HeadsEmployment Type: [Full-time]Location: [On-site/Hybrid]Job SummaryWe are seeking a highly skilled and motivated Senior or Data Engineer Lead to play a pivotal role in our enterprise data initiatives. This position is responsible for designing, building, and maintaining scalable and efficient...