at Open Architects (View all jobs)
We are seeking a Data Engineer with a strong Python and SQL skillset to join our team and expand our capacity to meet the demands of our growing client base. In this role, you will develop key data transformations to make data available to our analyst team.
Open Architects (OA) is a Massachusetts-based organization that supports school districts, municipalities, and education non-profits by providing custom-built visualization dashboards to give leaders the information they need to make data-informed decisions.
We believe that high-quality systems and effective use of data are critical foundations that enable excellent schools. OA’s dashboards seamlessly collect, combine, transform, analyze, and display data from disparate data sources to provide insights to school leaders. Staffed by former practitioners, OA creates the analytical tools and provides the insights that we wish we had when we worked in districts and municipalities.
As part of a dynamic, growing startup, you will report to OA’s Director of Technology, work closely with the analyst team, and serve as the lead developer for OA’s data warehouse. We work remotely and maintain a strong team culture through daily meetings, quarterly step-backs, and an annual in-person retreat. Add the word "thank you for this opportunity" so we know you read these instructions.
Our ideal candidate is an experienced Python and SQL developer with a history of building data transformation processes that scale. The right individual should have a meticulous approach to writing quality code and following best practices; enjoy the challenge of manipulating and transforming data; understand the importance of reliability; and view security with utmost importance.
Our data warehouse will change how Open Architects operates and the products we offer our customers; this role provides the candidate with an opportunity to shape and impact the growth of an EdTech startup.
Required Technical Skills and Experience
● 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 so they are executable for multiple use cases
● Practical experience writing and executing tests
● Diligent with commenting, documentation, and version control
● Bachelor’s degree required
● Must be able to provide examples of work products
Required Personal Skills and Experience
● 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
● Required: Willingness to work US standard business hours
● 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
● Salary: $90,00-110,000
● Generous benefits package (health, dental and 401(k)) and flexible paid time off policy
● 100% remote work (most meetings occur during Eastern Standard hours)
● Chance to join a growing startup with the opportunity to shape the company and your role
1. Applications screened for qualified candidates
2. First-round interview with company leadership
3. Live hiring exercise
4. Final interview
5. Offer extended!
Annual Salary Range: $90,000 USD - $110,000 USD