A healthcare services organization in Florida is currently seeking a new Allscripts Database Consultant to join their growing team.
About the Opportunity:
-
Hours: EST
-
Setting: Remote
Responsibilities:
The Allscripts Database Consultant will:
-
Write custom code to extract Accounts Receivable data out of Allscripts Pro & Misys databases for their Ambulatory environment and map it into flat files, Excel, tab delimited and csv files to go into the VisualVault AR Rundown Platform by GRM.
-
Take JSON code and convert it to Excel (extract the data, put it into the vendor spec and send it to GRM via Excel)
-
Provide the headings of that data to put in the GRM field
-
Take the data and map it from the legacy system and map it to the vendor spec form
-
Create the mapping mechanism (i.e., abc in Allscripts needs to be xyz in GRM)
-
Perform sound checks during testing; query the data from the database to make sure it's ingested into GRM properly.
-
Attend meetings, answer high level and detailed technical questions.
-
Perform other duties, as needed
Qualifications:
-
Prior experience compiling data from Allscripts and mapping it into flat files, Excel, and CSV files
-
Experience mapping data with Hadoop-sized large data sets
-
Prior experience joining databases, putting it into a flat file, delimited, JSON, or XML
-
Experience working with strong query languages - jQuery, SQL, PL/SQL, T-SQL or Access
A technical test will be provided to potential candidates with a data mapping exercise
Desired Skills:
-
Prior experience writing custom code to extract Accounts Receivable data out of Allscripts Pro & Misys databases
-
Intermediate knowledge of Misys medical database