Sr. Data Engineer
Job Description
Overview
We are hiring a Senior Data Engineer to own and evolve our analytics data platform. The infrastructure is already in place (PostgreSQL, Airflow, Jupyter, SQLMesh). The focus of this role is not server setup or hardware maintenance, but building robust pipelines, high-quality data models, and scalable transformation workflows. You will work closely with three data analysts and partner directly with departments like Marketing or Sales to ensure reliable, well-structured datasets power reporting and analysis in Sigma.
Responsibilities
Data Pipeline Development
Build and maintain ingestion pipelines from multiple sources, including: Aircall, HubSpot, Internal proprietary applications
Implement reliable, testable transformation workflows using SQL Mesh
Orchestrate and monitor jobs in Airflow
Ensure incremental, performance, and maintainable data pipelines
Data Modeling & Transformation
Design analytics-ready data models in PostgreSQL
Develop clean, well-documented dimensional models
Optimize queries and warehouse performance
Establish transformation best practices and review standards
Marketing Data Enablement
Work closely with Marketing stakeholders to understand attribution, funnel, campaign, and performance requirements
Translate business requirements into scalable data models
Prepare curated datasets for Marketing analysts