{"schemaVersion":"jobsearcher.job.v1","id":"5f52118bd2ea51a42d7f9f22","url":"https://jobsearcher.com/jobs/5f52118bd2ea51a42d7f9f22","canonicalUrl":"https://jobsearcher.com/jobs/5f52118bd2ea51a42d7f9f22","title":"Data Warehouse Engineer","description":"ProviderTrust SummaryProviderTrust 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 ResponsibilitiesOwn 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 ExperienceCuriosity and initiative to learn undocumented systems and take ownership of work without being assigned itStrong communication and collaboration skills to stay aligned with the teamSeveral years building and maintaining production data pipelinesFamiliarity with data warehouse structures, models, and concepts (dimensional modeling, materialized views, transformation layers)Ability to diagnose and resolve production data issues independentlyStrong SQL and PythonBachelor's degree or equivalent experience and trainingSkills You Will DevelopHealthcare compliance data domain knowledge (exclusions, sanctions, licenses, credentials)Designing a semantic / queryable data layer for analytics and AI use casesData warehouse architecture and platform decisions at scaleStakeholder management across product, engineering, and operationsWhat It's Like to Work HereAt 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 environmentDecision-making that employs a blend of data-driven insights and intuitionAbility to multitask and handle multiple projects concurrentlyResilience and positivity, able to address setbacks and bounce back quicklyResourcefulness, discovering creative ways to get things doneJoy in making an immediate and positive impactDiverse interests that are welcomed and extend beyond our organizationThings That Make Us A Great Place To WorkHybrid schedule: 3 days in office16-week paid primary caregiver with a 2-week phase-back leave policy4-week paid secondary caregiver leave policyCompetitive base salary and incentive package with 401k matching, HSA employer contribution, and company-paid life and disability insuranceMedical, 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 scheduleInternal professional growth, development, and mobilityDaily all-company morning huddles to sync up across the businessIn-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 teamsFitness stipend, wellness program, and cell phone reimbursementModern Healthcare Best Places to Work (2021-2026)The Tennessean Top Work Places (2022-2026)","company":"Providertrust","rawCompany":"providertrust","city":"Franklin","state":"TN","isRemote":false,"isActive":false,"createdAt":"2026-07-21T10:33:23.551Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1211.01","title":"Health Informatics Specialists","slug":"health-informatics-specialists"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"518210","title":"Computing Infrastructure Providers, Data Processing, Web Hosting, and Related Services","slug":"computing-infrastructure-providers-data-processing-web-hosting-and-related-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Warehouse Engineer","description":"ProviderTrust SummaryProviderTrust 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 ResponsibilitiesOwn 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 ExperienceCuriosity and initiative to learn undocumented systems and take ownership of work without being assigned itStrong communication and collaboration skills to stay aligned with the teamSeveral years building and maintaining production data pipelinesFamiliarity with data warehouse structures, models, and concepts (dimensional modeling, materialized views, transformation layers)Ability to diagnose and resolve production data issues independentlyStrong SQL and PythonBachelor's degree or equivalent experience and trainingSkills You Will DevelopHealthcare compliance data domain knowledge (exclusions, sanctions, licenses, credentials)Designing a semantic / queryable data layer for analytics and AI use casesData warehouse architecture and platform decisions at scaleStakeholder management across product, engineering, and operationsWhat It's Like to Work HereAt 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 environmentDecision-making that employs a blend of data-driven insights and intuitionAbility to multitask and handle multiple projects concurrentlyResilience and positivity, able to address setbacks and bounce back quicklyResourcefulness, discovering creative ways to get things doneJoy in making an immediate and positive impactDiverse interests that are welcomed and extend beyond our organizationThings That Make Us A Great Place To WorkHybrid schedule: 3 days in office16-week paid primary caregiver with a 2-week phase-back leave policy4-week paid secondary caregiver leave policyCompetitive base salary and incentive package with 401k matching, HSA employer contribution, and company-paid life and disability insuranceMedical, 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 scheduleInternal professional growth, development, and mobilityDaily all-company morning huddles to sync up across the businessIn-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 teamsFitness stipend, wellness program, and cell phone reimbursementModern Healthcare Best Places to Work (2021-2026)The Tennessean Top Work Places (2022-2026)","datePosted":"2026-07-21T10:33:23.551Z","dateModified":"2026-07-21T10:33:23.551Z","hiringOrganization":{"@type":"Organization","name":"Providertrust","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Franklin","addressRegion":"TN","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"5f52118bd2ea51a42d7f9f22"},"url":"https://jobsearcher.com/jobs/5f52118bd2ea51a42d7f9f22"}}