Senior Data Engineer - Snowflake & Data Ingestion Architect

Siri InfoSolutions Inc; Raleigh (NC); On-site; USD 120,000 - 160,000; Full time

Job summary

Siri InfoSolutions Inc in Raleigh, NC is seeking a Data Engineer with 8+ years to own data pipeline architecture and deliver scalable Snowflake-based solutions across ingestion, transformation, and governance.

You will build Python ingestion frameworks, DBT models, and orchestrate workflows with Astronomer Airflow, GitLab, and CI/CD, while ensuring schema drift detection, controlled changes, and secure data masking.

Qualifications

• 8+ years of hands-on data engineering experience.
• Deep expertise with Snowflake, including data masking policies, RBAC, performance tuning, and advanced SQL.
• Strong experience with Qlik Replicate for CDC and database replication.
• Excellent proficiency in Python and Pyspark for ingestion frameworks and automation.
• Hands on experience with DBT Cloud and Astronomer Airflow.
• Experience with schema drift detection and schema evolution patterns.
• Experience with GitLab and CI/CD pipelines.
• Familiarity with Protegrity or similar data protection platforms.

Responsibilities

• Data Pipeline Architecture & Development.
• Design and implement scalable, resilient data pipelines using Snowflake features.
• Build and maintain DBT models with testing, documentation, and lineage.
• Develop Python ingestion frameworks for files and APIs, including schema validation and retries.
• Ingest CSV, fixed width, JSON, XML, Excel, and semi-structured formats.
• Coordinate schema changes through CI/CD workflows.
• Configure and manage Qlik Replicate tasks for CDC and full load replication.
• Implement and enforce data governance, security, and tokenization policies.
• Build and schedule workflows using Astronomer Airflow and integrate with GitLab/CI/CD.

Skills

Snowflake

Python

Pyspark

DBT Cloud

Astronomer Airflow

Qlik Replicate

GitLab

CI/CD

Protegrity

RBAC

Snowpipe

Streams

Dynamic Tables

SQL

Schema drift

Schema evolution

Oracle

SQL Server

DB2

Data Masking

Tools

Snowflake

Qlik Replicate

DBT Cloud

Astronomer Airflow

GitLab

Azure DevOps

Protegrity

Job description

Siri InfoSolutions Inc in Raleigh, NC is seeking a Data Engineer with 8+ years to own data pipeline architecture and deliver scalable Snowflake-based solutions across ingestion, transformation, and governance.

You will build Python ingestion frameworks, DBT models, and orchestrate workflows with Astronomer Airflow, GitLab, and CI/CD, while ensuring schema drift detection, controlled changes, and secure data masking.