Senior Data Architect

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

Job summary

Straive is seeking a Senior Data Engineer to architect and optimize data pipelines and the in-house data warehouse in the Philippines.

Lead design of data models, migrate from existing databases to Snowflake-based platforms, and ensure data quality while collaborating with analytics, IT, and business stakeholders in a fast-paced environment.

Qualifications

• Bachelor’s or Master’s degree in Computer Science, IT, Engineering, or related quantitative discipline from a top-tier university.
• Certified in AWS Data Engineer Specialty or AWS Solutions Architect Associate.
• Snowflake SnowPro Core Certification.
• 7+ years of experience in data engineering or a similar role, preferably in the financial industry.
• Strong understanding of Enterprise Agile frameworks (e.g., Kanban, SAFe, SCRUM).
• Solid understanding of ETL, data warehousing, BI (e.g., Qlik), and advanced data analytics concepts.

Responsibilities

• Analyze internally and externally sourced data to support BI and advanced analytics datasets.
• Design data pipelines to curate sourced data into the in-house data warehouse.
• Develop data marts to enable dataset consumption by business and IT stakeholders.
• Design data model changes aligned with in-house data warehouse standards.
• Plan migrations to transition data to the in-house data warehouse.
• Perform regular housekeeping of raw data and warehouse-stored data.
• Build and maintain data pipelines and data platforms.
• Develop data solution prototypes for evolving business needs.
• Explore methods to enhance data quality and reliability.
• Identify opportunities to acquire higher-quality raw data.
• Develop analytical tools to support BI and analytics.
• Execute data migration from existing databases to the in-house data warehouse.
• Promote and champion data engineering standards and best practices.

Skills

Data engineering

ETL

Data warehousing

Java

Python

SQL

Agile (Kanban/SAFe/SCRUM)

Communication

Education

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

AWS Data Engineer Specialty

AWS Solutions Architect Associate

SnowPro Core Certification

Tools

Snowflake

PostgreSQL

MS SQL

AWS Glue

AWS RDS

AWS Fargate

Qlik

Job description

• Analyze internally and externally sourced raw data to generate BI and advanced analytics datasets based on stakeholder requirements
• Design 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
• Design data model changes in alignment with in-house data warehouse standards
• Define and plan migration execution activities to transition data from existing database solutions to the in-house data warehouse
• Perform regular housekeeping of raw data and data stored in the in-house data warehouse
• Build and maintain data pipelines and data platforms
• Develop data solution prototypes to support evolving business needs
• Explore methods to enhance data quality and reliability
• Identify and pursue opportunities to acquire higher-quality raw data
• Develop analytical tools to support BI and advanced analytics activities
• Execute data migration from existing databases to the in-house data warehouse
• Promote and champion data engineering standards and best-in-class methodologies

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering, or a related quantitative discipline from a top-tier university
• Certified in AWS Data Engineer Specialty or AWS Solutions Architect Associate
• Snowflake SnowPro Core Certification
• 7+ years of experience in data engineering or a similar role, preferably in the financial industry
• Strong understanding or hands-on experience with Enterprise Agile frameworks (e.g., Kanban, SAFe, SCRUM)
• Solid understanding of ETL, data warehousing, BI (e.g., Qlik), and advanced data analytics concepts
• Deep knowledge of cloud-enabled technologies such as AWS RDS, AWS Fargate, etc.
• Experience with databases and data warehouses including Snowflake, PostgreSQL, and MS SQL
• Strong programming skills with advanced knowledge of Java and/or Python
• Practical experience with ETL tools such as AWS Glue
• Excellent critical thinking, analytical, and problem-solving skills
• Strong communication skills with a team-oriented mindset