Apolis logo

Senior Data Engineer

Apolis

  • San Diego, CA
  • 30+ days ago
  • Remote
  • $80–$90 Per Hour

Highlights

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.

Numbers & Facts

LocationSan Diego, CA (
Remote
)
IndustryComputer/IT Services
Salary$80–$90 Per Hour
Company Size500 to 999 employees
Websitehttps://www.apolisrises.com/

Description

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.

Benefits

Paid Sick Days, Employee Referral Program, Employee Events, Retirement / Pension Plans

About Company

Since 1996, RJT has provided successful SAP, Oracle, and IT consulting solutions and staffing services to clients around the world. The new Apolis brings you the same personalized service fortified with a greater array of IT solutions, global expertise, and cost-management strategies.

We are a global IT consultancy that seamlessly integrates experts and leading-edge solutions into your organization so you can focus on what really matters.

Similar Jobs

See more jobs