Data Engineer II (L3)

What is Teachable?
Teachable is the platform for experts and businesses who take education seriously. In a world where anyone can ask AI for information, we're the home for those who educate with purpose, modernity, and humanity. We help experts and businesses scale their impact and operations through courses, coaching, and digital downloads that students actually love. From a finance expert teaching Python for investment analysis to a multilingual coach offering business Spanish for executives, Teachable powers human-led learning that drives student trust, connection, and results. With a sleek, intuitive interface and AI as a time-saving partner, the platform enables transformative education rooted in real-world experience. Teachable experts have lived it-that's why they teach it.Are you ready to join a dynamic, cross-cultural team at an exciting turning point in our company's journey?
Part of the global Hotmart Company portfolio, whose platforms have helped creators, experts, and businesses earn more than $10 billion, Teachable continues to cement itself as a true industry leader. Together, Teachable and Hotmart are delivering market-leading products that prioritize student outcomes, business growth, and flexibility. If you have big ideas, relish the chance to challenge convention, and deeply believe in the power of real-world learning to shape the future, we want you on our team!
About Your Team
At Teachable, our Data team aims to support company data-driven decision-making. Reporting to the Data Engineering Manager, you will work closely with our stakeholders, gather requirements, model data and support functions across Teachable's business.
What is the role?
We are seeking a skilled Data Engineer to join our dynamic Data team. The ideal candidate will have a comprehensive understanding of the data lifecycle from ingestion to consumption, with a particular focus on data modeling. This role will support various business domains, such as Product, Marketing and Finance, by organizing and structuring data to support robust analytics and reporting.
This role will be part of a highly collaborative corporate made up of US and Brazil-based employees.
In this role you'll:

• Data Ingestion to Consumption: Manage the flow of data from ingestion to final consumption. Organize data, understand modern data structures and file types, and ensure proper storage in data lakes and data warehouses.
• Data Modeling: Develop and maintain entity-relationship models. Relate business and calculation rules to data models to ensure data integrity and relevance.
• Pipeline Implementation: Design and implement data pipelines using preferrable SQL or Python to ensure efficient data processing and transformation.
• Reporting Support: Collaborate with business analysts and other stakeholders to understand reporting needs and ensure that data structures support these requirements.
• Documentation: Maintain thorough documentation of data models, data flows, and data transformation processes. Documentation also supports knowledge sharing, status updates with non-technical stakeholders.
• Collaboration: Work closely with other members of the Data Team and cross-functional teams to support various data-related projects.
• Quality Assurance: Implement and monitor data quality checks to ensure accuracy and reliability of data.

What You'll Bring

• 2+ years of experience working within Data Engineering, Analytics Engineering, Business Intelligence or similar functions.
• Fluent in English is a most
• Experience in database languages (PostgreSQL, Redshift, S3), indexing and partitioning to handle large volumes of data and create optimized queries and databases, and file manipulation and organization, such as Parquet.
• Experience with the "ETL/ELT as code" approach for building Data Marts and Data Warehouses.
• Experience with cloud infrastructure (AWS) and knowledge of solutions like Athena, Redshift Spectrum, SageMaker and Apache Airflow for creating DAGs.
• Experience with error and inconsistency alerts, including detailed root cause analysis, correction, and improvement proposals.
• Critical thinking for evaluating contexts and making decisions about delivery formats that meet the company's needs (e.g., materialized views, etc.).
• Knowledge in Python is a plus.

While Teachable maintains our NY office for local employees to use, we operate as a remote-first culture in order to give our employees added flexibility. In order to maintain connection and create a community beyond the screen, Teachable holds in-person events throughout the year, where employees and teams can come together for bonding, strategic alignment, goal-setting, and celebrations!
Teachable encourages individuals from a broad diversity of backgrounds to apply for positions. We are an equal opportunity employer, meaning we're committed to a fair and consistent interview process. Please tell us in your application if you require an accommodation to apply for a job or to perform your job.