Data Warehouse Architect

1 week ago


Pasig, National Capital Region, Philippines WeSearch@Searchers & Staffers Corp. Full time ₱1,200,000 - ₱2,400,000 per year

Position Overview

The Data Warehouse Consultant will be responsible for designing, building, and optimizing scalable data warehouse and AI-driven solutions. The ideal candidate has a strong track record of delivering end-to-end data warehouses, making key architectural decisions, and executing them effectively. This role requires someone who can create impact quickly, work closely with onsite stakeholders, and deliver tangible results within the first few weeks.

This is a six (6)-month consultancy engagement.

KEY RESPONSIBILITIES

  • Lead the full lifecycle design and implementation of scalable, high-performance data warehouse solutions aligned with business requirements.
  • Translate business needs into dimensional data models, ETL/ELT workflows, and analytics-ready datasets.
  • Recommend and deploy appropriate architectures, frameworks, and tools for data warehousing and integration.
  • Develop, monitor, and optimize ETL/ELT processes using modern platforms and scripting.
  • Enhance data models, queries, and overall system performance while ensuring compliance with governance, quality, security, and privacy standards.
  • Drive system consolidation and migration from legacy environments to modern cloud-based platforms.
  • Maintain comprehensive documentation including data dictionaries, lineage, and process flows.
  • Provide expertise in BI/reporting integration to support consistent and reliable analytics.
  • Deliver quick wins and actionable insights early in the engagement.
  • Mentor and upskill internal team members to ensure sustainable in-house capability.

QUALIFICATIONS

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field (Master's degree preferred).
  • 8–10 years of experience in data warehousing, BI, or data engineering, with proven success in building and implementing data warehouses from the ground up.
  • Demonstrated ability to deliver rapid results and set clear priorities.
  • Hands-on expertise with cloud platforms (e.g., Azure Synapse, Microsoft Fabric, or similar).
  • Strong SQL/T-SQL proficiency, including data modeling (star/snowflake schema) and performance tuning.
  • Solid background in ETL/ELT development and scheduling (e.g., SSIS, Azure Data Factory).
  • Experience with data lakes and integration from multiple sources such as ERP systems, SharePoint, and APIs.
  • Familiarity with BI tools (Power BI preferred) and data visualization best practices.
  • Advanced SQL programming and system optimization skills.
  • Strong analytical thinking, problem-solving capabilities, and stakeholder engagement skills.
  • Knowledge of metadata management, governance, and data quality frameworks.
  • Ability to manage multiple priorities in fast-paced, dynamic environments.

NICE-TO-HAVE

  • Certifications in Azure Data Engineer, Microsoft Fabric, or similar technologies.
  • Experience with scripting languages (e.g., Python) for automation and data processing.
  • Familiarity with big data platforms and modern data stack tools.
  • Industry background in healthcare or distribution.
  • Exposure to AI/ML tools and implementation.


  • Pasig, National Capital Region, Philippines WeSearch@Searchers & Staffers Corp. Full time ₱900,000 - ₱1,200,000 per year

    About the RoleWe are looking for a Data Warehouse Consultant for a 6-month engagement to help design, build, and optimize data warehouse solutions for our healthcare operations. This role is ideal for someone who can quickly make an impact, align technical solutions with business needs, and work closely with onsite teams in Pasig.What You'll DoDesign and...


  • Pasig, National Capital Region, Philippines XP Power Full time ₱1,200,000 - ₱1,500,000 per year

    Company DescriptionXP Power is a global leader in providing essential power solutions to the Healthcare, Technology and Industrial markets. We are a fast-growing business, based in numerous locations across North America, Asia and Europe, and are listed as a FTSE 250 company on the London Stock Exchange. We are extremely proud and committed to our culture...


  • Pasig, National Capital Region, Philippines XP Power Full time ₱900,000 - ₱1,200,000 per year

    Company Description XP Power is a global leader in providing essential power solutions to the Healthcare, Technology and Industrial markets. We are a fast-growing business, based in numerous locations across North America, Asia and Europe, and are listed as a FTSE 250 company on the London Stock Exchange. We are extremely proud and committed to our culture...

  • Warehouse Manager

    1 day ago


    Pasig, National Capital Region, Philippines VIVCO Full time ₱480,000 - ₱600,000 per year

    Job SummaryThe Warehouse Manager is responsible for leading and managing VIVAIA's central warehouse operations in Pasig City, serving as the primary distribution hub for all stores nationwide. The key priority of this role is to ensure timely, accurate, and cost-effective replenishment of all retail locations to maintain optimal stock levels, maximize sales...

  • Warehouse Manager

    1 day ago


    Pasig, National Capital Region, Philippines Vivco Corp. (Vivaia) Full time ₱1,200,000 - ₱3,600,000 per year

    Job SummaryThe Warehouse Manager is responsible for leading and managing VIVAIA's central warehouse operations in Pasig City, serving as the primary distribution hub for all stores nationwide. The key priority of this role is to ensure timely, accurate, and cost-effective replenishment of all retail locations to maintain optimal stock levels, maximize sales...

  • Warehouse Supervisor

    2 weeks ago


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

    Directs and controls the day-to-day warehouse operations for all non-PMFTC client accounts, ensuring the safe, accurate, and efficient receipt, storage, and dispatch of goods. Supervises and develops the Warehouse Admin Staff and coordinates closely with clients and internal departments to meet service, cost, and compliance requirements.Key Roles &...

  • Data Engineer

    2 weeks ago


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

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

  • Data Analyst

    1 week ago


    Pasig, National Capital Region, Philippines Seven Seven Global Services Inc Full time ₱900,000 - ₱1,200,000 per year

    Job Description:Design and develop data pipelines that will ingest the data from the respective source systems into the data warehouseSupport and optimize existing data pipelines to ensure that the downstream SLAs are metResponsible in attending agile ceremonies as part of the Agile Tribe set-up and delivering the different demands of the Tribe related to...

  • Solutions Architect

    1 week ago


    Pasig, National Capital Region, Philippines CIS Bayad Center, Inc. Full time ₱1,200,000 - ₱1,500,000 per year

    Job SummaryThe Solutions Architect designs and delivers comprehensive IT solution architectures that follow design principles while ensuring the architecture meets present and future performance, security, reliability, resiliency, and extensibility needs.Conceptualizes and implements the overall solution architectures spanning web portals, mobile devices,...


  • Pasig, National Capital Region, Philippines AVC Chemical Corporation Full time ₱240,000 - ₱300,000 per year

    The Logistics and Warehouse Specialist has the following responsibilities:Administration of activities in the warehousePlanning and optimizing warehouse space allotment with products properly stocked on designated locationsConduct a regular inventory count and reconciliation of stocksEnsure prompt fulfilment of orders taking into account FIFO (First In/First...