Senior Data Platform Engineer – Snowflake & Data Modeling

Scion Staffing; Addison (TX); On-site; USD 135,000 - 145,000; Full time

Benefits offered by this job

Employee benefits package

High-impact opportunity to help build"

Broad ownership across Snowflake, dbt,

Collaborative environment to mentor

Job summary

Scion Staffing has been engaged to conduct a search for a Senior Data Platform Engineer for an on-site role in Addison, Texas. This hands-on position builds and operates a modern Snowflake data platform, develops ingestion pipelines, dbt transformations, and governance controls to turn sensitive data into trusted business insights.

The role requires at least 5 years in data engineering, experience with medallion architecture, Python, and orchestration tools; you will own production data

Qualifications

• Minimum of 5 years of experience in data engineering or a related role.
• Experience with dbt, medallion architecture, modern ELT patterns, and a cloud data warehouse (Snowflake preferred).
• Experience building ingestion pipelines from SQL DBs and SaaS/API sources (REST, ODBC, SFTP, file feeds, CDC).
• Proficiency with Python and orchestration/integration tools (ADF, Dagster, Airflow, Prefect, Snowpipe).
• Experience implementing access/security controls for sensitive data (RBAC, masking, row-level access, audit logs).
• Demonstrated ability to own a production data platform within a small team (security, performance, cost).

Responsibilities

• Onboard data from SQL Server databases and SaaS sources using REST APIs, ODBC, SFTP, file feeds, and CDC patterns.
• Build, monitor, and maintain pipelines across bronze, silver, and gold layers using Snowflake, dbt, SQL, Python, and modern orchestration tools.
• Develop dimensional data models with FACT/dimension tables and Slowly Changing Dimensions.
• Manage Snowflake environment including warehouses, roles, monitoring, performance, costs, and scheduling.
• Enforce data security controls (RBAC, masking, row-level access, auditing, governance).
• Establish data-quality tests, source-to-warehouse reconciliation, and consistent business definitions.

Skills

Snowflake

dbt

Python

ELT pipelines

Data modeling

RBAC security

PHI/PII security

Cloud data warehouse

Orchestration tools

Tools

Azure Data Factory

Dagster

Airflow

Prefect

Job description

Scion Staffing has been engaged to conduct a search for a Senior Data Platform Engineer for an on-site role in Addison, Texas. This hands-on position builds and operates a modern Snowflake data platform, develops ingestion pipelines, dbt transformations, and governance controls to turn sensitive data into trusted business insights.

The role requires at least 5 years in data engineering, experience with medallion architecture, Python, and orchestration tools; you will own production data