Data Warehouse Engineer

Hammerjack Pty Ltd; Philippines; On-site; PHP 600,000 - 900,000; Full time

Job summary

Hammerjack Pty Ltd is seeking a skilled Data Warehouse Engineer to design, develop, and maintain enterprise data warehouse solutions that support BI, reporting, and analytics.

The ideal candidate will have strong data modeling, ETL/ELT proficiency, and experience with cloud data platforms across on‑prem and cloud environments. You will collaborate with stakeholders to ensure data quality and governance while optimizing performance.

Qualifications

• Bachelor's degree in CS/IT/Data Engineering or related field.
• 3+ years in data warehousing, data engineering, or DB development.
• Strong SQL and database design skills.
• Experience with ETL/ELT tools (Informatica, SSIS, Talend, Data Factory).
• Cloud platforms knowledge (Azure, AWS, GCP).

Responsibilities

• Design, develop, and maintain enterprise data warehouse architectures and pipelines.
• Build and optimize ETL/ELT processes from various sources.
• Develop dimensional and relational data models for reporting.
• Collaborate with stakeholders to translate data needs into solutions.
• Ensure data quality, governance, and performance.
• Monitor database performance and optimize storage and queries.
• Implement data integration using cloud and on-prem technologies.
• Document data dictionaries and processes.
• Troubleshoot data issues and perform root-cause analysis.
• Support BI tools with reliable datasets.

Skills

SQL proficiency

Data modeling

ETL/ELT

Analytical thinking

Communication skills

Education

Bachelor's degree in CS/IT/Data Eng

Tools

Informatica

SSIS

Talend

Data Factory

Azure Synapse

Snowflake

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.