Data Engineer

South Texas Radiology Group, P.A.; San Antonio (TX); On-site; USD 110,000 - 140,000; Full time

Job summary

South Texas Radiology Group, P.A. is seeking a Data Engineer to design and maintain data pipelines, collect, manage, and convert data into accessible information for business teams and analysts.

You will build a centralized data warehouse, ensure data integrity across sources, support enterprise reporting, and collaborate with executives to enable data-driven decisions while adhering to HIPAA and corporate policies.

Qualifications

• Strong attention to detail and ability to multitask multiple priorities.
• Advanced knowledge and experience in Excel.
• Experience with BI tools such as Tableau and PowerBI.
• Strong programming skills in Python and SQL; knowledge of shell/bash.

Responsibilities

• Build and maintain data pipelines moving data from sources to a central data warehouse.
• Create and maintain infrastructure for a centralized data store and select platforms.
• Ensure data integrity across data sources and reporting needs.
• Collaborate with management and partners to set up data pipelines for reporting.
• Develop data dictionaries and semantic layers for KPIs and metrics.
• Support enterprise reporting and data mining initiatives.

Skills

Attention to detail

Multitask

Python

SQL

Shell

GitHub

CI/CD

Education

Bachelor's degree in Computer Science or related

Tools

Excel

Tableau

Power BI

SQL Server

PostgreSQL

REST APIs

ELT/ETL

GitHub

GCP

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.