ETL Developer

Medasource • Full-time • Remote (Florida, United States, US) • 4h ago

Title: ETL Developer

Client: National Health System

Location: 100% Remote

Duration: 6-month Contract to Hire

Our national client, one of the top 10 largest health systems in the country, is looking for a Business Intelligence & ETL (Extract, Transform, Load) Developer to join the team to provide immediate in-flight project bandwidth and transition full time after the contract portion. The ideal candidate will have a high level of experience with ETL and data sourcing in a healthcare environment and be proficient in a number of data extraction tools for enterprise health systems. This individual is required to have a strong understanding of claims and eligibility.

Core Required Skills:

· SQL Server

· SQL Development

· Azure Exp ( ADF, Pipelines, Databricks, Synapse)

· ETL Development

Essential Duties:

-Completes analysis, development, documentation and modification of ETL processes and jobs per data architecture and modeling requirements.

-Creation of new ETL processes based on a standard architecture.

-Analyze and implement best practices for claims and eligibility data

-Creation of SQL queries in order to extract, transform and load data into a SQL databases.

-Troubleshoot issues such as connection, failed jobs, application errors, server alerts, space thresholds, etc. within predefined SLAs.

-Proactively maintain and tune SQL code according to best practices of the EDW, to prevent issues from occurring.

-Ensure appropriate documentation for all new development and modifications of the ETL processes and jobs.

-Performs unit testing for solutions developed and ensures integrity and security of institutional data.

-Provide user support to customers of the EDW and reporting technologies.

-Collaborates with technical and non-technical internal resources to produce and support analytics and transaction level reports, dashboards, and data cubes

Position Requirements:

-3-5+ years experience in Business Intelligence Development.

-3-5+ years in SQL Server Integration Services, Data Factory or analogous data transformation and orchestration software.

-3-5+ years experience in SQL

-Experience with data modeling tools

-Experience with Visualization tools (PowerBI preferred, but other such as SSRS, Tableau, MicroStrategy is adequate)

-Experience with Team Foundation Server

-Understanding of Relational and Dimensional data architecture concepts

-Ability to troubleshoot technical problems related to the implementation and processing of software required.

-Ability to research and analyze information required.

-Strong written and verbal communication skills required.

-Must have strong analytical skills with an ability to organize and communicate thoughts clearly