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.