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

A Massachusetts-based organization that supports school districts, municipalities and education non-profits by providing visualization dashboards to give leaders the information they need to make data-informed decisions. They provide an open, collaborative team environment, where diverse perspectives and backgrounds are valued.

About the Role

We're looking for someone with strong Python and SQL skills who is excited to transform messy data into clean, usable datasets. You'll play a key role in making high-quality data available to our analyst team, and ultimately to our clients.

As part of our growing, remote-first team, you'll report to the Director of Product and help develop and maintain the core data infrastructure that powers our analytics platform. Your primary responsibility will be writing Python and SQL code to transform raw data from client systems into clean, standardized datasets, which are then loaded into our Big Query data warehouse. We're looking for someone with a track record of building scalable data transformation processes. You should take pride in writing clean, reliable code and enjoy the challenge of making messy data usable.

• Ability to work in a fully remote environment (Slack, Zoom)

• Works well with internal stakeholders and can translate needs into technical solutions

• Self-motivated and able to independently structure work time to achieve assigned objectives

• Excited to work in a collaborative team environment with a flat and flexible organizational structure

• Adheres to the utmost ethical standards in preserving confidentiality with client data

• Works effectively with diverse stakeholders including school and district leaders

Other Preferred Skills and Experience

• Willingness to attend meetings during US standard business hours at least two days a week

• 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

What You Bring

• 3+ years of experience as a data engineer with Python and SQL as the primary toolset

• 2+ years of experience working with BigQuery (or another columnar database)

• Strong understanding of Object-Oriented Programming and the ability to write, maintain, and extend an application

• Proficiency with Pandas (current solution is built around Pandas)

• Demonstrable experience working with, transforming, and loading large data sets (10's of millions of records)

• Strong understanding of error handling, logging, and alerting for reliability

• Ability to write configurable and extendable ETLs

• Diligent with commenting, documentation, and version control

• Bachelor's degree required

Hiring Process

We utilize AI tools to enhance our hiring efficiency and ensure a fair evaluation of all candidates. As a result, candidates who passed our initial evaluations should expect an AI Interviewer as a component of our recruitment process. This is supervised by Human Talent Acquisition Experts who will also engage with you throughout your application journey.

Don't meet every single requirement? At Penbrothers we are committed to building a diverse, inclusive, and authentic workplace, so if you're excited about this role but you don't feel 100% aligned with the qualifications, we encourage you to apply anyway. You may just be the right fit for this or other roles.

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.