Senior Data Engineer (8934)

Job DetailsJob Location: Central Avenue - Phoenix, AZ 85012Position Type: Full TimeEducation Level: Bachelor's DegreeTravel Percentage: In-OfficeJob Shift: Day ShiftJob Category: Information TechnologyTerros 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 ~ HEALING

Leads 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 & Wellness

We 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 professionally

Multiple medical plan options, including a no-premium plan for employees and their families
Multiple dental plan options, including orthodontic coverage
Vision insurance
Group life and disability insurance
Pet insurance

401(k) plan with company match
Interest-free medical line of credit
Financial education, planning, and support resources
Monetary company contribution toward eligible benefits
Bilingual pay differential

Generous Paid Time Off (PTO) – 3 weeks off in the first year

Paid Sick Time

10 paid holidays annually

Comprehensive wellness program featuring wellness challenges, activities, and prizes
Employee Assistance Program (EAP) available to employees and their family members

Trip Reduction Program

Ongoing professional growth and career development opportunities, including:

Scholarships
Clinical supervision
Continuing 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 memberships
Car rentals
Flights, hotels, movie tickets, and more

Qualifications

Bachelor’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 optimization
Experience building and maintaining ETL/ELT pipelines and enterprise data warehouse environments
Experience working with structured and semi-structured data formats (JSON, XML, CSV
Experience 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 optimization
Experience working with healthcare or behavioral health data strongly preferred
Must 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 policy

Physical 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.