Sr. Data Platform Engineer

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 our partner, an established healthcare services organization modernizing its technology and data capabilities. This is a direct hire, on onsite position located in Addison, Texas.

POSITION OVERVIEW:

The Senior Data Platform Engineer will build, operate, and secure a modern Snowflake data platform using a medallion architecture. Working closely with the Data Architect, this hands-on engineer will develop ingestion pipelines, dbt transformations, dimensional models, and governance controls that turn sensitive operational data into trusted business insights. This high-ownership opportunity is ideal for someone who enjoys managing the full data lifecycle and helping shape a growing data environment.

PERKS:

• Employee benefits package, with complete details to be provided during the interview process
• High-impact opportunity to help build and shape a modern enterprise data platform
• Broad ownership across Snowflake, dbt, data modeling, governance, security, and pipeline development
• Collaborative environment with opportunities to mentor teammates and expand modern data-stack capabilities

RESPONSIBILITIES:

• Onboard data from SQL Server databases and SaaS applications through REST APIs, ODBC, SFTP, file feeds, native connectors, incremental-loading methods, and CDC patterns.
• Build, maintain, and monitor pipelines across the bronze, silver, and gold layers using Snowflake, dbt, SQL, Python, Azure Data Factory, and modern orchestration tools.
• Develop dimensional data models, including fact and dimension tables, appropriate grain, conformed dimensions, and slowly changing dimensions, while translating business requirements into maintainable transformations.
• Manage the Snowflake environment, including warehouses, roles, resource monitors, platform performance, cost management, reliability, scheduling, dependencies, and failure resolution.
• Protect PHI, PII, and other sensitive data by implementing RBAC, least-privilege access, masking, row-access policies, audit logging, lineage, and governance controls.
• Establish data-quality tests, validation checks, source-to-warehouse reconciliation, and consistent business definitions while serving as a hands-on technical resource to other engineers.

QUALIFICATIONS:

• Minimum of 5 years of experience in data engineering, analytics engineering, or a closely related role.
• Production experience with dbt, medallion architecture, modern ELT patterns, and a cloud data warehouse; Snowflake experience is strongly preferred.
• Experience building ingestion pipelines from both SQL databases and SaaS or API-based sources using REST APIs, ODBC, SFTP, file feeds, native connectors, incremental-loading, or CDC.
• Proficiency with Python and experience with orchestration or integration technologies such as Azure Data Factory, Dagster, Airflow, Prefect, Snowpipe, Streams and Tasks, or Snowflake Openflow.
• Experience implementing access and security controls for sensitive or regulated data, including RBAC, data masking, row-level access, audit logging, or comparable protections.
• Demonstrated ability to independently own a production data platform within a small team, including pipeline reliability, monitoring, troubleshooting, data quality, security, performance, and cost management; healthcare, revenue cycle management, HIPAA/PHI, NetSuite, Paycom, Power BI, or SnowPro experience is preferred.

COMPENSATION AND BENEFITS:

This position offers competitive compensation salary range of $135-145k/yr (DOE) and an employee benefits package. Compensation will be determined based on relevant experience, technical expertise, certifications, and other job-related qualifications.

ABOUT OUR SEARCH FIRM:

Scion Staffing, Inc. is an equal opportunity employer and service provider and does not discriminate based on race, religion, gender, gender identity, national origin, citizenship status, sexual orientation, disability, political affiliation or belief, or any other protected class. We are committed to the principles of Equal Opportunity Employment and are dedicated to making employment decisions based on merit and value, for ourselves, our client companies, and the candidates we represent. For opportunities located in a region that have enacted fair chance, arrest or conviction-based employment ordinances, Scion Staffing proactively follows the enacted guidance and considers for employment all qualified applications with arrest and conviction records. We engage in socially conscious business practices and believe that diverse, inclusive, and non-biased talent and recruitment processes are foundational to the success of Scion as well as every client organization with whom we partner.