Senior Data Engineer - Central (7872)

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 ~ HEALING

Terros Health made the list!!

"Most Admired Companies of 2020, 2022 & 2023" as awarded by AZ Big Media

• 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

• Multiple medical plans - including a no premium plan for employees and their families

• Multiple dental plans - including orthodontia

• Financial well-being - 401(k) with a company match, interest free medical line of credit, financial education, planning, and support

• 4 Weeks of paid time off in the first year

• Wellness program

• Pet Insurance

• Group life and disability insurance

• Employee Assistance Program for the Whole Family

• Personal and family mental and physical health access

• Professional growth & development - including scholarships, clinical supervision, and CEUs

• Tuition discounts with GCU and The University of Phoenix

• Working Advantage - Employee perks and discounts

• Gym memberships

• Car rentals

• Flights, hotels, movies and more

• Bilingual pay differential

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