Data Architect

VeeRteq Solutions Inc.; Irving (TX); Remote; USD 140,000 - 190,000; Full time

Job summary

VeeRteq Solutions Inc. is seeking a Sr. Data Architect to design enterprise data structures leveraging Snowflake and Coalesce, and to build scalable data pipelines with ADF and Python.

You will implement CDC architectures, ensure data lineage, and optimize Snowflake performance while leading governance and quality initiatives across cloud platforms. Remote USA role with strong cross-functional collaboration.

Qualifications

• 15+ years of experience in data engineering, warehousing, or architecture.
• 5+ years hands-on Snowflake experience.
• Proven expertise in CDC and incremental processing.
• Experience designing cloud-native data architectures.
• Experience with Git-based deployment and CI/CD.
• Strong data governance and data quality knowledge.

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.

Skills

Snowflake Architecture

Streams & Tasks

Incremental Data Processing

Data Governance

Data Quality

Performance Tuning

CDC Frameworks

Coalesce Transform

Metadata-Driven Pipelines

Data Lineage

Git-based Deployment

CI/CD Practices

Python Data Pipelines

Tools

Azure Data Factory

Snowflake

Coalesce

Git

CI/CD

Python

Job description

Requirement Details

• Position Title: Sr. Data Architect
• Work Mode: Remote USA

Candidate Eligibility

• Visa Requirement: Open
• Years of Experience Required: 15+ years

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.

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

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.

VeeRteq Solutions is an Equal Opportunity Employer