Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

The ProviderTrust Data Warehouse Engineer will build and maintain data pipelines and warehouse models, transforming data into trustworthy, queryable information. This role is responsible for the transformation layer between operational systems and data consumers, reporting to the Director of Data Services.

Responsibilities

• Build, maintain, and troubleshoot ETL processes for ingesting application, client, and third-party data.
• Maintain third-party data pipelines behind data products, respond to data escalations, and improve processes.
• Partner with dataset owners to ensure curated data accuracy and currency.
• Design and maintain transformations, materialized views, and aggregates in SQL and Python.
• Design processes and metrics to assess, maintain, and improve data quality.
• Detect source-system and business-process changes impacting analytical data and partner with stakeholders for correction.
• Build data models to feed reporting, BI, and emerging use cases.

Requirements

• Curiosity and initiative to learn undocumented systems and take ownership of work.
• Strong communication and collaboration skills.
• 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 skills.
• Bachelor's degree or equivalent experience and training.

Skills

• SQL
• Python
• Data Warehouse Structures
• Data Warehouse Models
• Dimensional Modeling
• Materialized Views
• Transformation Layers
• ETL Processes
• Data Quality Assessment
• Data Modeling

Location

• Nashville

Work Type

• Hybrid (3 days in office)

Experience Level

• Several years building and maintaining production data pipelines

Education Level

• Bachelor's degree or equivalent experience and training

Salary/Compensations

• Competitive base salary and incentive package

Benefits

• 16-week paid primary caregiver leave with a 2-week phase-back
• 2-week phase-back leave policy
• 4-week paid secondary caregiver leave
• 401k matching
• HSA employer contribution
• Company-paid life insurance
• Company-paid disability insurance
• Medical benefits (PT pays 80% of premiums)
• Dental benefits (PT pays 80% of premiums)
• Vision benefits (PT pays 80% of premiums)
• Free mental health and well-being resources
• Unlimited PTO
• 11 paid holidays
• Flexible work schedule
• Internal professional growth, development, and mobility
• Fully stocked kitchen
• Ergonomic desk setup
• Dog-friendly office
• Home office set-up with technology provided
• Remote-friendly meetings and celebrations
• Interest-specific Slack channels
• Fitness stipend
• Wellness program
• Cell phone reimbursement

About the Company

• ProviderTrust was founded in 2010 with a mission to create safer healthcare through OIG and state Medicaid exclusion monitoring.
• The organization has developed the industry’s most accurate dataset for ongoing exclusion monitoring and primary source verification.
• Serves the nation’s top health systems, payers, and healthcare organizations.
• Solutions monitor employees, vendors, provider networks, licenses, credentials, and more for OIG and state Medicaid exclusions, sanctions or disciplinary actions, license expirations, or suspensions.
• A Nashville-based company with 100+ employees.
• Consistently recognized as one of the Best Places to Work by Modern Healthcare, Inc. Magazine, and the Nashville Business Journal.

Equal Opportunity

• ProviderTrust champions building a team that embodies empathy, equity, respect, and inclusivity.
• Actively supports our community, clients, partners, and friends.
• Values differences of opinion and embraces unique perspectives.
• Desires an environment that allows all team members to bring their whole selves to work unashamedly.
• ProviderTrust is an equal opportunity employer.