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.
Location: San Francisco, CA
Posted: Aug. 9, 2024, 6:22 a.m.
Apply Now Company Website