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

State Street

Senior Data Platform Architect at State Street overseeing end-to-end architectural governance of enterprise data platforms such as Snowflake and Databricks. Responsible for ensuring compliance and optimal scalability.

Posted 7/29/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 hybrid Snowflake and Databricks solutions, focusing on data warehousing, data lake designs, and open data platform strategies. Proficient in multi-cloud environments and data virtualization, with a strong foundation in data modeling and compliance within regulated industries.

Highest-signal resume keywords

Snowflake ArchitectureDatabricks EngineeringData VirtualizationMulti-Cloud StrategyData Modeling

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

SQLPythonJavaJavascriptScalaSparkApache IcebergDelta LakeData WarehousingData Lake

Tools & Technologies

SnowparkUnity CatalogTrinoDenodoControl-MAWSAzureGCPHorizon CatalogPolaris

Industry Keywords

Financial ServicesSOXMRAAuditNPPIPII

Tech Stack

Tools & technologies

ApacheAWSAzureCloudEC2ETLGoogle Cloud PlatformJavaJavaScriptLinuxOraclePythonScalaSparkSQLUnityUnix

About the role

Key responsibilities & impact

Define and govern the hybrid Snowflake–Databricks architecture to support classic Data Warehousing as well as Data Lake designs, aligning Snowflake's governed analytics layer with Databricks' engineering, streaming, and ML capabilities
Establish reference blueprints, patterns using lakehouse and medallion patterns suited for enterprise scale and auditability.
Contribute Designs, Patterns, Assets to SSIM Center of Excellence which establishes Best Practices for each platform as well as use cases for Reuse.
Lead Iceberg/Horizon/Unity Catalog interoperability across AWS, Azure, and GCP
Architect open data platform strategy leveraging Apache Iceberg, Delta Lake, Parquet, and Polaris/Unity Catalog to avoid vendor lock‑in and enable cross‑engine query
Define standards for open table format adoption, including:
Business Tool Access Protocols, Drivers, Standards
Naming Standards, Folder Structures, Cloud Storage Security
Schema evolution, partitioning, and time‑travel
Cross‑engine compatibility (Snowflake, Databricks, Trino, Spark, Athena)
Catalog federation across Horizon, Unity, Glue, and Polaris
Architect data virtualization patterns to enable logical access to data across Snowflake, Databricks, Oracle, SQL Server, and legacy NAS/file systems without physical movement
Lead architecture and solutioning for batch applications migrating from legacy platforms (Oracle, mainframe, Unix/Linux ETL, file‑based workflows) to Snowflake/Databricks.

Requirements

What you’ll need

Snowflake – WH Sizing, Object Hierarchy, Snowsight, RBAC, Horizon Catalog, governance, performance, data sharing, External Tables, Stages, Loading, SPs, Scripts, Snowpark
Databricks – Spark, Unity Catalog, ML pipelines, Delta/Iceberg, Lakehouse Federation
Open platforms – Apache Iceberg, Delta Lake, Parquet, Polaris, Trino/Starburst
Data virtualization – Denodo, Starburst, Snowflake/Databricks federation, logical data fabric
Batch modernization – Migration from Oracle/PL‑SQL, mainframe, Unix ETL, Control‑M to cloud‑native orchestration
Multi‑cloud – AWS, Azure, GCP (storage, IAM, networking, private link)
Data modeling – Kimbal, Denormalization, Dimensional, medallion schema patterns, bridge tables, marts, PK, FK, Clustering, and Tuning Implications
Languages – SQL, Python, Java, Javascript, Scala, Spark, Notebooks, Snowpark
LINUX – Must Know Linux, comfortable with EC2 servers, VI, cat, more etc.
Regulated industry experience – Financial Services, SOX, MRA, audit, NPPI/PII handling
Generative AI – Comfortable with Scripting and prompting.

Benefits

Comp & perks

Employees are eligible to participate in State Street’s comprehensive benefits program, which includes: our retirement savings plan (401K) with company match
Insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages
Paid-time off including vacation, sick leave, short term disability, and family care responsibilities
Access to our Employee Assistance Program
Incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans)
Eligibility for certain tax advantaged savings plans