Data Engineer

Straive; Taguig; On-site; PHP 700,000 - 1,100,000; Full time

Job summary

Straive in Taguig, Philippines, seeks a Mid-Level Data Engineer to design, build, and maintain robust data pipelines and data solutions. You will collaborate with cross-functional teams to transform raw data into actionable insights using modern cloud technologies and data warehousing standards.

Responsibilities include building data pipelines, developing data marts, and migrating data to the in-house data warehouse while ensuring data quality and reliability.

Qualifications

• Bachelor's or Master’s degree in CS/IT/Engineering or related quantitative discipline.
• 3–5 years of hands-on data engineering experience (finance industry a plus).
• Solid understanding of ETL/ELT, data warehousing concepts, and BI tools (Qlik).
• Cloud tech experience with AWS and data warehouses like Snowflake.

Responsibilities

• Analyze raw data to generate BI and analytics datasets.
• Design and implement data pipelines to curate data into the data warehouse.
• Develop data marts to support data consumption by stakeholders.
• Migrate data from legacy databases to the in-house warehouse.
• Maintain and optimize data pipelines and data platforms.
• Develop prototypes to support evolving business needs.
• Improve data quality, consistency, and reliability.

Skills

Python

Java

ETL/ELT

Data warehousing concepts

Agile frameworks

Education

Bachelor's or Master's in CS/IT/Engineering

Tools

Snowflake

PostgreSQL

MS SQL

Qlik

Job description

We are looking for a Mid-Level Data Engineer to join our team in BGC. In this role, you will collaborate with cross-functional teams to design, build, and maintain robust data pipelines and data solutions. You will work closely with business and IT stakeholders to transform raw data into actionable insights using modern cloud technologies and data warehousing standards.

Key Responsibilities:

• Analyze internally and externally sourced raw data to generate BI and advanced analytics datasets based on stakeholder requirements.
• Design and implement efficient data pipelines to curate sourced data into the in-house data warehouse.
• Develop data marts to facilitate dataset consumption from the in-house data warehouse by business and IT stakeholders.
• Implement data model changes in alignment with in-house data warehouse standards.
• Assist in planning and executing migration activities to transition data from existing database solutions to the in-house data warehouse.
• Perform regular housekeeping and optimization of raw data and datasets stored in the in-house data warehouse.
• Build, test, and maintain resilient data pipelines and data platforms.
• Develop data solution prototypes to support evolving business needs.
• Explore and implement methods to enhance data quality, consistency, and reliability.
• Identify opportunities to acquire higher-quality raw data sources.
• Develop and maintain analytical tools to support BI and advanced analytics activities.
• Execute end-to-end data migrations from legacy databases to the modern in-house data warehouse.
• Adhere to and promote data engineering standards and best practices within the team.

Qualifications

• Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or a related quantitative discipline.
• 3 to 5 years of hands-on experience in data engineering or a similar role (experience in the financial industry is a plus).
• Solid understanding or practical experience working within Enterprise Agile frameworks (e.g., Scrum, Kanban, SAFe).
• Solid understanding of ETL/ELT processes, data warehousing concepts, BI tools (e.g., Qlik), and advanced data analytics concepts.
• Knowledge of cloud-enabled technologies such as AWS (AWS Glue, AWS RDS, AWS Fargate, etc.).
• Practical experience with databases and cloud data warehouses, specifically Snowflake, PostgreSQL, and MS SQL.
• Strong programming skills with solid knowledge of Python and/or Java.

Certifications (Preferred / Advantageous):

• AWS Certified Data Engineer – Associate / Specialty or AWS Certified Solutions Architect – Associate
• Snowflake SnowPro Core Certification

Soft Skills:

• Excellent critical thinking, analytical, and problem-solving skills.
• Strong communication skills with a collaborative, team-oriented mindset.