Senior Data Engineer (8934)

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

• 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

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