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 data platforms. The role involves architecting data warehouses, developing scalable dbt pipelines, and collaborating with stakeholders to deliver analytics-ready 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
Benefits
- Work_model: [remote]
Company Overview
Company H1B Sponsorship