[Remote] Sr. Data Engineer
Note: The job is a remote job and is open to candidates in USA. Apolis is seeking a Senior Data Engineer with extensive experience in designing and building modern data platforms. The role involves architecting data warehouses, developing scalable pipelines, and collaborating with stakeholders to deliver impactful data products.
Responsibilities
- 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
- 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
- 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
Skills
- 5+ years in Data Engineering, ETL/ELT development, or Data Architecture
- Expert-level SQL and strong experience with dbt Core/Studio
- Strong experience with 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
- Experience working with SnapLogic
- Background in building customer-facing data products
- Experience with observability tools (Splunk)
- Proficiency in Python
- Experience with Databricks development
Company Overview
Company H1B Sponsorship