ProviderTrust Summary

ProviderTrust was founded in 2010 with a mission to create safer healthcare for everyone through OIG and state Medicaid exclusion monitoring. Today, the organization has developed the industry’s most accurate dataset for ongoing exclusion monitoring and primary source verification, serving the nation’s top health systems, payers, and healthcare organizations. Our solutions monitor employees, vendors, provider networks, licenses, credentials, and more for OIG and state Medicaid exclusions, sanctions or disciplinary actions, license expirations, or suspensions. With a team of 100+ employees, our Nashville-based company has consistently been recognized as one of the Best Places to Work by Modern Healthcare, Inc. Magazine, and the Nashville Business Journal. To learn more, visit [providertrust.com]

The ProviderTrust Data Warehouse Engineer, a member of the Data Services team, will make healthcare safer by building and maintaining the data pipelines and warehouse models that turn application data, client data, and third-party data into trustworthy, queryable information. This role owns the transformation layer between our operational systems and the analysts, products, and clients who depend on that data being correct. The Data Warehouse Engineer will report directly to the Director of Data Services.

Duties and Responsibilities

Own the pipelines: Build, maintain, and troubleshoot the ETL processes that ingest application data, client data, and third-party data into our warehouse.
Steward client-facing data: Maintain third-party data pipelines behind our data products, respond to data escalations, and improve the process over time. Partner with each dataset's owner to keep the curated data accurate and current.
Model the warehouse: Design and maintain transformations, materialized views, and aggregates in SQL and Python, making deliberate choices about grain and structure so downstream consumers can rely on the data.
Protect data quality: Design processes and metrics that assess, maintain, and improve data quality. Detect source-system and business-process changes that impact analytical data and partner with stakeholders to correct them.
Enable analysts and products: Build data models that feed reporting, BI, and emerging use cases such as a queryable provider-data layer, working closely with analysts and the BI engineer.

Required Skills and Experience

Curiosity and initiative to learn undocumented systems and take ownership of work without being assigned it
Strong communication and collaboration skills to stay aligned with the team
Several years building and maintaining production data pipelines
Familiarity with data warehouse structures, models, and concepts (dimensional modeling, materialized views, transformation layers)
Ability to diagnose and resolve production data issues independently
Strong SQL and Python
Bachelor's degree or equivalent experience and training

Skills You Will Develop

Healthcare compliance data domain knowledge (exclusions, sanctions, licenses, credentials)
Designing a semantic / queryable data layer for analytics and AI use cases
Data warehouse architecture and platform decisions at scale
Stakeholder management across product, engineering, and operations

What It's Like to Work Here

At ProviderTrust, we recognize that experience is built in many ways. If you have relevant skills that are not reflected in your resume or your experience doesn’t match our exact requirements, we welcome your candidacy and encourage you to share more. We champion building a team that embodies empathy, equity, respect, and inclusivity while actively supporting our community, clients, partners, and friends. We value differences of opinion and embrace unique perspectives. We desire an environment that allows all team members to bring their whole selves to work unashamedly. We carefully consider every application and will either move forward with you, find another team that might be a better fit, keep in touch for future opportunities, or thank you for your time. ProviderTrust is an equal opportunity employer.

To be great at ProviderTrust, we find our team members have these things in common:

Gain energy from working in a fast-paced, creative environment
Decision-making that employs a blend of data-driven insights and intuition
Ability to multitask and handle multiple projects concurrently
Resilience and positivity, able to address setbacks and bounce back quickly
Resourcefulness, discovering creative ways to get things done
Joy in making an immediate and positive impact
Diverse interests that are welcomed and extend beyond our organization

Things That Make Us A Great Place To Work

Hybrid schedule: 3 days in office
16-week paid primary caregiver with a 2-week phase-back leave policy
4-week paid secondary caregiver leave policy
Competitive base salary and incentive package with 401k matching, HSA employer contribution, and company-paid life and disability insurance
Medical, dental, and vision benefits: PT pays 80% of your premiums. We also offer access to a range of free mental health and well-being resources.
Unlimited PTO, 11 paid holidays, and a flexible work schedule
Internal professional growth, development, and mobility
Daily all-company morning huddles to sync up across the business
In-office experience: fully stocked kitchen, ergonomic desk setup, dog-friendly, and many celebrations!
Remote experience: home office set-up with technology provided, remote-friendly meetings and celebrations, and interest-specific Slack channels for connecting across teams
Fitness stipend, wellness program, and cell phone reimbursement
Modern Healthcare Best Places to Work (2021-2026)
The Tennessean Top Work Places (2022-2026)

Job Type: Full-time

Benefits:

401(k)
401(k) matching
Dental insurance
Employee assistance program
Flexible schedule
Flexible spending account
Health insurance
Health savings account
Life insurance
Paid time off
Parental leave
Professional development assistance
Retirement plan
Vision insurance

Work Location: Hybrid remote in Nashville, TN 37203

ProviderTrust

New Jobs

Data Warehouse Engineer