Salesforce Technical Architect (35287)

Myticas Consulting; Vienna (VA); On-site; USD 120,000 - 150,000; Full time

Job summary

Myticas Consulting is seeking a Remote Salesforce Technical Architect for an upcoming project lasting over three months with a healthcare client. The role requires deep expertise in Salesforce Data Cloud and strong programming skills, particularly in Python and SQL.

You will build scalable ETL/ELT pipelines, ensure seamless data integration, and lead multiple architectural projects. This position is fully remote, offering flexibility for qualified candidates located in the United States.

Qualifications

• Deep technical knowledge of Salesforce Data Cloud and integration patterns.
• Expert-level programming skills in Python and advanced proficiency in SQL.
• Hands-on experience with major cloud data platforms.

Responsibilities

• Build and optimize scalable ETL/ELT pipelines.
• Lead architectural design for multiple data initiatives.
• Act as the Subject Matter Expert for Salesforce integration.
• Design automated validation frameworks.

Skills

Salesforce Data Cloud

Python (PySpark)

Advanced SQL

Snowflake

Databricks

Google BigQuery

Terraform (IaC)

CI/CD pipelines

Job description

Myticas Consulting has a client in need of a remote Salesforce Technical Architect for a 3+ months project with a Healthcare Client.

Role: Salesforce Technical Architect Start Date: July 26, 2026 Duration: 300+ Hours Location: Remote

Key Responsibilities

• Hands-on Pipeline Engineering: Build and optimize scalable ETL/ELT pipelines; take full ownership of the data environment to resolve complex defects with same-day urgency.
• Multi-Project Delivery: Concurrently lead architectural design and development for multiple critical data initiatives.
• Salesforce Integration: Act as the Subject Matter Expert for Salesforce Data Cloud, ensuring seamless data ingestion, transformation, and unified customer profiling.
• Automated Validation: Design and implement "Same-Day Comparison" frameworks to ensure data consistency between source systems and the cloud layer.

Must-Have Technical Skill Set

• Salesforce Ecosystem: Deep technical knowledge of Salesforce Data Cloud (Data 360 / Genie) and integration patterns with external data lakes.
• Programming: Expert-level Python (PySpark) and advanced SQL (window functions, performance tuning).
• Cloud Data Platforms: Hands-on mastery of Snowflake, Databricks, or Google BigQuery.
• DataOps & Architecture: Proficiency in Terraform (IaC) and CI/CD pipelines (GitHub/GitLab). Proven experience with Medallion (Lakehouse) or Data Vault 2.0 architectures.

Location/Region: Vienna, Virginia