Dear Candidate,
We have an urgent opening for and I have sent you a job description please go through it and let me know if you are comfortable with it and also send me
Title: SQL Report Developer - Analyst IV - Operation Support Services
Location Details: 100% remote
Start: ASAP
Duration: 6 month with extensions
Important Skills
Technical – SSIS Report Developer, Business Analyst, healthcare / claims background
Soft – works with claims team and there is only 1 SME with claims. This person is very direct! Must work well with a direct communicator
Interview Process: MS Teams intv with manager
This is a hybrid Business Analyst and SQL Report Developer role.
Must Haves:
SQL Report Developer
Business Analyst
Advanced with the Microsoft stack including SSMS, SSIS (if candidates have Oracle or Web Development in their background, they aren't a fit)
True report development and complex packages with SSIS
Leverage the use of stored procedures within their executed code
Healthcare Exp
Proficient in T- SQL, Visual Basics, MS Visio and MS office including Access, Word, Excel & Power point.
Must have proven ability to perform advanced programming, program design and use of tables, queries, forms and macros.
Business analysis experience on at least 5 major enterprise projects.
5+ years' experience in data integrity analysis.
Excellent interpersonal, verbal and written communications skills.
Ability to facilitate meetings and requirement sessions.
5+ years' experience in managed care industry is required.
Bachelor Degree or advanced education preferably in Business Administration or Computer Science
Plus:
Claims exp
Day to Day:
As part of the business, using IT tools, this SQL Report Developer will create cool reports and automation of existing reports. Primarily focus on developing operational reporting and analytics and, looking for a guru within SSMS, SSIS (MS Stack) to develop reports. They pull data from various departments like clinical, claims, and enrollment across an expansive portfolio of Medicare, mass health, etc. This is a complex environment with TONS of DATA!
There are a large volume of complex reports that need redesigned. They have some critical reports like month end, claims, dollars, EDI rates, etc. that aren't fully automated and need to be re-written to run at 100% automation. They collect key claims information on a monthly basis, build a staging table, and have approx. 7-8 reports that use this staging table. Each report has their own code for different outputs. This role will need to look at each core data set's code and develop automated reports.
Example: think of their Medicare audit dashboard as the center of a web, with all their reports going out from the center. Requirements and metrics are one report and another report may look at the amount of dollars going in / out. Both of these reports need automated.
They have a hybrid model and this SQL Report Developer will also act as a BUSINESS ANALYST. They work with business teams to write requirements, develop a prototype and work with the biz owner on modifications. Once complete, they pass off to Quality Control. There are no other BAs on the project.
Rohit Bhasin |Lead Recruiter | Apetan Consulting LLC |
Phone: 201-620-9700 * 121/Hangout:- rohit.apton@gmail.com
Mailing Address: 72 Van Reipen Avenue pmb# 255, Jersey City, NJ 07306
Corp. Office: 15 Union Avenue, office # 6, Rutherford, New Jersey 07070
Web link: www.apetan.com
You received this message because you are subscribed to the Google Groups "Xrecnet IT Recruiters Network - Corp to Corp IT Jobs & Hotlists" group.
To unsubscribe from this group and stop receiving emails from it, send an email to xrecnet+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/xrecnet/CAByMb8j5zck9mn9kc_xqfKuCcZaj%2Bh7iTSPzr3--O_Ftmaf8RQ%40mail.gmail.com.
No comments:
Post a Comment