Our direct client, Spectrum Healthcare is seeking a Business Intelligence Developer in West Michigan.

Hi , Hope you are doing great. As discussed please go through the below position, if you are comfortable share the below required details along with your DL and Visa Copy ASAP Our direct client, Spectrum Healthcare is seeking a Business Intelligence Developer with Claims / Scripting Review for a contract opportunity in West Michigan. MUST have HEALTHCARE CLAIMS / SCRIPTING REVIEW, FTP, PL/SQL and SQL development experience. Mode of Interview: 1ST phone interview and if all goes well, a final WebEx interview will be scheduled Description:   Job Overview  • This position would monitor all incoming and outgoing encounters/claims with the State of Michigan to ensure accuracy and troubleshoot any failures or others issues.  • This person will work closely with encounter team and IT staff.  Our Process  • Our Company pay claims to Medicaid members on medical, dental and pharmacy claims. Clean and adjudicated claims call encounters. Then we submit these encounters to the State, so they can calculate the rate to reimburse us. Most of our encounters data is coming from vendors (third-party administrators) and, some, from our internal system. These vendors send us their files and we, in-turn, submit to the State’s system. All these processes are automated; some files involved EDI department to convert to certain formats that fit the State’s requirement before sending on.  Our Needs  • The State feels that encounters in their Data Warehouse don’t match with our Data Warehouse. Audit will perform frequently to reconcile encounters between data warehouses. There is a need for someone to be able to extract data, analyze, evaluate the root cause, and summarize finding.  • Our data, however, are in various tables. I need someone who could write a query (SQL), to link these tables and extract data; and manipulate it in various tools to arrive essential information for evaluation.  • Sometimes there are issues with encounter transmitting issues, so I need this person have a good understanding of FTP for file transferring troubleshooting.  • In addition, there are times the State implements new changes on how they want to submit encounter data. This requires involvement with IT folks, to provide assistance on coding/testing new changes. This position requires skill to facilitate staff members in different departments and able to communicate with IT folks, as well.  REQUIREMENTS:  • Someone with experience developing PL/SQL procedures in Oracle/SQL Server  • Someone with excellent formula writing skills within Excel  • Someone with excellent analytical and reporting skills  REQUIRED EXPERIENCE:  • 2 years of experience  • Writing SQL codes  • Excel – Intermediate to Advance  • Access, FTP, and Tableau reporting  REQUIRED SKILLS:  • Attention to detail  • Excellent Communication - need to be able to explain their reports  • Work well in a team environment and flexible on schedule  EDUCATION  Bachelor Degree Please share me your visa and dl copy also.    Full Name as per Passport   Current Location (City, State & Zip Code)   Relocation (Y/N)   Phone Number   Email Id   Linkedln ID   Date of Birth (MM/DD)   SSN last 4 Digits   Highest Education & Year of Passing   Visa Status (Attach Visa Copy)   Validity   Interview - Slots for next 2 days   W2 or C2C   Total Years of Experience   Skype ID   Currently on Project (Yes / No)   Availability   Rate     Arun Reddy IT Recruiter (W) 312-985-0412 22260 Haggerty Rd, Suite # 285,Northville, MI 48167. www.rsrit.com

To unsubscribe from future emails or to update your email preferences click here .