Senior Data Engineer (Python / Full Remote)

Penbrothers International; Philippines; Remote; PHP 900,000 - 1,300,000; Full time

Job summary

Penbrothers International seeks a Data Engineer to design and scale configurable ETL frameworks for a multi-tenant analytics platform. You will build data pipelines using Python, Polars and Pandas, and optimize BigQuery workloads, enabling data-informed decisions for educational clients.

You will work 100% remotely with night hours aligned to US Eastern Time, collaborating with internal stakeholders and ensuring robust testing, logging, and documentation practices.

Qualifications

• Minimum 5 years in Data Engineering.
• Primary tools are Python and SQL.
• Experience architecting modular, scalable ETL pipelines.

Responsibilities

• Architect modular data pipelines using Python and SOLID principles.
• Build data transformations with Polars and Pandas.
• Manage BigQuery infrastructure: partitioning and performance.
• Create YAML/JSON configuration-driven pipelines for multi-client onboarding.
• Ensure software quality with pytest, logging, and documentation.

Skills

Python

SQL

OOP concepts

Design patterns

Unit testing

Logging

CI/CD

Type hints

Git workflows

Tools

Polars

Pandas

BigQuery

Snowflake/Redshift

Docker

Job description

About the Role

Are you a Software Engineer at heart who loves solving complex data infrastructure problems Do you treat data pipelines as production software complete with clean object-oriented architecture, modular design patterns, robust unit testing, and abstract base classes

We are looking for a Data Engineer to help us build and scale our custom analytics and visualization platform supporting educational leaders, school districts, and non-profits. You won't just be writing standard SQL transformations or top-to-bottom Pandas s; you will architect configurable, extendable, and multi-tenant ETL frameworks that power data-informed decision-making across dozens of organizations

Work Set-up: 100% Work from home

Work Schedule: Night Shift - 9:00 PM to 6:00 AM PH time (aligned with US Business Hours/US Eastern Time)

What You'll Do (Responsibilities)

• Architect Modular Data Pipelines: Design code-first, object-oriented Python frameworks using SOLID principles to ingest, clean, and standardize high-volume data sets across multiple diverse client schemas.
• Leverage Modern In-Memory Engines: Build high-performance data transformation workflows using Polars and Pandas.
• Manage BigQuery Infrastructure: Optimize columnar warehouse models, partitioning schemes, and query performance in Google BigQuery.
• Build Configurable Frameworks: Develop YAML/JSON configuration-driven pipelines that allow new client onboardings without rewriting core ETL code.
• Enforce Software Quality: Write unit tests using pytest, mock external data connections, establish structured logging/alerting (loguru/custom exceptions), and maintain immaculate version control and documentation.

What We're Looking For (Technical Skills and Experience)

• Minimum of 5 years in Data Engineering with Python and SQL as your primary toolset.
• Strong Object-Oriented Background: Proven experience applying OOP concepts (custom classes, inheritance, abstraction, design patterns like Factory/Strategy) to data pipelines.
• Hands-On Polars & Pandas Expertise: Deep experience manipulating and transforming large data frames efficiently.
• At least 2+ years with BigQuery (or equivalent columnar databases like Snowflake/Redshift).
• Software Hygiene: Production experience with pytest, Git workflows, CI/CD, type hinting, and structured exception handling.

Soft Skills

• Ability to work in a fully remote environment (Slack, Zoom)
• Works well with internal stakeholders and can translate needs into technical solutions
• Excited to work in a collaborative team environment with a flat and flexible organizational structure
• Works effectively with diverse stakeholders including school and district leaders

Nice to Have

• EdTech and/or student data experience
• Familiarity with Power BI (our analysts use this extensively)
• Experience working in a Linux environment and with Docker images/containers