Senior Data Engineer

Socium - Teams Done Differently; Philippines; On-site; PHP 900,000 - 1,300,000; Full time

Job summary

Socium - Teams Done Differently seeks a senior data engineer to analyze data and build scalable pipelines for BI and advanced analytics. You will curate data from multiple sources, design warehouse-ready data marts, and evolve data models in line with standards.

You will implement migration plans to move data to the in-house warehouse, maintain data quality, and champion best-practice engineering across cloud technologies like Snowflake and AWS.

Qualifications

• Bachelor's or Master’s degree in a related quantitative discipline.
• Certified in AWS Data Engineer Specialty or AWS Solutions Architect Associate.
• Snowflake SnowPro Core Certification.
• 7+ years of experience in data engineering or similar roles, preferably in finance.
• Strong understanding of Enterprise Agile frameworks (Kanban, SAFe, SCRUM).
• Solid understanding of ETL, data warehousing, BI (Qlik), and advanced data analytics concepts.
• Deep knowledge of AWS cloud technologies (AWS RDS, AWS Fargate).
• Experience with Snowflake, PostgreSQL, MS SQL databases.
• Strong programming skills in Java and/or Python.
• Practical experience with ETL tools such as AWS Glue.
• Excellent analytical and problem-solving skills.
• Strong communication and teamwork.

Responsibilities

• Analyze internally and externally sourced raw data to generate BI and advanced analytics datasets.
• 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
• Plan migration execution activities to transition data 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 opportunities to acquire higher-quality raw data
• Execute data migration from existing databases to the in-house data warehouse
• Promote and champion data engineering standards and best-in-class methodologies

Skills

Java

Python

ETL

Data warehousing

BI (Qlik)

Kanban

SAFe

SCRUM

Cloud technologies

Data quality

Analytical thinking

Team communication

Education

Bachelor’s or Master’s degree in Computer Science, Information Technology, Engineering

AWS Data Engineer Specialty

AWS Solutions Architect Associate

Snowflake SnowPro Core Certification

Tools

Snowflake

PostgreSQL

MS SQL

AWS RDS

AWS Fargate

AWS Glue

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