Data Engineer

South-Texas-Radiology-Group,-P.a.; San Antonio (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

South-Texas-Radiology-Group, P.a. is seeking a Data Engineer to design and maintain data pipelines, collect and transform data for business analysts, and ensure data integrity across multiple sources.

You will build a centralized data warehouse, select appropriate platforms, and enable robust reporting for physician productivity and operational decision-making. Responsibilities include collaborating with managers and partners, developing a data dictionary, and implementing CI/CD practices for

Qualifications

• 4 years of end-to-end analysis or operations experience supporting business planning.
• Advanced Excel skills and proficiency with BI tools (Tableau/Power BI).
• Experience gathering data from EHRs and building data warehouses with ETL/ELT.

Responsibilities

• Collect, manage, and convert data into accessible information for business teams and analysts.
• Create and maintain data pipelines to a central data warehouse from multiple sources.
• Perform data integrity reviews with end users and support reporting needs.
• Maintain data normalization and semantic layer for KPIs and metrics.
• Support CI/CD practices and Agile processes for data projects.
• Assist with enterprise reports, data dictionary, and data governance.

Skills

Excel

Tableau

PowerBI

Python

SQL

Shell/Bash

REST APIs

Data Warehousing

ETL/ELT

GitHub

PostgreSQL

SQL Server

GCP

Education

Bachelor’s degree in Computer Science, Data Analytics, MIS or Business Administration

Job description

The Data Engineer is responsible for collecting, managing, and converting data into accessible information for business teams and analysts. Creates and maintains data pipelines that transfer data from various sources to a central data warehouse, and supports business functions that require analyzing this data. Performs data integrity review in conjunction with end users.

Job Responsibilities:

• Employee must adhere to STRG Policies and Procedures at all times
• Gathers information for moderately complex processes, analyzes data and trends, and identifies root causes.
• Create and maintain the infrastructure for a centralized data store in the form of a data warehouse, including selecting the best platform(s) for each component of the data warehouse; import data from various agency EHRs and web-based sources using ELT/ETL best practices.
• Work with internal managers and external partners to set up data pipelines to the data warehouse for reporting and other business functions; ensure data integrity of records for data sources including integrated information systems.
• Works with the President related to reporting needs for physician productivity and other measurables. Works with the Vice President, as needed, related to physician scheduling & reporting needs.
• Provide support for creation of enterprise reports using warehouse data, including the creation of a data dictionary.
• Maintain a data normalization strategy for new data coming into the data warehouse; create & maintain a semantic layer for developing report KPIs and business metrics.
• Assists with data mining and analytical capability to support decision making and corporate strategy set by the executive team, including developing and maintaining a data management strategy that covers data acquisition and archive recovery.
• Provide support for business teams interacting with the data warehouse and/or data sources.
• Maintain best practices for continuous integration and continuous delivery (CI/CD) of accurate and accessible business data, and providing transparency of development processes using Agile project management principles.
• Review & audit reports, data sources and data streams for accuracy and completeness.
• Manage and deploy BI tools for use by various company teams.
• 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 as mandated by STRG procedures and HIPAA Privacy, Security, HITECH, and Transactions and Code Sets regulations
• Perform other duties as required

Supervisory Responsibilities:

None

Experience / Skill Requirements:

• Strong attention to detail and ability to multitask multiple priorities
• Advanced knowledge and experience in Excel required
• Knowledge of analytical and BI tools (ie MS Excel, Tableau, PowerBI)
• Strong programming skills (Python, SQL, shell/bash) and expertise in database technologies, ELT/ETL processes, REST APIs, data warehousing, and workflow management tools
• Experience querying and maintaining relational databases (SQL Server, Postgres) and version controlling (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.

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.

Maintaining and satisfying minimum attendance requirements is an essential function of this position, including working all full-time regular hours as established for this position and scheduled or emergency overtime. Full-time regular hours are defined as Monday through Friday, with after-hours or weekends as required. All employees in this job classification are required to satisfy this requirement. This job classification does not include "light duty" work or allow unpredictable or unrestricted absences.