Data Engineer

TruDataRx, Inc.

Norwich, Austin (VT, TX)

Hybrid

USD 120,000 - 160,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

TruDataRx, Inc. seeks an experienced Data Engineer to architect, build, and maintain data pipelines in the Modern Data Stack, primarily using Snowflake and dbt.

You will ensure clean, reliable, and timely data for analysts and data scientists while mentoring junior engineers. Based in Norwich, VT or Austin, TX, with remote options, you will translate business requirements from Product and Analytics into technical specs, drive ELT design, and optimize Snowflake usage for cost efficiency and

Qualifications

  • Bachelor’s degree in CS/Engineering or related field.
  • 3+ years of Data Engineering and Database Development experience with medical claims.
  • 2+ years of hands-on Snowflake experience (architecture, snowpipe, streams/tasks, security).
  • 1+ years of production dbt experience (packages, macros, incremental models).

Responsibilities

  • Design and build robust ELT pipelines ingesting data into Snowflake.
  • Own dbt project structure; develop complex SQL models and DRY macros.
  • Implement data quality tests and observability; ensure data reliability.
  • Mentor junior engineers and establish best practices for SQL and version control.
  • Translate business requirements from Product/Analytics into data models and specs.

Skills

SQL mastery
Data modeling
Mentorship
Collaboration
Problem solving

Education

Bachelor's degree in CS/Engineering

Tools

Snowflake
dbt
Python
Airflow
Git
Snowpipe
Fivetran

Job description

Norwich, VT or Austin, TX preferred / remote considered

Job Type

Full-time

Description
ABOUT TRUDATARX

TruDataRx, Inc. uses objective clinical data to help clients improve the clinical efficacy and reduce the costs of pharmacy benefits for its members. We are independent from all players in the pharmaceutical manufacturing and distribution industries, enabling us to best serve our clients. We value the following characteristics in our team members:

  • Outward Mindset – foundation of our culture, which influences the right behaviors, that leads to results
  • Entrepreneurial – the ability to get things done with resources you don’t control
  • Humility – deep comfort in knowing when you don’t know and asking questions
  • Collaboration – we always give benefit of doubt that each person has something to contribute
POSITION SUMMARY:

We are seeking an experienced Data Engineer to architect, build, and maintain our next-generation data pipelines. You will be the technical subject matter expert on our Modern Data Stack, primarily utilizing Snowflake and dbt.

You will be responsible for defining best practices, conducting code reviews, and actively nurturing the growth of junior engineers. You will act as a bridge between raw data and actionable analytics, ensuring our analysts and data scientists have clean, reliable, and timely data.

ESSENTIAL FUNCTIONS
  • ELT Architecture: Design and build robust, scalable ELT pipelines to ingest data from various sources (APIs, production databases, third‑party tools) into Snowflake.
  • Data Transformation (dbt): Own the dbt project structure. specific responsibilities include:
  • Developing complex SQL-based data models (incremental models, snapshots).
  • Writing Jinja macros to keep code DRY (Don't Repeat Yourself).
  • Implementing data quality tests (schema tests, custom data tests).
  • Snowflake Optimization: Manage the Snowflake environment to ensure cost-efficiency and performance. This includes warehouse sizing, clustering strategies, and utilizing features like Snowpipe and Zero-Copy Cloning.
  • Data Quality & Governance: Champion data integrity. Implement observability tools and alerts to catch pipeline failures or data anomalies before they reach the business users.
  • Mentorship: Act as a technical lead for junior engineers, conducting code reviews, and establishing best practices for SQL and version control.
  • Collaboration: Translate business requirements from Product and Analytics teams into technical specifications and data models
Requirements
REQUIREMENTS
  • Required education: Bachelor’s degree in Computer Science, Engineering, Mathematics, or a related technical field (or equivalent practical experience).
  • Required industry experience or certification:
  • 3+ years of professional experience in Data Engineering and Database Development with medical and prescription claims
  • Specific Stack Experience:
  • 2+ years of hands-on experience specifically with Snowflake (architecture, snowpipe, streams/tasks, and security).
  • 1+ years of production experience with dbt (developing packages, macros, and incremental models).
Preferred skills:
  • SQL Mastery: Expert-level SQL skills with the ability to write complex, highly optimized queries. You can write complex, performant queries and debug spaghetti code with ease. Deeply familiar with Snowflake architecture, including separation of storage and compute, semi-structured data handling (JSON/Variant), and security management (RBAC).
  • Programming: Proficiency in Python for scripting, custom connectors, or orchestration tasks.
  • Orchestration: Experience with workflow orchestration tools (e.g., Airflow or FiveTran, dbt or dbt Cloud).
  • Version Control: Strong familiarity with Git flows and CI/CD pipelines for data (e.g., GitHub Actions, GitLab CI).
  • dbt Proficiency: Strong experience with dbt (Core or Cloud). You understand the difference between ephemeral, table, and view materializations and know how to use dbt for documentation and lineage.
  • Data Governance principles and best practices
  • Master Data Management principles and best practices
Preferred Qualifications (Bonus)
  • Experience with database management
  • Experience handling healthcare data formats (e.g. Pharmacy Claims data, Eligibility data, Medical Claims data, etc.).
  • Knowledge of Azure/GCP services or similar AWS core services (S3, Lambda, IAM).
  • Experience migrating legacy stored procedures to modern dbt models.
  • Python: Proficient in Python for scripting, API interaction and Streamlit apps
  • Version Control: Strong understanding of Git workflows (branching, merging, pull requests) specifically within a data context.
Company Standard Requirements:
  • Ability to work well with others in a collaborative environment
  • Ability to get things done with resources you don’t control
  • Willingness to admit you don’t know and ask for help
  • Exhibit constant curiosity and a drive to problem solve
  • Exhibit desire to learn and grow on a continuous basis
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer - Snowflake & dbt Expert (Remote)
Data Engineer - Snowflake & dbt Expert (Remote)

TruDataRx, Inc. • Norwich (VT), Austin (TX)

Hybrid
USD 120,000 - 160,000
Lead DBT Developer
Lead DBT Developer

Veriipro • Los Angeles (CA)

On-site
USD 140,000 - 190,000
Senior Data Engineer - Dallas, TX
Senior Data Engineer - Dallas, TX

Tech Partners • Dallas (TX)

On-site
USD 120,000 - 160,000
Senior Data Engineer - Snowflake & dbt Cloud
Senior Data Engineer - Snowflake & dbt Cloud

Premier Trailer Leasing • Plano (TX)

On-site
USD 120,000 - 190,000
Senior Data Engineer
Senior Data Engineer

Pipe Recruit • Town of Poland (NY)

Remote
USD 100,000 - 130,000
2026 10 Senior DBT/Snowflake Developer
2026 10 Senior DBT/Snowflake Developer

Vistrada • United States

Remote
USD 140,000 - 200,000
Senior Data Engineer
Senior Data Engineer

MISUMI Americas • Schaumburg (IL)

On-site
USD 167,000 - 202,000
Comprehensive medical and dental
401(k) plan
Generous PTO and leave programs
Data Engineer
Data Engineer

firstPRO US • Virginia

On-site
USD 140,000 - 190,000
Senior Data Architect (Snowflake)- Market Research
Senior Data Architect (Snowflake)- Market Research

Truelogic • United States

Remote
USD 140,000 - 210,000
100% Remote Work
Highly Competitive USD Pay
Paid Time Off
+2
2026 10 Senior DBT/Snowflake Developer
2026 10 Senior DBT/Snowflake Developer

Vistrada LLC • United States

Remote
USD 120,000 - 180,000