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

State Street

. Own end-to-end architecture, security design, and governance for 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 virtualization, and compliance with regulatory standards. Proficient in designing secure, scalable data solutions across cloud environments while ensuring performance and cost efficiency.

Highest-signal resume keywords

Snowflake ExpertiseDatabricks ExpertiseData Virtualization ExperienceBatch Modernization ExperienceFinancial Services Compliance

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

Apache IcebergDelta LakeParquetSQLPythonJavaJavaScriptScalaSparkLinux

Soft Skills

TeamworkCoordinationCommunicationKnowledge Sharing

Tools & Technologies

AWSAzureGCPDenodoStarburstControl-MEC2SnowsightRBACHorizon Catalog

Industry Keywords

SOXMRAAuditNPPIPIIData GovernanceData ResidencyData SecurityCloud MigrationData Modeling

Tech Stack

Tools & technologies

ApacheAWSAzureCloudEC2ETLGoogle Cloud PlatformJavaJavaScriptLinuxOraclePythonScalaSnowflakeSparkSQLUnityUnix

About the role

Key responsibilities & impact

Own end-to-end architecture, security design, and governance for SSIM’s enterprise data platform
Define and govern hybrid Snowflake–Databricks architecture for data warehousing, data lakes, engineering, streaming, and ML
Establish enterprise-scale lakehouse and medallion reference blueprints, patterns, and reusable assets
Lead Iceberg, Horizon, and Unity Catalog interoperability across AWS, Azure, and GCP
Architect open data platforms using Apache Iceberg, Delta Lake, Parquet, and Polaris/Unity Catalog
Define standards for business-tool access, drivers, naming, folder structures, cloud-storage security, schema evolution, partitioning, time travel, cross-engine compatibility, and catalog federation
Establish regulated-workload governance, including lineage, access control, and encryption
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
Set performance, cost, security, and classification guardrails for virtualized access
Lead architecture and solutioning for batch applications migrating from Oracle, mainframe, Unix/Linux ETL, and file-based workflows
Define batch ingestion, orchestration, SLA-driven processing, monitoring, rerun safety, legacy-code migration, and hybrid batch/streaming patterns
Establish batch performance, cost, and resiliency standards, including reprocessing, rollback, event logging, timeout limits, credit limits, and expensive-process detection
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
Design and enforce 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 and external audits, and data-protection controls
Maintain defensible audit trails, lineage, and forensic traceability
Align with data residency, isolation, and classification standards
Architect integrations across S3, ADLS, GCS, IAM, networking, and private-link patterns
Drive cross-region and cross-cloud high-availability/disaster-recovery designs
Act 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

Requirements

What you’ll need

Experience supporting workloads in analytics, regulatory reporting, AI/ML, and batch applications
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
Data virtualization 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 storage, IAM, networking, and private link experience
Data modeling knowledge including Kimball, denormalization, dimensional and medallion schema patterns, bridge tables, marts, primary keys, foreign keys, clustering, and tuning implications
Knowledge of SQL, Python, Java, JavaScript, Scala, Spark, notebooks, and Snowpark
Must know Linux; comfortable with EC2 servers and VI, cat, and similar tools
Financial services, SOX, MRA, audit, and NPPI/PII handling experience
Comfortable with generative-AI scripting and prompting
Good teamwork, coordination, communication, and knowledge-sharing 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
Paid sick leave
Short-term disability
Family care leave/responsibilities support
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