Data Architect with Snowflake, Coalesce, CDC, ADF | Long Term Contract Remote only

Tech Mirrors; New York (NY); Remote; USD 120,000 - 170,000; Full time

Job summary

Tech Mirrors seeks a Data Architect to design enterprise data architectures using Snowflake and Coalesce, with focus on CDC and incremental loads. Remote work available for a senior professional.

You will develop scalable data pipelines with ADF and Python, implement governance, CI/CD, and optimize costs while collaborating with stakeholders across teams.

Qualifications

• 10+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years of hands-on Snowflake experience.
• Strong experience implementing Coalesce-based transformations and data modeling.
• Proven expertise in CDC and incremental processing frameworks.
• Experience designing modern cloud-native data architectures.

Responsibilities

• Design enterprise data architectures leveraging Snowflake and Coalesce.
• Develop scalable data pipelines using ADF and Python.
• Implement CDC frameworks and incremental data processing strategies.
• Build metadata-driven and lineage-aware data transformation solutions.
• Optimize Snowflake performance, scalability, and cost.
• Establish data governance, data quality, and monitoring frameworks.
• Collaborate with stakeholders to define data strategies.
• Implement CI/CD deployment using Git and DevOps best practices.
• Support data integration across multiple source systems and cloud platforms.
• Drive architecture reviews and technical best practices across data programs.

Skills

Snowflake

Snowflake Data Warehouse Architecture

Streams & Tasks

Dynamic Tables

Data Sharing

Incremental Data Processing

Performance Tuning

Snowflake Security

Coalesce

Coalesce Transform

Coalesce Catalog

Coalesce Quality

Metadata-Driven Pipelines

Data Lineage

Git Deployment

SQL

Advanced SQL

CTEs/Recursive Queries

Window Functions

Data Processing

Python

API Integration

ETL/ELT

CDC

Delta Loads

ADB/ADF

Data Orchestration

Monitoring

Tools

Git

CI/CD

Azure Data Factory

Python

Job description

Job Title : Data Architect with Snowflake, Coalesce, CDC, ADF

Location: 100% Remote

Type: : Long Term Contract

Required Experience

• 10+ years of experience in Data Engineering, Data Warehousing, or Data Architecture.
• 5+ years of hands-on Snowflake experience.
• Strong experience implementing Coalesce-based transformations and data modeling.
• Proven expertise in CDC and incremental processing frameworks.
• Experience designing modern cloud-native data architectures.
• Experience with Git-based deployment and CI/CD practices.
• Strong understanding of Data Governance and Data Quality frameworks.

Required Skills

• Snowflake
• Snowflake Data Warehouse Architecture
• Streams & Tasks
• Dynamic Tables
• Data Sharing
• Incremental Data Processing
• Performance Tuning and Optimization
• Snowflake Security and Access Controls
• Coalesce
• Coalesce Transform
• Coalesce Catalog
• Coalesce Quality
• Metadata-Driven Data Pipelines
• Data Lineage and Impact Analysis
• Snowflake Integration
• Git-Based Deployment and Version Control
• SQL
• Advanced SQL Development
• Complex Joins
• CTEs and Recursive Queries
• Window Functions
• Analytical and Reporting Queries
• Query Optimization and Performance Tuning
• Python
• API Integration and Data Ingestion
• Data Processing and Transformation
• Workflow Automation
• ETL/ELT Framework Development
• Error Handling and Monitoring
• CDC (Change Data Capture)
• CDC Architecture and Design
• Delta Load Processing
• Timestamp-Based Incremental Loads
• Snowflake Streams-Based CDC
• Real-Time and Batch Data Processing
• Azure Data Factory (ADF)
• Pipeline Development
• Data Orchestration
• Parameterization
• Monitoring and Troubleshooting
• Integration Runtime Configuration
• Enterprise Data Integration Solutions

Key Responsibilities

• Design enterprise data architectures leveraging Snowflake and Coalesce.
• Develop scalable and reusable data pipelines using ADF and Python.
• Implement CDC frameworks and incremental data processing strategies.
• Build metadata-driven and lineage-aware data transformation solutions.
• Optimize Snowflake performance, scalability, and cost efficiency.
• Establish data governance, data quality, and monitoring frameworks.
• Collaborate with business stakeholders, architects, and engineering teams to define data strategies.
• Implement CI/CD deployment processes using Git and DevOps best practices.
• Support data integration across multiple source systems and cloud platforms.
• Drive architecture reviews and technical best practices across data programs.