**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](https://www.loom.com/share/c57f9a8b0dfe4c0a92fcb26d1b10cba6) 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.
