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:

1. 30 minute virtual
2. 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.