Sr. Data Engineer

Sr. Data Engineer

6-Month Contract-to-Hire

5 days onsite in Addison, TX

Need to be Green Card Holder or US Citizen for full-time conversion and good communication

Snowflake, Azure Data Factory (ADF), dbt, SQL, Python, Data Warehousing, Medallion Architecture (Bronze/Silver/Gold), REST APIs, ELT Pipelines, Snowpipe, Airflow/Dagster, SQL Server, Power BI, RBAC/Data Security, Healthcare Data (preferred)

Two-step interview process:

30 minute virtual

Onsite interview for 60-90 minutes

Top Skills/Must Haves

Experience building snowflake, Azure Data Factory. OrthoMed is going live with Snowflake end of August. Need to have hands on experience owning it, managing pipelines

Data warehousing - working with modernized data to consolidate all information into one place

Senior level resource owning and leading. No direct reports or managing in this role.

What You'll Do

• Bring in New Data Sources

• Onboard new sources into the platform—from SQL Server databases and SaaS applications (REST APIs, ODBC, SFTP/file feeds, and native connectors).

• Build reliable ingestion into the raw/bronze layer with incremental loading and validation.

• Build the Medallion Pipelines

• Construct and maintain the pipelines that move data through the bronze ? silver ? gold layers.

• Manage scheduling, dependencies, monitoring, and failure resolution end to end.

• Model the Data and Encode Business Logic

• Develop and maintain dbt models in Snowflake across the silver and gold layers.

• Design and build dimension and fact tables for revenue cycle data, including claims, service lines, providers, payers, facilities, and encounters, with correct grain and conformed definitions.

• Translate revenue cycle business rules into maintainable, high-quality transformations.

• Manage the Snowflake Platform

• Own day-to-day administration of the Snowflake environment, including warehouses, roles, resource monitors, performance tuning, and cost optimization.

• Keep the platform reliable, performant, and operating within predictable cost and usage parameters.

• Implement and Operate Governance & Security

• Implement and maintain platform security controls including RBAC, column-level masking, row-access policies, and audit logging in alignment with architectural standards.

• Protect PHI/PII by design and support HIPAA compliance and audit readiness.

• Keep the Data Trustworthy

• Build data quality tests, validation checks, and source-to-warehouse reconciliation processes.

• Maintain lineage and consistent business definitions so the gold layer remains the organization's trusted source of truth.

• Support the Team

• Serve as a hands-on technical resource for existing engineers and help elevate the team's modern data engineering capabilities.

What We're Looking For (Core)

• These are the capabilities we prioritize most:

• Strong SQL and dimensional data modeling (fact/dimension modeling, grain, conformed dimensions, SCDs, performance optimization).

• Production dbt experience on a cloud data warehouse.

• Hands-on experience ingesting data from SQL databases and SaaS/API sources.

• A security-first mindset when working with sensitive data and least-privilege access.

• A high degree of ownership and the ability to independently operate a modern data platform.

• Tools & Environment

• We value expertise in the concepts behind these technologies; equivalent experience is welcomed.

• Core Platform

• Snowflake

• dbt

• SQL

• Python

• Medallion (Bronze / Silver / Gold)

• Ingestion & Orchestration

• REST APIs

• ODBC

• SFTP

• CDC

• Snowpipe

• Streams & Tasks

• Dagster (preferred)

• Airflow

• Prefect

• Snowflake Openflow

• Source Systems

• SQL Server

• SaaS applications

• NetSuite (roadmap)

• Paycom (roadmap)

• Reporting

• Power BI

• Snowflake-native semantic layer (under evaluation)

• Required Experience

• 5+ years of experience in Data Engineering, Analytics Engineering, or a related discipline.

• Strong SQL and dimensional data modeling expertise.

• Production dbt experience.

• Hands-on ingestion from SQL databases and SaaS/API sources.

• Experience with medallion architecture and modern ELT practices.

• Python for automation, ingestion, and integrations.

• Experience implementing data security controls such as RBAC and masking.

• Production experience with a modern cloud data warehouse (Snowflake strongly preferred; BigQuery, Databricks, or Redshift experience is transferable).

• Ability to work onsite in Addison, TX, five days per week.

• Preferred Experience

• Healthcare or Revenue Cycle Management experience.

• HIPAA, PHI, SOC 2, or HITRUST environments.

• Snowflake production administration and SnowPro certification.

• Dagster, Airflow, Prefect, or similar orchestration tools.

• Snowflake Openflow or CDC implementation.

• NetSuite and/or Paycom integrations.

• SQL Server CDC.