Data Warehouse Engineer

City People Solutions Inc.; Makati; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

City People Solutions Inc. is seeking a Data Warehouse Engineer to design, develop, implement, and maintain enterprise data warehouses for BI and analytics.

You will build scalable pipelines, optimize ETL/ELT processes, model data, ensure governance and data quality, and collaborate with analysts, data scientists, and app teams across cloud and on-prem environments.

This role demands strong SQL, scripting skills, and the ability to translate business requirements into robust data solutions.

Qualifications

• Bachelor's degree in Computer Science, IT, Data Engineering, or a related field.
• 3+ years in data warehousing, data engineering, or DB development.
• Strong SQL and data modeling knowledge.
• Experience with ETL/ELT tools (Informatica, SSIS, Talend, Data Factory).
• Experience with cloud platforms (Azure, AWS, GCP).
• Familiarity with data governance, security, and compliance; location Cebu.

Responsibilities

• Design, develop, and maintain scalable data warehouse architectures and data pipelines.
• Build and optimize ETL/ELT processes to ingest, transform, and load data from various sources.
• Develop and maintain dimensional and relational data models to support reporting and analytics.
• Collaborate with stakeholders, analysts, data scientists, and app teams to understand data needs.
• Ensure data quality, integrity, and governance across data warehouse environments.
• Monitor and optimize database performance, storage, and query execution.
• Implement data integration solutions using cloud and on-premises technologies.
• Create and maintain technical documentation, data dictionaries, and process workflows.
• Troubleshoot data-related issues and perform root-cause analysis.
• Support BI tools by providing reliable datasets and datasets structures.
• Implement security controls and ensure governance standards are followed.
• Participate in data architecture planning and platform upgrades.

Skills

Data modeling

SQL proficiency

Data warehousing

Analytical thinking

Communication skills

Education

Bachelor's degree in Computer Science or related field

Tools

Informatica

SSIS

Talend

Azure Data Factory

Azure/AWS/GCP

Job description

We are seeking a skilled Data Warehouse Engineer to design, develop, implement, and maintain enterprise data warehouse solutions that support business intelligence, reporting, and analytics initiatives. The ideal candidate will have strong expertise in data modeling, ETL/ELT processes, database technologies, and cloud data platforms. This role is responsible for ensuring the availability, integrity, and performance of data assets across the organization.

Key Responsibilities:

• Design, develop, and maintain scalable data warehouse architectures and data pipelines.
• Build and optimize ETL/ELT processes to ingest, transform, and load data from various internal and external sources.
• Develop and maintain dimensional and relational data models to support reporting and analytics requirements.
• Collaborate with business stakeholders, data analysts, data scientists, and application teams to understand data needs and deliver solutions.
• Ensure data quality, consistency, accuracy, and governance across data warehouse environments.
• Monitor and optimize database performance, storage, and query execution.
• Implement data integration solutions using cloud and on-premises technologies.
• Create and maintain technical documentation, data dictionaries, and process workflows.
• Troubleshoot data-related issues and perform root-cause analysis.
• Support business intelligence tools and reporting platforms by providing reliable and well-structured datasets.
• Implement security controls and ensure compliance with data governance standards.
• Participate in data architecture planning, platform upgrades, and continuous improvement initiatives.
  

Required Qualifications:

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a related field.
• 3+ years of experience in data warehousing, data engineering, or database development.
• Strong proficiency in SQL and database design principles.
• Experience developing ETL/ELT workflows using tools such as Informatica, SSIS, Talend, Data Factory, or similar platforms.
• Experience with data warehouse concepts, including star schema, snowflake schema, fact and dimension tables.
• Knowledge of data integration, transformation, and data quality processes.
• Experience with cloud platforms such as Microsoft Azure, AWS, or Google Cloud Platform.
• Familiarity with scripting or programming languages such as Python, Scala, or Java.
• Understanding of data governance, security, and compliance requirements.
• Strong analytical, problem-solving, and communication skills.
• Location - Cebu

Preferred Qualifications:

• Experience with Azure Synapse Analytics, Snowflake, Amazon Redshift, BigQuery, or Databricks.
• Knowledge of Power BI, Tableau, or other business intelligence tools.
• Experience working in Agile development environments.
• Understanding of DataOps, CI/CD, and automation practices.
• Relevant certifications in Azure, AWS, Snowflake, or data engineering technologies.