Senior Data Engineer

Apolis is seeking a Senior Data Engineer with expertise in designing and building modern data platforms and analytics ecosystems. The role involves architecting data warehouses, developing scalable data pipelines, and collaborating with business 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

Requirements:

• 5+ years in Data Engineering, ETL/ELT development, or Data Architecture
• Expert-level SQL and strong experience with dbt Core/Studio
• 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