Newfire Global Partners
What’s the Project?
The Data Engineer is responsible for the “pipes” and the foundation within our Azure and Snowflake environment, but operates with a strong analytics engineering mindset. You will focus on building robust ingestion pipelines from diverse sources using Airbyte or Fivetran and translating legacy logic into clean, automated workflows. While your primary focus is the foundation (Bronze/Silver), you are part analytics engineer and are expected to build “Gold Layer” reporting models as delivery needs require.
Your day-to-day activities:
- Ingestion Management: Build and maintain ELT pipelines using Airbyte or Fivetran across APIs, files, and application databases.
- Proactive Testing: Implement comprehensive unit and integration tests (dbt tests, freshness checks) for every pipeline.
- Medallion Implementation: Build and maintain the Bronze (Raw) and Silver (Cleaned) layers on Snowflake using strict data quality gates.
- Cross-Functional Delivery: Support the creation of Gold-layer Star Schemas and reporting models when capacity requires.
- EDW Foundation: Collaborate with the Architect to build the foundational tables that support downstream analysis and the Semantic Layer.
- Legacy Translation: Interpret legacy scripts to migrate logic into the new stack with verified parity.
- As a Senior team member, you will be expected to actively participate in our hiring processes by serving on interview panels for future roles across the company.
You’re a perfect match if you have:
- Engineering Foundation: Strong background in data engineering with software engineering principles within Azure (Version control, CI/CD).
- Technical Stack: Expert proficiency in SQL, Snowflake, and dbt.
- Ingestion Tools: Experience with modern ELT tools like Airbyte or Fivetran.
- Hybrid Modeling Skills: Proficiency in building both technical foundation tables and end-user Star Schemas. Familiarity with Medallion Architecture.
- Data Quality: Experience with proactive testing; preference for candidates with TDD experience.
Originally posted on Himalayas
To apply for this job please visit himalayas.app.
About this role & career path
Working in Colombia
Colombia, officially the Republic of Colombia, is a country located in South America, with insular regions in North America. Colombia's mainland is bordered by the Caribbean Sea to the north, Venezuela to the east, Brazil to the southeast, Peru and Ecuador to the south and southwest, the Pacific Ocean to the west, and Panama to the northwest. Colombia is divided into 32 departments. The Capital District of Bogotá is the country's largest city hosting the main financial and cultural hub. Other urban areas include Medellín, Cali, Barranquilla, Cartagena, Bucaramanga, Pereira, Santa Marta, Cúcuta
More jobs at Newfire Global Partners
Keep exploring on Get A Job.ai
Not quite the right fit? Your next opportunity is a click away.
- Browse all jobs
- More jobs by category
- Remote jobs you can do from anywhere
- Research typical pay for this role
- Set a job alert so new matches reach you first
- Upload your resume to apply faster
Hiring instead? Post a job and reach candidates searching right now.