Data Engineer (Senior)

Myprospera; Colombia; Híbrido; COP 120.000.000 - 210.000.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Equity grant (4-year vesting)

Remote work stipend after 6 months

Flexible PTO

Equipment laptop provided

Descripción de la vacante

Myprospera is seeking a Senior Data Engineer to architect and build our data infrastructure from scratch. You will design a data warehouse, ETL pipelines, feature stores, and governance to support analytics and ML initiatives.

Join a small, well-funded team at a pivotal inflection point as we scale. You’ll work with Snowflake, dbt, Airflow (or Dagster/Prefect), and AWS to deliver robust, scalable data solutions.

Formación

• 5+ years of experience with modern cloud data warehouses (Snowflake strongly preferred).
• Extensive ETL/ELT pipeline development with strong SQL skills.
• dbt experience required; Airflow, Dagster, or Prefect for orchestration.
• Strong Python for data engineering tasks.
• AWS experience (S3, Glue, Athena, Redshift).

Responsabilidades

• Architect foundational data infrastructure from scratch.
• Set up Snowflake environments, security, and access controls.
• Create scalable architectural patterns for the company.
• Build robust pipelines from source systems to the data warehouse.
• Implement transformations with dbt and orchestrate with Airflow/Dagster.
• Integrate Fivetran connectors and custom extraction from Supabase.
• Design dimensional models and semantic layers for analytics and ML.
• Develop feature stores for real-time feature serving.

Conocimientos

5+ years experience with cloud data

ETL/ELT pipeline development

dbt experience

Airflow/Dagster/Prefect

Python

AWS (S3, Glue, Athena, Redshift)

Herramientas

Snowflake

Airflow

Dagster

Prefect

Fivetran

Supabase

Descripción del empleo

We're building Sophie, a multi-agent AI orchestrator that helps wealth management advisors deliver more personalized, effective service to their clients. Our platform analyzes behavioral patterns, communication preferences, and emotional states to transform how advisors understand and serve their clients. We're a small, well-funded team at an exciting inflection point — our technology works, customers love the product, and now we're building the engineering team to scale.

The Role

We're looking for a Senior Data Engineer to architect and build our data infrastructure from scratch. You'll create the foundation that powers everything from analytics to ML model training — data warehouse, ETL pipelines, feature stores, and the governance that makes it all maintainable. This is a senior role because we need someone who can design and build with minimal guidance. There's no existing data team to learn from — you're building the platform that everything else depends on.

What You'll Do

• Design and implement the foundational data infrastructure from scratch
• Set up Snowflake with proper environments, security, and access controls
• Create architectural patterns that scale with the company
• Build robust pipelines from source systems to the data warehouse
• Implement transformations with dbt and orchestrate with Airflow/Dagster
• Integrate Fivetran connectors and custom extraction from Supabase

Data Modeling

• Design dimensional models supporting both analytics and ML use cases
• Create semantic layers that make data accessible to stakeholders
• Implement slowly changing dimensions and proper data governance
• Build infrastructure feeding Sophie's machine learning capabilities
• Create feature stores for real-time feature serving

What We're Looking For

Must Have

• 5+ years experience with modern cloud data warehouses (Snowflake strongly preferred)
• Extensive ETL/ELT pipeline development with strong SQL skills
• dbt experience required; Airflow, Dagster, or Prefect for orchestration
• Strong Python for data engineering tasks
• AWS experience (S3, Glue, Athena, Redshift)

Great to Have

• ML pipeline experience (MLflow, Feast, feature stores)
• Fivetran or similar managed ELT tools
• Dimensional modeling expertise (Kimball methodology)
• Startup experience building data infrastructure from scratch
• Big data at scale (Spark, distributed computing)

How You Work

• Architectural thinker who balances immediate needs with long-term maintainability
• Self-directed and comfortable with high autonomy
• Strong communicator who can translate technical concepts for stakeholders
• Pragmatic about tradeoffs — knows when to build for scale vs. good enough

What This Role Is Not

• Not a Data Analyst role — you build infrastructure that enables analysis
• Not a Data Scientist role — you build ML pipelines; they build models
• Not a Backend Engineer role — you own the data layer, not the application layer

Base Competitive — Based on experience and location

Equity Meaningful early-stage grant with 4-year vesting

Equipment Professional laptop provided + remote work stipend after 6 months

Time Off Flexible PTO with minimum 15 days encouraged

Schedule Flexible hours with 3–4 hours daily overlap Americas timezones

Interview Process

1

Resume Review — 1–2 day turnaround

2

Technical Screen — 60 min video conversation with CTO

3

Architecture Exercise — 4–6 hours

4

Architecture Deep Dive — 90 min collaborative review

5

Values & Fit — 45 min conversation

6

References & Offer

Total timeline: 2–3 weeks