Senior Data Engineer

Apolis

San Diego, CA(remote)

JOB DETAILS
SALARY
$80–$90 Per Hour
SKILLS
Best Practices, Cloud Computing, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cost Control, Cross-Functional, Customer Relations, Customer Support/Service, Data Analysis, Data Modeling, Data Warehousing, Database Extract Transform and Load (ETL), Dimensional Modeling, Ecosystems, Finance, Git, Leadership, Marketing, Performance Tuning/Optimization, Problem Solving Skills, Product Support, Production Systems, Python Programming/Scripting Language, Quality Assurance, Release Management/Engineering, Requirements Management, SQL (Structured Query Language), Sales, Scalable System Development, Snowflake Schema, Source Code/Configuration Management (SCM), Splunk, Standards Development, Star Schema, Team Player, Work From Home
LOCATION
San Diego, CA(remote)
POSTED
30+ days ago
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.

About the Company

A

Apolis

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.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Computer/IT Services
EMPLOYEE BENEFITS
Paid Sick Days, Employee Referral Program, Employee Events, Retirement / Pension Plans
WEBSITE
https://www.apolisrises.com/