Data Engineer I | Data & Analytics | Days

University of Florida - St. Augustine, FL

Full-time - Entry Level

St. Augustine, FL

Educational Services

About the position

The Data Engineer I position is responsible for building ETL processes and data dashboards, primarily using SQL and Tableau. This role involves integrating data from various applications and managing the Enterprise Data Warehouse (EDW) processes. The engineer will also provide support for business report writing and automation, ensuring data integrity and optimizing database performance.

Responsibilities

• Creates Stored Procedures, Views and Functions for clinical reports for deployment on Reporting Services, Tableau and vendor requested extracts.
• Manages and creates innovative data transfer solutions using SSIS and other Integration technologies.
• Optimizes existing database objects as necessary to maximize query performance.
• Provides troubleshooting and support for Quality tools like MDSTAT and Vizient SE.
• Helps to manage Enterprise Data Warehouse including creating database scripts and ETL scripts to normalize data from incoming systems in collaboration with ETL and Data Engineers.
• Develops design documents as needed and assists/guides quality checking/validation process.
• Troubleshoots inconsistencies with data and data collection and makes recommendations for more consistent document entry requirements to ensure data integrity.
• Optimizes existing reports for business related systems.
• Provides/develops and maintain business office revenue cycle operation procedures like MedMetrix and other Revenue cycle adhoc requests.
• Creates dashboards in Tableau for presentations to Hospital Executives and for measuring quality measures.

Requirements

• Bachelor's Degree in Informatics, Public Health, or Related Field is required.
• Demonstrated strong written, organizational and verbal skills required.
• Ability to manage multiple projects, meet deadlines, and work in a team environment.
• Accurate and detail-oriented with a commitment to high quality work.

Nice-to-haves

• Experience building data marts and ETL processes that fetch data from diverse data sources and display using Tableau.
• Experience with SQL Server/BI/EDW and tools like Tableau/Alteryx.
• ETL experience in an Enterprise Data warehouse environment.
• Experience in performing data analysis and creating tables in SQL Server.
• Build automated ETL processes to load the tables and refresh the dashboards.
• Build data structures to support the models and automation of the processes.