Senior Data Solutions Architect

Johnson Service Group5 months ago
Calabasas, CA, United States
Remote
Full-time
Junior Level (1-3 years)

Job Description

Position Overview

JSG is seeking a Senior Data Solutions Architect for a client in Woodland Hills, CA. This position is remote with a preference for candidates based in Southern California. The Senior Data Solutions Engineer will design, scale, and optimize the company’s enterprise data platform by building and maintaining cloud-native data pipelines, lakehouse/warehouse architectures, and multi-system integrations supporting Finance, CRM, Operations, Marketing, and guest experience analytics.

The role focuses on creating secure, scalable, and cost-efficient systems while employing modern DevOps, ETL, and cloud engineering practices with hands-on expertise in data pipelines, orchestration, governance, and cloud infrastructure.

Compensation: $160K-$175K

Key Responsibilities

  • Design, build, and maintain ELT/ETL pipelines across Snowflake, Databricks, Microsoft Fabric Gen 2, Azure Synapse Analytics, and legacy SQL/Oracle platforms.
  • Implement medallion/lakehouse architecture, CDC pipelines, and streaming ingestion frameworks.
  • Leverage Python (90%) and SQL (10%) for data processing, orchestration, and automation.
  • Manage AWS and Azure multi-account environments, enforcing MFA, IAM policies, and governance.
  • Build serverless architectures (AWS Lambda, Azure Functions, EventBridge, SQS, Step Functions) for event-driven data flows.
  • Integrate infrastructure with CI/CD pipelines (GitHub Actions, Azure DevOps, MWAA/Airflow, dbt) for automated testing and deployments.
  • Deploy infrastructure as code using Terraform and Azure DevOps for reproducible, version-controlled environments.
  • Implement observability and monitoring frameworks (Datadog, Prometheus, Grafana, Kibana, Azure Monitor) to ensure system reliability, performance, and cost efficiency.
  • Collaborate with stakeholders to deliver secure, scalable, and cost-efficient data solutions.
  • Experience in Finance or consumer-facing industries is a plus.

Benefits & Perks

  • Medical, Dental, Vision, and Life Insurance options
  • Short-term disability
  • 401(k) plan
  • Weekly pay and more

Required Skills

Terraform
ETL/ELT Pipelines
Oracle
Cloud Infrastructure (AWS, Azure)
Data Orchestration
Python
Microsoft Fabric Gen 2
Databricks
SQL
Azure Synapse Analytics
Snowflake
CI/CD (GitHub Actions, Azure DevOps)
Serverless Architectures (AWS Lambda, Azure Functions)
Monitoring (Datadog, Prometheus, Grafana, Kibana)