Senior Data Engineer

Paycom - ATS; Phoenix (AZ); On-site; USD 120,000 - 160,000; Full time

Benefits offered by this job

Medical plans (no-premium option)

Dental plans

Vision insurance

401(k) with company match

Paid time off

Employee wellness programs

Job summary

Terros Health is seeking a Senior Data Engineer to design, build, and maintain scalable data pipelines and a comprehensive data warehouse ecosystem. You will ensure data quality, governance, and timely delivery to clinical and operational teams.

You will work with HL7/FHIR standards, APIs, and healthcare data formats, partnering across IT and business units to translate complex needs into robust, scalable solutions that improve patient outcomes.

Qualifications

• Bachelor’s degree in computer science, IT, engineering or math; advanced degree preferred.
• 7+ years of progressive experience in data engineering or data architecture.
• Experience with HL7, FHIR, APIs, SFTP and healthcare data integration.

Responsibilities

• Leads design, development, and maintenance of scalable data pipelines and ETL/ELT processes.
• Builds and optimizes enterprise data warehouse structures for analytics and operations.
• Implements data models and ensures data quality, lineage, and governance.
• Collaborates with clinical and business teams to translate requirements into technical solutions.
• Mentors juniors and peers; supports cross-functional initiatives.

Skills

Advanced SQL

ETL/ELT pipelines

Data warehousing

HL7 FHIR APIs

Data modeling

APIs SFTP data integration

Healthcare data standards

Education

Bachelor's degree in Computer Science, IT, Engineering, Mathematics, or related field

Master’s degree preferred

Job description

Terros Health is a healthcare organization of caring people, guided by our core values of integrity, compassion and empowerment. We engage people in whole person’s health through an integrated care delivery system, thus establishing a medical home for our patients. In caring for the whole person, we focus on overall wellness through physical health, mental health and substance use care. Our mission is to provide extraordinary care by empowered people through exceptional outcomes.The Senior Data Engineer plays a critical role within the Business Intelligence team, designing, building, and maintaining scalable data architecture and data integration solutions that support clinical, operational, and strategic initiatives across Terros Health.This role is responsible for developing and optimizing enterprise data pipelines and data warehouse structures, ensuring high data quality, integrity, and accessibility. The Senior Data Engineer partners closely with business leaders, analysts, and IT teams to translate complex business needs into sustainable data solutions that drive informed decision-making and improved patient outcomes.The duties listed below are intended only as illustrations of the types of work that may be performed. The omission of specific statements of duties does not exclude them from the position if the work is similar, related or a logical assignment to this classification.HOPE ~ HEALTH ~ HEALINGLeads the design of and develops and maintains scalable data pipelines and ETL/ELT processes to integrate data from internal and external systems.Builds and optimizes Enterprise Data Warehouse structures to support analytics, reporting, and operational workflows.Implements and maintains data models (dimensional and relational) to ensure efficient and accurate reporting.Evaluates and recommends improvements to data architecture, storage, and processing performance.Establishes and enforces data quality standards, validation processes, and monitoring to ensure data integrity and reliability.Leads development of data governance practices, including data definitions, metadata management, and data lineage documentation.Ensures compliance with healthcare data standards and regulations related to security and privacy.Develops and maintains integrations using healthcare data standards and formats including HL7, FHIR, APIs, SFTP, and flat files.Collaborates with clinical and operational teams to ensure accurate and timely data exchange across systems.Partners with analysts, clinical leaders, and business stakeholders to translate business requirements into technical solutions.Provides technical guidance and mentorship to junior team members and peers.Participates in cross-functional initiatives to support organizational goals and strategic priorities.Monitors and optimizes performance of data pipelines, queries, and warehouse environments.Identifies and resolves data issues, bottlenecks, and system inefficiencies.Stays current with emerging data engineering tools, technologies, and best practices and recommends and drives adoption where appropriate.Maintains comprehensive documentation including data dictionaries, pipeline documentation, and technical design artifacts.Communicates technical concepts, risks, and solutions clearly to both technical and non-technical stakeholders.Benefits & WellnessWe invest in the health, well-being, and success of our employees and their families by offering comprehensive benefits, wellness resources, and opportunities to grow both personally and professionallyMultiple medical plan options, including a no-premium plan for employees and their familiesMultiple dental plan options, including orthodontic coverageVision insuranceGroup life and disability insurancePet insurance401(k) plan with company matchInterest-free medical line of creditFinancial education, planning, and support resourcesMonetary company contribution toward eligible benefitsBilingual pay differentialGenerous Paid Time Off (PTO) – 3 weeks off in the first yearPaid Sick Time10 paid holidays annuallyComprehensive wellness program featuring wellness challenges, activities, and prizesEmployee Assistance Program (EAP) available to employees and their family membersTrip Reduction ProgramOngoing professional growth and career development opportunities, including:ScholarshipsClinical supervisionContinuing Education Units (CEUs)Tuition discounts through Grand Canyon University, University of Phoenix, and Northern Arizona University (NAU)Access to the Working Advantage Employee Discount Program, with savings on:Gym membershipsCar rentalsFlights, hotels, movie tickets, and moreBachelor’s degree in Computer Science, Information Technology, Engineering, Mathematics, or related field (or equivalent experience); master’s degree preferred.A minimum of 7 years of progressive experience in data engineering, data architecture, or related field.Advanced SQL development skills, including stored procedures, performance tuning, and query optimizationExperience building and maintaining ETL/ELT pipelines and enterprise data warehouse environmentsExperience working with structured and semi-structured data formats (JSON, XML, CSVExperience integrating data via APIs, SFTP, and healthcare interoperability standards (HL7, FHIR)Strong understanding of data modeling concepts (dimensional, relational, star/snowflake schemas)Experience with performance tuning and database optimizationExperience working with healthcare or behavioral health data strongly preferredMust have a valid Arizona driver’s license, be 21 years of age with a minimum of 3 years driving experience, and meet requirements of Terros Health’s driving policyMust successfully pass a TB screening and criminal background checkPhysical demands of this position are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.