Designs and leads modern, scalable data platforms using Snowflake, dbt, and AWS. Responsibilities include data modeling, batch and streaming pipelines, governance, security, privacy, migration from legacy systems, deployment automation, observability, testing, and enterprise reporting. The role collaborates with technical and business stakeholders, establishes architectural standards, mentors data engineers, and guides platform modernization while balancing performance, maintainability, scalability, and cost.
About the Role: We're seeking a strategic and hands-on Data Architect to design and implement scalable, secure, and modern data solutions across our organization. You'll play a critical role in leading the modernization of our data ecosystem using dbt, building a foundation for real-time analytics and enterprise-scale reporting in the cloud.
Responsibilities
- Architect and evolve our data platform using Snowflake as the central data warehouse and dbt for transformation logic.
- Design and implement batch and streaming pipelines, ensuring scalability and cost-efficiency in AWS.
- Establish best practices for data modeling, warehouse schema design, and semantic layer standardization using dbt.
- Define and enforce data governance, security, and privacy policies in alignment with compliance frameworks.
- Lead data migration from legacy sources to AWS; work closely with DevOps to automate and secure deployment processes.
- Collaborate with engineering, product, and business stakeholders to understand data needs and align solutions with business goals.
- Mentor and guide data engineers; support code reviews, architectural reviews, and team upskilling.
Qualifications:
- 8+ years in data architecture, with deep experience owning a modern data platform end to end: pipelines, storage, modelling, governance, monitoring.
- Expertise in data modeling (3NF, star/snowflake schemas), ELT/ETL design, and performance tuning.
- Solid understanding of AWS services (S3, Glue, Lambda, Redshift, Kinesis, etc.).
- Strong programming in SQL and Python; experience with CI/CD and data testing in dbt.
- Knowledge of data governance, lineage, metadata management, and data quality frameworks.
- Experience working with streaming technologies (Kafka, Kinesis) and large-scale datasets.
- Has modernised platforms and run migrations while keeping live systems running.
- Brings documentation, data quality, observability and testing as a default while balancing scalability, performance, maintainability and cost.
- Designs architecture and makes the technology calls, not just implements them. Sets common patterns and standards across application teams.
- Works comfortably across both engineering and business.
- Experience in platform modernization and cloud migration projects.
- Familiarity with tools like Airflow, Terraform, Great Expectations, or Monte Carlo.
Preferred Skills:
BlueMatrix New York, New York, USA Office
853 Broadway, New York, New York, United States, 10003 4703
Similar Jobs
Artificial Intelligence • Big Data • Cloud • Information Technology • Machine Learning
Leads the architecture, design, and implementation of scalable GCP and Databricks data lakehouse platforms. Designs real-time and batch pipelines, data models, governance, cataloging, security, and performance optimization. Advises clients, translates business requirements into technical solutions, leads project teams, mentors engineers, reviews architectures, and balances strategic planning with hands-on proof-of-concept and troubleshooting work.
Top Skills:
Apache AirflowBiglakeBigQueryData CatalogDatabricksDataplexDelta LakeGoogle Cloud Platform (Gcp)Google Cloud Storage (Gcs)IamPub/SubUnity Catalog
Information Technology
Lead the architecture and implementation of enterprise-scale Azure data and AI platforms, including data lakes, lakehouses, warehouses, integrations, machine learning, and generative AI solutions. Establish governance, security, MLOps, and AI frameworks; guide cloud modernization, migration, performance, and cost optimization. Translate business needs into technical architectures, present recommendations to executives, lead architecture reviews, support client pursuits, and mentor engineering teams.
Top Skills:
Arm TemplatesAzure Ai FoundryAzure Ai ServicesAzure Data FactoryAzure Data Lake Storage Gen2Azure DatabricksAzure Kubernetes ServiceAzure Machine LearningAzure Openai ServiceAzure SqlAzure Synapse AnalyticsBicepCi/CdContainerizationDevOpsLarge Language ModelsMicroservicesAzureMicrosoft FabricMicrosoft PurviewMlopsPrompt EngineeringPysparkPythonRetrieval Augmented GenerationSparkSQLTerraformVector Databases
Information Technology • Software
Lead enterprise data architecture across multiple SaaS products by unifying reporting platforms, data models, and analytics capabilities. Assess current systems, define target-state architecture, establish data governance and quality standards, separate analytical workloads from transactional systems, and develop phased migration roadmaps. Guide database, engineering, and BI teams on cloud platforms, integration, modeling, performance, security, and reliability. Enable trusted cross-product reporting, governed self-service analytics, and data foundations for AI and advanced analytics.
Top Skills:
APIsAWSAzureBusiness IntelligenceChange Data CaptureData LakesData WarehousesEltETLGCPLakehousesMicrosoft Sql ServerPostgresSemantic ModelsSnowflakeSQL
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
