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
Seniority level
Entry level
Employment type
Full-time
Job function
Information Technology
Industries
Staffing and Recruiting
Referrals increase your chances of interviewing at Tandym Group by 2x