Senior Data Engineer
Apolis, New York, NY, United States
Senior Data Engineer
Duration : 12 months with extensions
Remote work
Senior Data Engineer
with experience in designing, building, and scaling modern data platforms, data warehouses, and analytics ecosystems. The ideal candidate has deep expertise in
dbt ,
Snowflake ,
cloud data warehousing ,
ETL/ELT pipelines , and
data modeling , along with a proven ability to partner with business stakeholders to deliver high-impact, analytics-ready data products.
This role is highly technical and hands-on, requiring strong SQL development, data architecture skills, and experience building governed, scalable transformation layers using modern data engineering best practices.
Data Architecture & Engineering
Architect, design, and build
end-to-end data warehouses
and analytics models across Sales, Marketing, Finance, Customer Support, and Product domains.
Develop scalable
dbt pipelines
using medallion architecture (bronze/staging, silver/intermediate, gold/marts).
Build
incremental models , optimize SQL transformations, and reduce compute costs through performance tuning.
Create
custom dbt macros
for data transformations and process standardization.
Implement
CI/CD workflows
for dbt deployments across Dev, QA, and Production environments.
Data Modeling & Governance
Design complex
dimensional models , semantic layers, and star/snowflake schemas for enterprise analytics.
Implement
dbt snapshots
to track SCD changes for customers, contracts, entitlements, and product adoption.
Meet with stakeholders to understand requirements and build Business views to support those needs.
Leadership & Collaboration
Act as the
dbt subject matter expert , you will help in defining standards and best practices.
Mentor junior and mid-level engineers, promoting engineering rigor and code quality.
Partner with Product Owners, Analysts, and business leaders to translate requirements into scalable technical solutions.
Required Skills & Experience
5+ years in Data Engineering, ETL/ELT development, or Data Architecture.
Expert-level SQL and strong experience with:
dbt Core/Studio
Snowflake
Strong understanding of
data warehousing ,
dimensional modeling , and
governance .
Experience with
Git
for version control and release management.
Excellent communication, problem-solving, and cross-functional collaboration skills.
Preferred Qualifications
Experience working with SnapLogic.
Background in building customer-facing data products.
Experience with observability tools (Splunk).
Proficiency in
Python.
Experience with
Databricks
development.
Duration : 12 months with extensions
Remote work
Senior Data Engineer
with experience in designing, building, and scaling modern data platforms, data warehouses, and analytics ecosystems. The ideal candidate has deep expertise in
dbt ,
Snowflake ,
cloud data warehousing ,
ETL/ELT pipelines , and
data modeling , along with a proven ability to partner with business stakeholders to deliver high-impact, analytics-ready data products.
This role is highly technical and hands-on, requiring strong SQL development, data architecture skills, and experience building governed, scalable transformation layers using modern data engineering best practices.
Data Architecture & Engineering
Architect, design, and build
end-to-end data warehouses
and analytics models across Sales, Marketing, Finance, Customer Support, and Product domains.
Develop scalable
dbt pipelines
using medallion architecture (bronze/staging, silver/intermediate, gold/marts).
Build
incremental models , optimize SQL transformations, and reduce compute costs through performance tuning.
Create
custom dbt macros
for data transformations and process standardization.
Implement
CI/CD workflows
for dbt deployments across Dev, QA, and Production environments.
Data Modeling & Governance
Design complex
dimensional models , semantic layers, and star/snowflake schemas for enterprise analytics.
Implement
dbt snapshots
to track SCD changes for customers, contracts, entitlements, and product adoption.
Meet with stakeholders to understand requirements and build Business views to support those needs.
Leadership & Collaboration
Act as the
dbt subject matter expert , you will help in defining standards and best practices.
Mentor junior and mid-level engineers, promoting engineering rigor and code quality.
Partner with Product Owners, Analysts, and business leaders to translate requirements into scalable technical solutions.
Required Skills & Experience
5+ years in Data Engineering, ETL/ELT development, or Data Architecture.
Expert-level SQL and strong experience with:
dbt Core/Studio
Snowflake
Strong understanding of
data warehousing ,
dimensional modeling , and
governance .
Experience with
Git
for version control and release management.
Excellent communication, problem-solving, and cross-functional collaboration skills.
Preferred Qualifications
Experience working with SnapLogic.
Background in building customer-facing data products.
Experience with observability tools (Splunk).
Proficiency in
Python.
Experience with
Databricks
development.