Data Warehouse Consultant

2 weeks ago


Pasig, 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

  • 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...


  • 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...


  • Pasig Central Post Office, Philippines wesearch Full time $70,000 - $120,000 per year

    Position Title: Data Warehouse ConsultantLocation: Pasig, Metro ManilaEngagement: 6-Month ConsultancyAbout the RoleThe Data Warehouse Consultant will play a pivotal role in designing, building, and optimizing scalable data warehouse and AI-driven solutions. This position is suited for someone with a strong track record of delivering end-to-end data warehouse...


  • Pasig Central Post Office P, Philippines wesearch Full time ₱1,440,000 - ₱2,040,000 per year

    Position Title: Data Warehouse ConsultantLocation: Pasig, Metro ManilaEngagement: 6-Month ConsultancyAbout the RoleThe Data Warehouse Consultant will play a pivotal role in designing, building, and optimizing scalable data warehouse and AI-driven solutions. This position is suited for someone with a strong track record of delivering end-to-end data warehouse...


  • Pasig, Philippines XP Power Full time

    XP Power Pasig, National Capital Region, Philippines SQL Data Warehouse Engineer We’re looking for a seasoned professional with 5+ years of hands-on experience managing SQL Data Warehouse environments in Azure. You’ll play a key role in ensuring data integrity, performance, and scalability across our BI landscape. What You’ll Do Administer and optimize...


  • Pasig, Philippines XP Power Full time

    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, Philippines NTT DATA, Inc. Full time

    Join to apply for the SAP Funds Management Consultant role at NTT DATA, Inc. 3 days ago Be among the first 25 applicants Join to apply for the SAP Funds Management Consultant role at NTT DATA, Inc. 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...

  • 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...


  • 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...


  • 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...