Senior Data Engineer

Straive; Taguig; On-site; PHP 1,800,000 - 2,400,000; Full time

Job summary

Straive is seeking a Senior Data Engineer to architect and implement scalable data pipelines, ETL processes, and data models for BI and Advanced Analytics. You will integrate Snowflake, AWS services, and multiple databases to support financial analytics across teams.

The role requires 7+ years in data engineering, solid knowledge of data warehousing, and strong programming in Java or Python. Collaboration with cross-functional teams and adherence to best practices are essential.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline from a top tier university.
• Certified in AWS Data Engineer Specialty or AWS Solution Architect Associate
• Snowflake SnowPro Core Certification
• 7+ years of experience in data engineering or relevant role, preferably in financial industry
• Strong understanding of Enterprise Agile Frameworks (Kanban, SAFe, SCRUM)
• Strong understanding of ETL, data warehouse and BI (Qlik) and Advanced Data Analytics concepts
• Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate
• Experience with Snowflake, PostgreSQL, MS SQL
• Strong programming skills with Java and/or Python
• Experience with ETL tools such as AWS Glue
• Strong analytical and communication skills

Responsibilities

• Analyze data to generate BI and Advanced Analytics datasets based on stakeholders’ requirements
• Design data pipelines to curate sourced data into the inhouse data warehouse
• Design data marts for dataset consumption by business and IT stakeholders
• Define migration activities to move data to the inhouse warehouse
• Build and maintain data pipelines and data platforms
• Promote data engineering standards and best practices
• Develop analytical tooling to support BI and Advanced Analytics
• Execute data migration from existing databases to the warehouse

Skills

Java

Python

ETL

Data Warehousing

BI

Agile Methodologies

Data Modeling

Data Quality

Problem Solving

Communication

Education

Bachelor’s or Master’s degree in Computer Science / IT / Engineering or related quantitative discipline

Tools

Snowflake

PostgreSQL

MS SQL

AWS Glue

AWS RDS

AWS Fargate

Qlik

Job description

You will have the following responsibilities:

Design

• Analyze relevant internally and externally sourced data (raw data) to generate BI and Advanced Analytics datasets based on your stakeholders’ requirements
• Design data pipelines to curate sourced data into the inhouse data warehouse
• Design data marts to facilitate dataset consumption out of the inhouse data warehouse by business and IT internal stakeholders
• Design data model changes that align with the inhouse data warehouse standards
• Define migration execution activities to move data from existing database solutions to the inhouse data warehouse
• Regular housekeeping of raw data and data stored in the inhouse data warehouse
• Build and maintenance of data pipelines and data platforms
• Build data solution prototypes
• Explore ways to enhance data quality and reliability
• Identify and realize opportunities to acquire better data (raw data)
• Develop analytical tooling to better support BI and Advanced Data Analytics activities
• Execute data migration from existing databases to the inhouse data warehouse
• Promote and champion data engineering standards and best-in-class methodology

You will have the following qualifications:

• Bachelor’s or master’s degree in Computer Science, Information Technology, Engineering or related quantitative discipline from a top tier university.
• Certified in AWS Data Engineer Specialty or AWS Solution Architect Associate
• Snowflake SnowPro Core Certification
• 7+ years of experience in data engineering or relevant working experience in a similar role, preferably in the financial industry
• Strong understanding or practical experience of at least one common Enterprise Agile Framework e.g., Kanban, SAFe, SCRUM, etc.
• Strong understanding of ETL, data warehouse and BI(Qlik) and Advanced Data Analytics concepts
• Deep knowledge of cloud-enabled technologies – AWS RDS and AWS Fargate, etc.
• Experience with databases and data warehouses - Snowflake, PostgreSQL, MS SQL
• Strong programming skills with advanced knowledge of Java and/or Python
• Practical experience with ETL tools such as AWS Glue, etc.
• Strong critical-thinking, analytical and problem-solving skills
• Excellent communicator with team-oriented approach