Hi, Please check the position below and let me know if you have any suitable consultant available.
*Reply to [email protected] <[email protected]> or call 614 822 7309* *Job Title: SSRS report writerLocation: Columbus, OHDuration: 1 yearVisa copy is must* Candidate will be working with our managed care plan’s financial data, claim data and provider data. More specifically, need of an individual who is familiar with: 1. *Working with Fee Schedules* (these are long lists of approved payment amounts for various medical services provided by the State Government. We use these to reimburse our providers at a price aligned with the State’s billing expectations) - The candidate would compare the new rates against the previous, identify possible impact based on historical data, and manipulate the data to load into the QNXT claim processing system - We would like this candidate to be familiar with automation processes to help us automate the analysis and management of new fee schedules as we receive them using stored procedures and SSRS (possibly SSIS). 2. *APR-DRG* (grouper used for pricing hospital claims) - The candidate would manage our DRG pricing tool (built in SQL and Excel) which uses various fee schedules from the State to price claims correctly according to this methodology so we don’t overpay or underpay providers for DRG services. 3. *EAPG* (this is another grouper used for pricing outpatient claims) - This is very new, but if you have anyone with this experience it would be very helpful. A few other states are currently using this technology. It is similar to DRG pricing methodology. - This process is still being designed with the State Government but should go live in 2016. The candidate would assist in evaluating proposals and methodology from the State on how they plan to implement this tool. 4. *Cost reporting* - The candidate would be responsible for compiling quarterly cost reports with several other team members that detail our expenses in a categorical format defined by the State. Experience with formal financial reporting at a State or Federal level would be relevant. 5. *Financial Comparisons / Strategic Analysis* - The candidate would assist with identifying inefficiencies through our payment data to understand where we can create new programs / efficiencies to improve financial outcomes. An example would be identifying a subset of members that are using the ER more frequently than our other members on average and identifying causes of the issue that we need to address strategically. The most important software skills are: - SQL (querying, stored procedures, views, functions) - SSRS - Excel Other software skills that may be helpful are: - QNXT (our claims payment software) - SSIS (helpful but not a necessity ) Best Regards, Kiran Kumar Neumeric Technologies Corp Work: 614 882 7309 | FAX: 855.NTC.0049 Mailto: [email protected] Yahoo IM: [email protected] Gmail ID: [email protected] 4000 Town Center, Ste#1770 | Southfield, MI 48075 Visit us at www.ntc-us.com for further details. -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/us_itgroups. For more options, visit https://groups.google.com/d/optout.
