Data Warehouse Engineer

About the Role

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.

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.

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.

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

Benefits

• 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)