Mid-level Data Engineer

This is a fully remote position, open to applicants in Latin America.

📋 Description

• Develop and manage staging and intermediate dbt models within a medallion architecture.

• Apply entity resolution techniques utilizing ID and bridge tables for companies, contacts, and deals.

• Create and oversee AI-driven tagging models with Snowflake Cortex.

• Identify data quality concerns for further examination.

• Construct schema validation, row-count, nullability, and uniqueness tests for various models.

• Sustain source-system bridges and lookup tables.

• Modify models in response to changes in upstream systems.

• Ensure source YAML documentation is up to date, including lineage, freshness expectations, and schema notes.

• Supervise dbt Cloud jobs.

• Troubleshoot failed runs and examine data discrepancies, escalating issues as necessary.

• Present clean and well-documented pull requests for senior evaluation.

• Collaborate with a senior engineer who outlines the work while gradually taking on increased responsibilities.

⛳️ Requirements

• 2–4 years of experience in data engineering within a production setting.

• Proficient in SQL: multi-stage CTEs, window functions, and highly optimized queries.

• Familiarity with dbt, including models, tests, sources, and basic macros.

• Experience with Snowflake or comparable cloud data warehouses (BigQuery, Redshift, Databricks).

• Comfortable with dimensional modeling and layered (medallion) architectures.

• Skilled in Git and GitHub workflows: branching, pull requests, and code reviews.

• Strong written English skills and effective asynchronous communication with a remote team based in the US.

• Availability of at least 20 hours per week, with a minimum of 4 hours overlapping with US Eastern time (Monday to Thursday).

• Resume and all application materials should be submitted in English.

• Proficiency in Python for data validation or transformation logic (preferred).

• Experience with dbt macros and Jinja templating (preferred).

• Background in investment, financial, or alternative data (preferred).

🏝️ Benefits

• Flexible part-time work schedule.

• Fully remote position.

• Hands-on experience in a mature, production dbt and Snowflake codebase, including AI-powered models.

• Mentorship from senior data engineers and a clear trajectory towards greater ownership.

• A builder culture where engineers take the lead and deliver results.

• Engage in a variety of challenging projects spanning multiple industries.

• Flexible scheduling options.

• Unlimited Paid Time Off (PTO).

• Paid parental and bereavement leave.

• Opportunities to work with globally recognized clients, enhancing your resume.

• A top-notch team dedicated to learning and growth.