Senior Data Architect

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

Job summary

Straive in Taguig, Philippines, is seeking an experienced Data Engineer to design and implement data pipelines and data warehouses for BI and analytics. You will work across data sources, ensure data quality, and collaborate with business and IT stakeholders to deliver scalable solutions.

Qualifications include 7+ years in data engineering, AWS and Snowflake certifications, strong ETL and SQL skills, and experience with BI tools such as Qlik. Collaborative, agile mindset required.

Qualifications

• 7+ years of data engineering experience, preferably in the financial industry.
• Certified in AWS Data Engineer Specialty or AWS Solutions Architect Associate.
• Snowflake SnowPro Core Certification.
• Strong understanding of ETL, data warehousing, BI and advanced data analytics concepts.

Responsibilities

• Analyze internally and externally sourced data to generate BI and analytics datasets per 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 activities to move data to the in-house data warehouse.

Skills

ETL pipelines

Data modeling

BI concepts

Data quality

Agile (Kanban/SAFe/SCRUM)

Stakeholder communication

Data warehousing

Education

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

Tools

Snowflake

AWS Glue

AWS RDS

PostgreSQL

MS SQL

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