Opportunity for impact
Newfire is seeking a Data Engineer
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.
- No-Silo Mentality: You don't just "drop data off"; you care about the final layer and are happy to build it to ensure project success.
- Test-First Mentality: Naturally thinking about how to test a pipeline or model before building it.
- Untangler Mindset: Enjoying the challenge of "untangling" ugly legacy code.
- Pragmatism: Ability to work from partial requirements while adhering to a strict Definition of Done.
