Raleigh NC client (healthcare technology company)
this is a full-time/direct-hire position with our client, option of contract-to-hire
Will be the subject matter expert in the continually evolving data models of Electronic Health Record (EHR), Practice Management, Pharmacy, and other data collection systems in use at our client sites; developing extraction logic and integrating the data from the disparate systems into the company common data model.
This is a customer facing role in that the analyst will be expected to work with clients’ IT groups and clinical leads to develop the integration file formats and methods that work best with the source systems and our clients’ workflow processes, and that will provide the necessary information to support client reporting and company studies.
The analyst must be able to research new and complex data models and make sense of the medical data being documented. The analyst will be expected to be able to research data issues found within the company data model, trace those issues back to the customer source systems, and determine if and how the integration would need to change to correct the identified issues. The analyst will use their strong SQL skills and company’s proprietary data management tools to ensure that the ETL processes are converting, classifying, and transforming the patient data properly, and will develop new methods of standardizing the data received from the disparate source systems.
-Design, develop, tune and maintain SSIS packages to perform the ETL process
-Design and develop SQL server stored procedures, functions and views to be used during the ETL process
-Create ETL technical specifications and design, develop, test, and support optimal data solutions
-Document ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance
-Perform problem assessment, resolution and documentation for existing ETL packages, mappings and workflows in production
-Performance tune the ETL process and SQL queries, and recommend and implement ETL and query tuning techniques
-Solid ETL experience
-Strong knowledge of relational databases, Microsoft SQL Server, SSIS, T-SQL, and SQL
-3+ years of Healthcare IT, specifically in data integration and analysis
-5+ years of IT experience with a focus on data integration, data management and analysis
-Medical/patient data experience is a big plus
Founded in 1971, DataMasters is certified as a woman-owned business by the State of North Carolina Department of the Administrative Office for Historically Underutilized Businesses and is self-certified by the U.S. Small Business Administration.
We are a member in good standing of the NPAWorldwide and TechServe Alliance (TSA), all of which provide invaluable resources for industry compliance standards and IT talent. DataMasters is also a founding member of the NC Technology Association (NCTech).