Data Engineer
CodePath
CodePath is a national non-profit that is reprogramming higher education to create the most diverse generation of software engineers, CTOs, and founders. We deliver industry-vetted courses and career support centered on the needs of Black, Latino/a, Indigenous, and low-income students. Our students train with senior engineers, intern at top companies, and rise together to become the tech leaders of tomorrow. As of 2023, we've served 10,000 students a year nationwide, and we plan to scale up to ~100,000 students a year by 2028.
Founded in 2017, CodePath has taught over 26,000 students and delivered courses across over 110 universities. We are supported by some of the largest and most well-respected organizations, including Amazon, Andreessen Horowitz, Blue Meridian Partners, Comcast, Google, JP Morgan Chase, Knight Foundation, Meta, New Profit, and Salesforce, among others. In 2024, CodePath was recognized as one of the Most Innovative Companies in Education by Fast Company.
** We will never ask for bank information or for you to download any programs as part of our job application process and initial communications to applicants will be sent directly from our HR department.
About the role
Location: Remote, US
Duration: FTE
Reports To: VP of Product Engineering
Compensation: $120,000-$160,000 per year
We’re at a critical moment in our growth as an organization. 2024 is a year of incredible change at CodePath and we’re looking for the right data engineer to lead the charge on our small, skilled, and growing team in the next phase of our exponential growth and impact as we transform computer science education. Our platform overview is a must watch in order to understand the significance that our Data Engineering team will play in the actualization of our mission.
As an early hire in data engineering, you will collaborate with stakeholders across the organization to help build and maintain our next generation data infrastructure. In order to build out our data warehousing and ETL/ELT infrastructure the right way, we are looking for somebody resourceful with a problem solving mindset who is self-directed and able to work closely with data scientists, software developers, and business stakeholders. We expect this infrastructure, once built out, to be self-serve, accurate and secure/compliant as it enables all sorts of data science projects, ML modeling, and BI analysis across everything we do from the delivery of our courses, student marketing, sales and fundraising — which makes this a challenging, creative, and exciting technical position for an experienced data engineer.
The ideal candidate is a true early stage startup Data Engineer and is inspired by CodePath’s ambitious vision to transform education starting with computer science, and to train engineers who will generate over $1.5T in wealth for low-income communities within the next 20 years.
Key Activities
Architect and develop data platforms including data warehouses, analytic products, data lakes, ETL/ELT workflows, or data pipelines with minimal oversight
Design effective data models for analytics data use cases
Profile data sources and develop ETL/ELT processes with knowledge of data modeling fundamentals, using both SQL and supporting ETL/ELT tools (dbt, Airbyte, and others)
Develop and maintain data ingestion connectors to third-party services (Google Sheets, SurveyMonkey, HubSpot, Airtable)
Develop and maintain reporting dashboards and self-serve analytics tools in Tableau or other BI tools
Ensure architecture will support the requirements of the business by designing, implementing and maintaining a data quality assurance framework
Develop and maintain documentation for data collection processes and standards
Work with stakeholders across the organization to assist with data-related technical issues and support their data infrastructure needs.
Qualifications
2 to 5 years of relevant professional experience
Good understanding of data modeling principles including dimensional modeling, data normalization principles.
Substantial experience with SQL and building efficient data pipelines in SQL and tuning query performance
Experience managing cloud data warehouse such as Google BigQuery, Snowflake, Databricks, or Amazon Redshift
Experience with the tools we use, including Postgres, Airbyte, dbt, and Tableau
Thoughtful about making technical decisions and recommendations that serve the best interests of the organization, factoring in cost, complexity, maintenance burden, and outcomes
Has strong presentation skills: takes analysis and makes it understandable (and interesting!) for stakeholders
Additional Skills and Experience
Proven ability to drive projects from conception to completion.
Aptitude for problem-solving and troubleshooting.
Excellent communication and collaboration skills.
Ability to work in a fast-paced, startup environment.
Proactive, independent, responsible attitude with the ability to learn quickly.
Pay range
$120,000—$160,000 USD
Benefits
We offer a comprehensive benefits package for full-time employees that includes:
Medical, dental, and vision premiums paid at 90% for FT positions and their dependents
Flexible vacation and sick time policy with 12 company paid holidays plus a week long "winter break" office closure from Christmas to New Years. Employees take the time when they need it
Flexible workplace and work schedule
CodePath provides a laptop, monitor, and ergonomic office setup
Annual professional development stipend
Ability to voluntarily contribute pre and post-tax earnings to our 401k plan
Employer Provided Short Term Disability and 10 weeks paid leave to support our employees in growing their family
A commitment to developing leaders from within the organization
Frequent opportunities to connect with students, universities, and communities we serve
Opportunities to engage, collaborate and partner with top technology companies, venture capitalists, and engineering leaders
About the Current Team
We are individuals from a multitude of backgrounds, experiences, and unlikely stories, all connected by a single dream: a world in which regardless of background, socioeconomic status, gender, or race all people have pathways to reach their full potential.
With a staff and board that cares deeply about diversity and equity, we believe that diverse perspectives and backgrounds create a richer work environment and enhance our ability to pursue our mission.
Note: Research suggests that women and BIPOC individuals may self-select out of opportunities if they don’t meet 100% of the job requirements. We encourage individuals who believe they have the skills necessary to thrive at CodePath to apply for this role.
Full Time
Salary range:
$120,000 – $160,000