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)