Senior Data Engineer (DBT)

Penbrothers International; Mandaluyong; Hybrid; PHP 900,000 - 1,500,000; Full time

Benefits offered by this job

Growth opportunities

Employee welfare

Global reach

Impact at scale

Job summary

Penbrothers collaborates with a fast-growing retail tech client to build and scale a Finance Data Warehouse in Snowflake. This hybrid, night-shift role blends hands-on data engineering with data modeling and strong business partnership.

You will own ELT pipelines from ERP/CRM sources, ensure data quality and governance for SOX, and enable analytics, dashboards in Tableau, and AI-driven finance insights across the organization.

Qualifications

• 5+ years in data engineering or data warehouse development.
• Proven Snowflake design, tuning, and cost optimization.
• Advanced SQL with complex queries.
• Experience with dbt for transformations and modeling.

Responsibilities

• Design, build, and maintain a Finance Data Warehouse in Snowflake for reporting and AI use cases.
• Develop and manage ELT pipelines using Fivetran and dbt to ingest and model data.
• Own finance data models (GL, revenue, expenses, vendors, customers) with accuracy and traceability.
• Collaborate with Finance, FP&A, and Analytics to translate requirements into scalable datasets.
• Ensure data integrity and reconciliation across source systems and reporting, SOX aligned.
• Optimize Snowflake performance and cost through design and transformations.
• Support dashboards in Tableau and future AI/data-mining initiatives.
• Monitor, troubleshoot, and improve data pipelines for reliability.
• Align with data architecture standards with platform teams.

Skills

Snowflake

SQL

ELT pipelines

Data warehousing

Dimensional modeling

Metadata management

Tableau

DBT

Finance systems

Strong communication

Tools

Fivetran

Snowflake

dbt

Job description

About Penbrothers

Penbrothers is an HR & remote talent management partner and one of the fastest-growing companies in the Philippines. We provide talented Filipinos with global opportunities in high-growth startups and dynamic companies, from the comfort of their own homes.

About the Client

Our client is revolutionizing the retail and grocery industry by providing a seamless, engaging shopping experience through its innovative mobile app. With millions of active users, they empower shoppers to earn rewards effortlessly and save on their everyday purchases. Join our dynamic team and contribute to shaping the future of shopping.

About the Role

We are looking for a Data Engineer to join our Financial Systems team and help design, build, and scale a Finance Data Warehouse that will serve as the foundation for financial reporting, analytics, compliance, and future AI-driven use cases.

This role will be instrumental in standing up a finance-specific data layer sourced from systems like NetSuite (ERP), Salesforce (CRM), billing platforms, vendor management tools, and other financial data sources. You’ll work closely with Accounting, Financial Operations, FP&A, and Data Analytics partners to ensure financial data is accurate, well-modeled, and analytics-ready.

This is a hybrid role that blends hands-on data engineering with thoughtful data modeling and close business partnership.

Work set-up: 100% Work from home

Work Schedule: Night Shift (Regular 9 hours per day, 5 days a week)

Work Hours: 11:00 PM – 8:00 AM (PH time)

What you’ll do (duties and responsibilities)

• Design, build, and maintain a Finance Data Warehouse in Snowflake, optimized for financial reporting, analytics, and AI/ML use cases.
• Develop and manage ELT pipelines using tools like Fivetran and dbt to ingest, transform, and model data from finance and business systems
• Own finance-specific data models (e.g., GL, revenue, expenses, vendors, customers) with a strong focus on accuracy, consistency, and traceability
• Partner with Accounting, Financial Operations, FP&A, and Data and other teams to translate business requirements into scalable data models and datasets
• Ensure data integrity, data quality, and reconciliation across source systems and downstream reporting
• Optimize Snowflake performance and cost through thoughtful warehouse design, query tuning, and efficient transformations
• Implement and maintain data governance, metadata management, and documentation to support SOX compliance and audit needs
• Support downstream use cases including Tableau dashboards, ad-hoc analytics, and future AI/data-mining initiatives
• Monitor, troubleshoot, and improve data pipelines to ensure reliability and timeliness
• Collaborate closely with other data engineers and platform teams to align with broader data architecture standards

What You Bring (skills, qualifications or experience)

• 5+ years of experience in data engineering or data warehouse development
• Strong hands‑on experience with Snowflake, including warehouse design, performance tuning, and cost optimization
• Advanced SQL skills with experience writing and optimizing complex queries
• Experience using dbt for data transformations, testing, and modeling
• Solid understanding of data warehousing concepts, dimensional modeling, and metadata management
• Experience building and maintaining reliable ELT/ETL pipelines in a cloud environment
• Experience preparing data for advanced analytics and AI/ML use cases
• Familiarity with BI tools such as Tableau and how they connect to data warehouses
• Strong communication skills and the ability to work closely with non‑technical finance stakeholders

Nice to Have (not required skills, but would be an added advantage)

• Experience working with financial systems such as NetSuite (ERP), billing platforms, or vendor management tools
• Exposure to SOX controls, audit support, or finance compliance requirements
• Experience using Snowflake features and AI/ML capabilities
• Python experience for automation, orchestration, or pipeline enhancements

Why This Role Matters

• You’ll help stand up a net‑new Finance Data Warehouse, not just maintain an existing one
• Your work will directly impact financial reporting accuracy, audit readiness, and executive decision‑making
• You’ll play a key role in enabling scalable analytics and future AI‑driven finance insights
• You’ll partner deeply with Finance while still working on modern data tooling and architecture

Our Hiring Process

We utilize AI tools to enhance hiring efficiency and ensure a fair evaluation. Consequently, candidates will engage with an AI Interviewer, supervised by Human Talent Acquisition Experts who will support your entire application journey.

Our AI Expectations: While we encourage you to use AI for CV refinement and research, we require that all interviews and assessments be completed through your own authentic effort. The use of real‑time AI assistance during interviews or to complete skills tests is strictly prohibited to ensure a fair and genuine evaluation of your capabilities.

What You’ll Get

At Penbrothers, we are obsessed with creating positive employee experiences. Here you’ll find an environment that nurtures learning and provides opportunities for growth. You’ll have the opportunity to make an impact on fast‑growing startups and dynamic companies.

• Meaningful work & Growth: We take every opportunity to stretch ourselves and deliver an excellent client experience.
• Employee as our biggest asset: We are genuinely invested in our people’s career and welfare.
• Global reach & local impact: Get to work with high‑growth startups and dynamic companies from the comfort of your own home.
• Powering global startups: We’ve created 1,400 Filipino jobs that empower global start‑ups to focus on growth.