Senior Data Platform Architect – Snowflake, Databricks, Open Platforms, Data Virtualization

State Street

. Own end-to-end architecture, security design, and governance of SSIM’s enterprise data platform .

Posted 10/30/2026full-timeBoston • Massachusetts • United StatesSenior💰 $120,000 - $202,500 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in architecting and governing enterprise data platforms, with a strong focus on Snowflake and Databricks integration, data security, and compliance with regulatory standards. Proficient in multi-cloud environments and data virtualization strategies to optimize performance and cost.

Highest-signal resume keywords

Snowflake ExpertiseDatabricks ExpertiseData Security ArchitectureMulti-Cloud IntegrationBatch Modernization Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SnowflakeDatabricksApache IcebergDelta LakeParquetSQLPythonJavaJavaScriptScala

Soft Skills

Team CollaborationCommunication Skills

Tools & Technologies

AWSAzureGCPControl-MLinux

Industry Keywords

SOX ComplianceMRAAuditFinancial ServicesData Protection Controls

Tech Stack

Tools & technologies

ApacheAWSAzureCloudEC2ETLGoogle Cloud PlatformJavaJavaScriptLinuxOraclePythonScalaSnowflakeSparkSQLUnityUnix

About the role

Key responsibilities & impact

Own end-to-end architecture, security design, and governance of SSIM’s enterprise data platform
Define and govern hybrid Snowflake–Databricks architecture for data warehousing and data lake use cases
Establish enterprise-scale lakehouse and medallion reference blueprints and patterns
Lead Iceberg, Horizon, and Unity Catalog interoperability across AWS, Azure, and GCP
Architect open data platform strategy using Iceberg, Delta Lake, Parquet, and Polaris/Unity Catalog
Define open table format standards for access protocols, drivers, naming, storage security, schema evolution, partitioning, time travel, and cross-engine compatibility
Govern regulated open-format workloads, including lineage, access control, and encryption
Drive interoperability between proprietary and open ecosystems
Architect data virtualization across Snowflake, Databricks, Oracle, SQL Server, and legacy NAS/file systems
Define federated query, virtual data product, and logical data fabric use cases
Establish performance, cost, security, and data-classification guardrails for virtualized access
Lead migration and solutioning of batch applications from Oracle, mainframe, Unix/Linux ETL, and file-based workflows
Define batch ingestion, orchestration, SLA, monitoring, rerun, rollback, logging, timeout, and warehouse-credit standards
Partner with application owners to retire legacy infrastructure during data-center exit and cloud migration programs
Identify outdated drivers and application versions that create security risks and advise application teams on upgrades
Architect and enforce data security, RBAC, row access policies, column masking, secure views, future grants, managed access schemas, network allowlisting, and cloud security integrations
Ensure compliance with SOX, MRAs, internal/external audits, and data protection controls
Maintain audit trails, lineage, and forensic traceability
Align with GCS data residency, isolation, and classification standards
Architect multi-cloud integrations across S3, ADLS, GCS, IAM, networking, and private links
Drive cross-region and cross-cloud high-availability/disaster-recovery designs
Serve as SME during architecture reviews and escalations
Partner with Security, Risk, Audit, Application, and Cloud Engineering teams
Produce architecture diagrams, design artifacts, executive presentations, and access models
Capture user feedback and provide distilled information to vendors

Requirements

What you’ll need

Experience supporting analytics, regulatory reporting, AI/ML, and batch application workloads
Snowflake expertise including warehouse sizing, object hierarchy, Snowsight, RBAC, Horizon Catalog, governance, performance, data sharing, external tables, stages, loading, stored procedures, scripts, and Snowpark
Databricks expertise including Spark, Unity Catalog, ML pipelines, Delta/Iceberg, and Lakehouse Federation
Experience with Apache Iceberg, Delta Lake, Parquet, Polaris, and Trino/Starburst
Experience with Denodo, Starburst, Snowflake/Databricks federation, and logical data fabric
Batch modernization experience migrating Oracle/PL-SQL, mainframe, Unix ETL, and Control-M to cloud-native orchestration
AWS, Azure, and GCP experience with storage, IAM, networking, and private link
Data modeling experience with Kimball, denormalization, dimensional and medallion schema patterns, bridge tables, marts, PK, FK, clustering, and tuning
Knowledge of SQL, Python, Java, JavaScript, Scala, Spark, notebooks, and Snowpark
Must know Linux; comfortable with EC2 servers, VI, cat, and related tools
Financial services experience, including SOX, MRA, audit, and NPPI/PII handling
Comfortable with scripting and prompting for generative AI
Good team and communication skills

Benefits

Comp & perks

Retirement savings plan (401K) with company match
Basic life insurance
Medical insurance
Dental insurance
Vision insurance
Long-term disability insurance
Optional additional insurance coverages
Paid vacation leave
Paid sick leave
Short-term disability
Paid family care responsibilities leave
Employee Assistance Program
Incentive compensation including eligibility for annual performance-based awards
Certain tax-advantaged savings plans
Inclusive development opportunities
Flexible work-life support
Paid volunteer days
Employee networks