Flagler Health+

Data Engineer-Integration & Visualization, Full-ti...

Job description

Under the supervision of the Enterprise Director Data and Analytics, the Data Engineer-Integration & Visualization builds the ETL Processes using Alteryx/SQL and stored procedures. The Engineer is responsible for building data dashboards using Tableau. The role includes building processes for integrations/data extracts from various applications and solutions. (eg. Balance Sheet/Income Statements and Financials from Premier, EPSi, HR Information from Ultipro, and Clinical information from Healthfully, SQL Server, Enterprise Data Warehouse). Provides data management design, development and support for both clinical data marts and Enterprise Data Warehouse. Build data marts for statistical analyses for use in research studies and evaluations conducted at Flagler Health +.

  • 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.
  • 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.
  • Can create dashboards in Tableau for presentations to Hospital Executives.
Preferred: Bachelor's Degree in related field of study such as informatics, public health, or health care desirable. 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 a plus. ETL experience in an Enterprise Data warehouse environment preferred.
Skills and Abilities: Experience in performing data analysis and creating tables in SQL Server required. Build automated ETL processes to load the tables and refresh the dashboards.
Build data structures to support the models and automation of the processes. 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 and shows commitment to and performs consistently high quality work. Ability to work harmoniously with diverse groups of individuals required.

Experience

Required
  • Experience in performing data analysis and creating tables in SQL Server .

Education

Required
  • High School/GED or better

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.