Be an early applicantLess than 25 applicantsPosted by Agency

Company

Original Job Post

Tandym Group · 2 days ago

Allscripts Database Consultant

Greater Orlando

Full-time

Remote

Entry, Mid Level

Wonder how qualified you are to the job?

Maximize your interview chances

EmploymentRecruiting

H1B Sponsorship

Insider Connection @Tandym Group

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Data CompilationData MappingDatabase JoiningQuery LanguagesAllscriptsExcelCSVHadoopJSONXMLJQuerySQLPL/SQLT-SQLAccessCustom Code WritingAccounts ReceivableAllscripts ProMisys DatabasesMedical Database

Required

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

Preferred

Prior experience writing custom code to extract Accounts Receivable data out of Allscripts Pro & Misys databases

Intermediate knowledge of Misys medical database

Company

Tandym Group

Glassdoor

3.2

Tandym Group is a provider of full-service recruitment, temporary staffing, and workforce management solutions in the Northeast and Florida.

Founded in 1985

New York, New York, USA

201-500 employees

https://tandymgroup.com/

H1B Sponsorship

Tandym Group has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (2)