Data Engineer

The Data Engineer at South Texas Radiology Group, P.A. is responsible for collecting, managing, and converting data into information that business teams and analysts can use. This role designs and maintains data pipelines into a centralized data warehouse, supports enterprise reporting, and helps ensure data integrity across sources.

Responsibilities

• Adhere to STRG Policies and Procedures at all times.
• Gather information for moderately complex processes, analyze data and trends, and identify root causes.
• Design and maintain infrastructure for a centralized data store through a data warehouse; select the best platform(s) for each component and import data from agency EHRs and web-based sources using ELT/ETL best practices.
• Coordinate with internal managers and external partners to set up data pipelines into the data warehouse for reporting and other business functions, including ensuring data integrity of records from integrated information systems.
• Partner with the President on reporting needs for physician productivity and other measurables, and work with the Vice President, as needed, on physician scheduling and reporting needs.
• Support creation of enterprise reports using warehouse data, including development of a data dictionary.
• Maintain a data normalization strategy for new incoming data; create and maintain a semantic layer to develop report KPIs and business metrics.
• Assist with data mining and analytics to support decision making and corporate strategy set by the executive team, including a data management strategy covering data acquisition and archive recovery.
• Support business teams interacting with the data warehouse and/or data sources.
• Maintain best practices for CI/CD of accurate and accessible business data and provide transparency of development processes using Agile project management principles.
• Review and audit reports, data sources, and data streams for accuracy and completeness.
• Manage and deploy BI tools for use by various company teams.
• Support departmental initiatives as requested.
• Assist with alerting and educating staff on EHR changes.
• Assist with system administrative set-up as requested.
• Maintain strict confidentiality of patient protected health information in accordance with STRG procedures and HIPAA Privacy, Security, HITECH, and Transactions and Code Sets regulations.
• Perform other duties as required.

Requirements

• Strong attention to detail and ability to multitask multiple priorities.
• Advanced knowledge and experience in Excel is required.
• Knowledge of analytical and BI tools, including MS Excel, Tableau, and PowerBI.
• Strong programming skills in Python, SQL, and shell/bash, with expertise in database technologies, ELT/ETL processes, REST APIs, data warehousing, and workflow management tools.
• Experience querying and maintaining relational databases such as SQL Server and Postgres, and experience with version controlling using GitHub.
• Knowledge of containerization technologies, cloud development platforms such as GCP, and cloud-native applications.
• Cursory understanding of healthcare terminology, including CPT, RVU, and charge terminology.
• Knowledge of revenue cycle systems and mapping logic within billing tables.
• 4 years of experience in end-to-end analysis and/or operations experience, including requirement gathering and documentation, operational planning and forecasting, data analytics or current/future state analysis, in direct support of business planning initiatives.

Technology Stack

Excel, Tableau, PowerBI, Python, SQL, shell/bash, ELT/ETL, REST APIs, data warehousing, workflow management tools, SQL Server, Postgres, GitHub, containerization technologies, GCP, cloud-native applications, CPT, RVU.

Reporting Line

This position reports to the Controller.

Location and Work Schedule

San Antonio, TX (on-site).

• Maintaining and satisfying minimum attendance requirements is an essential function of this position, including working all full-time regular hours and scheduled or emergency overtime as needed.
• Full-time regular hours are defined as Monday through Friday, with after-hours or weekends as required.
• This job classification does not include “light duty” work or allow unpredictable or unrestricted absences.

Education

Bachelor’s degree in Computer Science, Data Analytics, Management Information Systems, or Business Administration, supplemented with one or more courses in current technology. Experience in lieu of formal education may be substituted.

Employment Status

FLSA Status: Exempt.