Data Warehouse Consultant

3 weeks ago

Pasig, National Capital Region, Philippines Getz Healthcare Full time

The Data Warehouse Consultant will design, build, and optimize scalable data warehouse and AI solutions. The ideal candidate has successfully delivered end-to-end data warehouses from the ground up, making key architectural decisions and implementing them effectively. This role requires someone who can quickly add value, work onsite with stakeholders, and demonstrate tangible results within the first few weeks.

This is a consultancy-based role for six (6) months.

Key Responsibilities

  • Lead the end-to-end design and implementation of a scalable, high-performance data warehouse aligned with business needs and translate business requirements into dimensional models, ETL/ELT workflows, and analytics-ready datasets as well as recommend and implement suitable architectures, frameworks, and tools for data warehousing and integration.
  • Develop, monitor, and maintain ETL/ELT processes using modern platforms and scripting, optimize data models, queries, and overall system performance, and ensure compliance with data governance, quality, security, and privacy standards.
  • Oversee the consolidation and migration of legacy systems to modern cloud-based platforms, maintain accurate documentation (data dictionaries, lineage, process flows as well as provide expertise in BI/reporting integration to ensure consistency in analytics.
  • Deliver quick wins and actionable insights within the first few weeks.
  • Mentor and transfer knowledge to internal team members to ensure long-term capability.

Qualifications
  • Bachelor's degree in Computer Science, Information Technology, Engineering, or related field (Master's degree a plus).
  • Minimum 8–10 years in data warehousing, business intelligence, or data engineering with proven track record of designing and implementing data warehouses from scratch, including key design decisions and ability to deliver rapid results and provide clear direction on priorities.
  • Hands-on experience with cloud-based platforms (e.g., Azure Synapse, Microsoft Fabric, or similar) including strong SQL/T-SQL expertise in data modeling (star/snowflake schema) and performance tuning.
  • Solid background in ETL/ELT development and scheduling (e.g., SSIS, Azure Data Factory), with exposure to data lakes and extensive experience integrating data from multiple sources, including ERP, SharePoint, and APIs including familiarity with BI tools (Power BI preferred) and data visualization best practices.
  • Advanced SQL programming and performance optimization.
  • Strong analytical and problem-solving abilities and excellent communication and stakeholder engagement skills.
  • Knowledge of metadata management, data governance, and quality frameworks as well as ability to manage multiple priorities in a fast-paced environment.

Nice-to-Have
  • Certifications in Azure Data Engineer, Microsoft Fabric, or similar platforms.
  • Experience with scripting languages (e.g., Python) for data processing and automation.
  • Knowledge of big data platforms and modern data stack tools.
  • Industry experience in healthcare or distribution.
  • Familiarity with AI/ML tools or implementation.
#J-18808-Ljbffr

  • Data Warehouse Consultant

    4 days ago

    Pasig, National Capital Region, Philippines GETZ Healthcare Full time $90,000 - $120,000 per year

    The Data Warehouse Consultant will design, build, and optimize scalable data warehouse and AI solutions. The ideal candidate has successfully delivered end-to-end data warehouses from the ground up, making key architectural decisions and implementing them effectively. This role requires someone who can quickly add value, work onsite with stakeholders, and...

  • SAP ABAP Consultant

    7 days ago

    Pasig, National Capital Region, Philippines NTT DATA Asia Pacific Full time ₱1,200,000 - ₱2,400,000 per year

    Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Job Description:Understand the...

  • Microsoft ERP Presales Consultant

    1 week ago

    Pasig, National Capital Region, Philippines NTT DATA, Inc. Full time ₱1,500,000 - ₱3,000,000 per year

    Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Your day at NTT DATAThe Pre-Sales...

  • SAP SuccessFactors Employee Central Consultant

    4 days ago

    Pasig, National Capital Region, Philippines NTT DATA, Inc. Full time ₱900,000 - ₱1,200,000 per year

    Make an impact with NTT DATAJoin a company that is pushing the boundaries of what is possible. We are renowned for our technical excellence and leading innovations, and for making a difference to our clients and society. Our workplace embraces diversity and inclusion – it's a place where you can grow, belong and thrive.Workplace type:About NTT DATANTT DATA...

  • Application Consultant

    7 days ago

    Pasig, National Capital Region, Philippines APPTechnology Experts, Inc. (APPTech) Full time ₱900,000 - ₱1,200,000 per year

    Company DescriptionAPPTechnology Experts, Inc. (APPTech) is an IT consulting company delivering innovative business solutions across the Philippines. As a trusted Value-Added Reseller of SAP Philippines, we provide end-to-end sales and services for SAP Business One, SAP Cloud ERP, and SAP Concur. Our expertise spans diverse industries, including...

  • Warehouse head

    3 weeks ago

    Pasig, National Capital Region, Philippines Walls in Motion, Inc. Full time

    About the roleWarehouse Head at Walls in Motion, Inc. will oversee the efficient operation of our distribution centre in Pasig City, Metro Manila. You will be responsible for managing all warehouse activities, ensuring the timely and accurate processing of orders, and maintaining high standards of health and safety. This is a full-time, on-site position.What...

  • Warehouse head

    4 days ago

    Pasig, National Capital Region, Philippines Walls in Motion, Inc. Full time ₱900,000 - ₱1,200,000 per year

    About the role Walls in Motion, Inc. is seeking an experienced and motivated Warehouse Head to oversee the efficient operation of our distribution centre in Pasig City, Metro Manila. As a key member of our team, you will be responsible for managing all warehouse activities, ensuring the timely and accurate processing of orders, and maintaining high...

  • Warehouse Manager

    1 week 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 week 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 Man

    2 days ago

    Pasig, National Capital Region, Philippines Infinity Outsourcing Services Full time ₱150,000 - ₱250,000 per year

    A warehouse job description includes responsibilities like receiving and processing incoming stock, picking and packing customer orders, managing inventory and stock levels, organizing and storing materials, operating warehouse machinery like forklifts, and maintaining a clean and safe work environment. Key requirements often include physical stamina,...