Sr. Data Platform Engineer

The Bronx; Addison (TX); On-site; USD 135,000 - 145,000; Full time

Benefits offered by this job

Employee benefits package

High-impact data platform project

Broad ownership across Snowflake, dbt,

Mentor teammates and expand data-stack

Job summary

Scion Staffing has been engaged to search for a Senior Data Platform Engineer for an on-site role in Addison, Texas. You will build, operate, and secure a modern Snowflake data platform, developing ingestion pipelines, dbt transformations, dimensional models, and governance controls to turn sensitive operational data into trusted business insights.

The ideal candidate owns the full data lifecycle in a small team, collaborates with a Data Architect, and manages cost, performance, and security.

Qualifications

• At least 5 years in data engineering or analytics engineering.
• Advanced SQL skills with dimensional data modeling experience.
• Production experience with dbt and Snowflake in a cloud data warehouse.
• Experience building ingestion pipelines from SQL databases and SaaS/APIs.
• Proficiency with Python and orchestration tools such as Azure Data Factory, Dagster, Airflow, or Snowflake Openflow.
• Experience implementing access controls and governance for sensitive data.

Responsibilities

• Onboard data from SQL Server databases and SaaS apps via REST APIs, ODBC, SFTP, file feeds, connectors, incremental loading, and CDC.
• Build, maintain, and monitor pipelines across bronze, silver, and gold layers using Snowflake, dbt, SQL, Python, and modern orchestration tools.
• Develop dimensional models including fact and dimension tables with appropriate grain and slowly changing dimensions.
• Manage Snowflake environment: warehouses, roles, resource monitors, performance, cost, reliability, scheduling, dependencies, and failures.
• Protect PHI, PII and other sensitive data with RBAC, masking, row-level access, audit logs, lineage and governance.
• Establish data-quality tests and source-to-warehouse reconciliation; act as a hands-on technical resource for colleagues.

Skills

SQL

dbt

Snowflake

Python

ETL/ELT

Governance

Tools

dbt

Snowflake

Azure Data Factory

Dagster

Airflow

Snowpipe

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.
• Advanced SQL skills and hands-on experience designing dimensional data models, including fact tables, dimension tables, grain, conformed dimensions, and slowly changing dimensions.
• 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.

EEO STATEMENTS

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.