Senior Data Engineer

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 - 11:00 PM to 8:00 AM PH time (aligned with US Business Hours/US Central 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)

• Minimum of 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 & AI Disclaimer: We use AI tools to streamline our application process—including an initial