Data Warehouse Engineer

ProviderTrust•Nashville, TN

3d•Hybrid

About The Position

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.

Requirements

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

Nice To Haves

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

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.

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