Sr Global Data Warehouse Architect - New York
1 day ago
Job description
Data architecture is having a moment — and not everyone is ready for it.The platforms have matured, the AI tooling has caught up, and organizations that invest in the right foundations now will have an analytical edge that compounds for years.
This role is the person who builds that foundation.
We're looking for a Senior Global Data Warehouse Architect who combines deep platform expertise — Databricks, Snowflake, lakehouse architecture — with a forward-thinking approach to AI-assisted data engineering.
You'll design and deliver the enterprise data platform strategy for an elite international law firm with global offices, translating complex financial and operational data into reliable, high-performance analytics that leadership actually trusts.
This is a greenfield opportunity dressed in an enterprise context.The firm is serious about modernizing its data infrastructure, and you'll have the authority and the mandate to do it right — with best-in-class tooling, real executive buy-in, and a team that will listen to you.
Architecture meets AI-assisted engineeringThe ideal candidate doesn't just know how to model data — they know how to use AI-assisted tools to accelerate pipeline development, auto-generate documentation, surface data quality anomalies, and move faster without cutting corners.
Databricks Assistant, Snowflake Copilot, and LLM-assisted SQL and Python development aren't buzzwords here — they're expectations.WHAT YOU'LL DO
Platform Architecture & AI-Assisted Engineering
Design and implement enterprise-grade data architectures on Databricks and/or Snowflake, leveraging AI-assisted development tools — Databricks Assistant, Snowflake Copilot, Cursor, GitHub Copilot — to accelerate pipeline development and reduce time-to-delivery.
Build efficient, AI-augmented ELT/ETL workflows using Spark, Python, and SQL to ingest, transform, and curate large volumes of financial and operational data — using LLMs to generate boilerplate, suggest optimizations, and auto-document transformation logic.
Apply AI-driven anomaly detection and data quality tooling to proactively surface reconciliation issues before they reach reporting consumers.Evaluate and adopt emerging data platform capabilities — including generative AI features native to Databricks and Snowflake — as part of a continuous platform improvement mandate.
Data Modeling & GovernanceCreate and maintain dimensional, normalized, and semantic data models — star/snowflake schemas, 3NF, and data vault — to serve financial reporting, performance analytics, and forecasting use cases at global scale.
Lead integration design for Elite 3E, HRIS, and other core source systems, ensuring accurate reconciliation and tight alignment with enterprise warehouse schemas.
Enforce data governance policies, lineage tracking, and metadata standards across the platform — reducing time-to-insight while ensuring data consumers can trust what they're looking at.
Establish reusable model patterns and semantic layers that empower BI developers and finance analysts to self-serve without reinventing the wheel.
Performance, Cost & ScaleTune query performance, optimize compute and storage costs, and implement caching, partitioning, and clustering strategies — using AI-assisted profiling tools to identify bottlenecks faster.
Design for scale from day one: lakehouse architecture, Delta Lake, data tiering, and workload isolation across real-time and batch analytical workloads.
Drive measurable reductions in time-to-insight for finance and leadership teams through optimized pipelines and curated, pre-aggregated data models.Cross-Functional Leadership
Partner closely with data engineers, BI developers, finance analysts, and IT leadership to translate business requirements into scalable, well-documented data solutions.
Influence and align technical direction across teams — you can walk a CFO through a data model and a data engineer through a medallion architecture in the same afternoon.
Evaluate new tools, frameworks, and architectural patterns continuously, bringing recommendations with clear tradeoffs rather than just enthusiasm.WHAT WE'RE LOOKING FOR
Technical Foundation
8+ years in data architecture, data engineering, or BI engineering roles — with a clear progression toward platform ownership and architectural responsibility.
Hands-on experience architecting and delivering solutions on Databricks and/or Snowflake at enterprise scale.Strong proficiency in SQL, Python, and Spark — you write production-quality code, not just prototypes.
Deep understanding of data modeling principles: 3NF, star and snowflake schemas, data vault, and when to use each.
Proven experience designing data lakes and lakehouse architectures (Delta Lake, Iceberg, or equivalent).
Experience building data solutions for financial planning, billing, profitability, and time & expense analytics — ideally in a professional services context.
Cloud platform experience:
AWS, Azure, or GCP — with Databricks, Snowflake, S3, and Delta Lake in real production environments.
Experience delivering to Power BI, Tableau, or equivalent BI consumers.
AI Fluency — This Part Matters
We want someone who has moved beyond treating AI tooling as a novelty
Specifically:
You actively use AI-assisted tools — Databricks Assistant, Snowflake Copilot, Cursor, GitHub Copilot, or LLM-native workflows — as part of your real engineering practice.
You've used LLMs to accelerate SQL generation, pipeline documentation, transformation logic, or data quality rule authoring — and you know how to review that output critically.
You're tracking where AI-native data tooling is heading and can speak to what will matter in 12–24 months, not just what's available today.
Credentials (Preferred)Databricks Certified Data Engineer / Architect or Snowflake SnowPro Advanced:
Architect.
TOGAF or other enterprise data architecture credentials.
WHY THIS ROLE
$175,000-$195,000 + performance bonus
100% remote
Exceptional benefits package
Real investment in AI-native data tooling — Databricks, Snowflake Copilot, and beyond
Architectural authority — you're defining the platform, not inheriting someone else's decisions
Your work lands in front of firm leadership and finance teams at a global scale
Great data architecture is invisible when it works — and unforgettable when it doesn't.
Come build the kind that works.
Similar jobs
The State of New York is seeking a highly experienced Data Warehouse Architect. · Key Skills: Enterprise Data Warehouse Architecture, Master Data Management (MDM), Oracle Data Integrator (ODI), ETL Development, · Data Modeling (Normalized & Dimensional), COTS Integration, Kafka I ...
2 days ago
Data Warehouse Architect designs data warehousing, COTS and Custom business application integrations for a government agency. · 84 months experience architecting, designing, documenting and implementing. · Mastery of Oracle Data Integrator (ODI) and Extract Transform Load technol ...
2 days ago
Net2Source offers a wide gamut of consulting solutions customized to client needs including staffing training and technology. · ...
2 weeks ago
Dice is the leading career destination for tech experts at every stage of their careers. · Experience: 15+ years of IT experience with a focus on hands-on development and data architecture. · ...
2 weeks ago
Data Warehouse Architect with Master Data Management(MDM), Oracle Data Integrator (ODI) and Government agency Experience · The role involves architecting, designing, documenting, and implementing data warehousing, COTS and Custom business application integrations, and master data ...
2 days ago
The Lead Data Warehouse Developer is a senior-level individual contributor and team guide responsible for the architecture, development, and maintenance of our enterprise data warehouse. · This role bridges the gap between complex data engineering and business intelligence, ensur ...
1 month ago
We are seeking a Senior Global Data Warehouse Architect to design and deliver modern scalable and high-performing data platforms that enable advanced financial and operational analytics. · Design and implement enterprise-grade data architectures on Databricks Snowflake or similar ...
1 month ago
The Senior Global Data Warehouse Architect will be responsible for designing and delivering modern, scalable, and high-performing data platforms that enable advanced financial and operational analytics. · ...
1 week ago
We are seeking Senior Global Data Warehouse Architect to design and deliver modern data platforms that enable advanced financial and operational analytics. · Design and implement enterprise-grade data architectures on Databricks, Snowflake, or similar platforms for real-time and ...
2 weeks ago
We are seeking a Senior Global Data Warehouse Architect to design and deliver modern, scalable, and high-performing data platforms that enable advanced financial and operational analytics. · ...
1 month ago
A global professional services organization is seeking a Senior Enterprise Data Platform Architect to join its Technology organization. · Architect and implement scalable data platform solutions leveraging modern cloud data technologies to support both real-time and batch analyti ...
1 week ago
A global professional services organization is seeking a Senior Enterprise Data Platform Architect to join its Technology organization. This individual will play a key leadership role in shaping and modernizing the firm's enterprise data ecosystem to support complex financial and ...
1 week ago
Business Intelligence Solutions/Data Warehouse Architect
Only for registered members
The primary responsibility of Business Intelligence Solutions/Data Warehouse Architect will be to provide thought leadership and end-to-end solution architecture & design of large scale business Intelligence / data warehouse solution for the Office of School Support Services (OSS ...
1 week ago
+Job summary · Lead the design and implementation of end-to-end SAP Warehouse Management (WM) solutions. · +ResponsibilitiesEvaluate and optimize warehouse processes such as inventory management, goods movement, shipping, receiving, picking, and packing within SAP. · Create syste ...
1 month ago
We are looking for an experienced ETL/Data Project Manager to lead a Talend to Azure Data Factory (ADF) migration initiative within the Property & Casualty (P&C) Insurance domain.Strong experience managing ETL/Data migration projects · Solid P&C insurance domain knowledge · ...
3 days ago
The ideal candidate will have a strong background in designing, developing, and implementing complex projects, with a focus on cloud-based data warehousing and reporting solutions. · The Cloud Data Warehouse Architect is responsible for evaluating and selecting the most effective ...
3 weeks ago
Snowflake architect designing and developing robust data architecture solutions using Snowflake. · Design and develop robust data architecture solutions using Snowflake. · Collaborate with data engineering and analytics teams to optimize ELT/ETL workflows. · ...
3 weeks ago
N2S is seeking a Business Intelligence Architect to help lead the technical portion of this project. · ...
2 weeks ago
Data Modeling Architect needed to continue building NYSIF Enterprise Data Warehouse by consolidating legacy Data marts. · Create dashboards for claims/underwriting insight. · Develop prediction models in R/Python. · ...
1 month ago
We are supporting a confidential, enterprise-scale data transformation program and are hiring a GCP Data Architect to lead cloud data architecture and delivery on Google Cloud Platform. · ...
1 month ago