Newfire Global Partners

Data Engineer

Newfire Global Partners

full-time

Posted on:

Location Type: Remote

Location: Colombia

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

AzureSQL

About the role

  • Build and maintain ELT pipelines using Airbyte or Fivetran across APIs, files, and application databases.
  • Implement comprehensive unit and integration tests (dbt tests, freshness checks) for every pipeline.
  • Build and maintain the Bronze (Raw) and Silver (Cleaned) layers on Snowflake using strict data quality gates.
  • Support the creation of Gold-layer Star Schemas and reporting models when capacity requires.
  • Collaborate with the Architect to build the foundational tables that support downstream analysis and the Semantic Layer.
  • Interpret legacy scripts to migrate logic into the new stack with verified parity.
  • Actively participate in our hiring processes by serving on interview panels for future roles across the company.

Requirements

  • Strong background in data engineering with software engineering principles within Azure (Version control, CI/CD).
  • Expert proficiency in SQL, Snowflake, and dbt.
  • Experience with modern ELT tools like Airbyte or Fivetran.
  • Proficiency in building both technical foundation tables and end-user Star Schemas. Familiarity with Medallion Architecture.
  • Experience with proactive testing; preference for candidates with TDD experience.
  • You don't just "drop data off"; you care about the final layer and are happy to build it to ensure project success.
  • Naturally thinking about how to test a pipeline or model before building it.
  • Enjoying the challenge of "untangling" ugly legacy code.
  • Ability to work from partial requirements while adhering to a strict Definition of Done.
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
data engineeringSQLSnowflakedbtELT pipelinesAirbyteFivetranMedallion Architectureunit testingintegration testing
Soft Skills
collaborationproblem-solvingattention to detailadaptabilitycommunicationcritical thinkingproactive testingability to work with partial requirementsinterviewingproject success focus