CSV SQL Experience RxClaim Ad Hoc Programming Analyst (Jobs in Schaumburg, IL)   Requirement id 97993 Job title Analyst Job location in Schaumburg, IL Skills required Fast-Paced Environment, Microsoft Excel, CSV, SQL Experience RxClaim Ad Hoc Programmin Open Date 19-Sep-2019 Close Date Job type Contract Duration 6 Months Compensation DOE Status requirement --- Job interview type ---    Email Recruiter: coolsoft Job Description Analyst: Fast-Paced Environment, Microsoft Excel, CSV, SQL Experience RxClaim Ad Hoc Programmin * Note: Local candidates preferred. JOB DESCRIPTION: This position is suited for a detail-oriented individual with strong analytical skills, the ability to work independently in a fast-paced environment with many competing priorities, must be a strong communicator and has experience with Microsoft Excel, OneNote, various file formats such as CSV and TXT, iSeries/RxCLM experience a plus, PBM background a plus. SQL knowledge a plus. TOP REQUIREMENTS: Need people familiar with strong analytical skills, detail orientation and ability to work independently once trained. *** What experience will set candidates apart from one another? iSeries/RxCLM experience, PBM experience and/or SQL experience. This resource will be responsible for a book of business and/or number of assigned tasks related to conversion and loading of history claims data into our adjudication system from outside vendors. Responsibilities also include extraction of data from internal system for conversion and loading elsewhere internally. Ad hoc projects as needed. Our team is EDMI - Electronic Data Migration and Implementation. It consists of Analysts and Developers whose charter is ensuring history claims data is loaded into members pharmacy profiles ahead of their effective date with OptumRx. The top responsibilities of this position are: 1. By following a defined Vendor Transition workflow and use of the ServiceNow ticketing system, manage a list of assigned clients and/or associated tasks in your queue 2. Upon intake of client file, identify if a conversion program exists or if one needs to be created. Ability to perform mapping exercise would be beneficial for cases of custom input layouts. Using provided tools, convert the data into our standard load format. 3. Load the data into our adjudication system, RxCLM. Monitor all reports to ensure load performed as expected. Raise issues as needed if validation is not passed on this or any other step. 4. Match loaded claims data to eligibility data using tools provided. Monitor reports to ensure match results are as expected and then ensure claims data is moved to production profiles. 5. Communicate with business partners, team SMEs/mentors, members of other IT teams, project managers and leadership on issues, status, risks, etc. 6. May be asked to perform other functions of similar work where the source data already exists on our platform and needs to be extracted and reloaded to a different member or account structure. 7. Responsible for tracking time against projects and other ad hoc work that may be assigned. Our adjudication platform is AS400/iSeries. Tools are largely provided as menu options. We use a suite of MS Office products. Ability to build and run SQL queries beneficial.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 97993 while calling.   Other jobs in IL: Chicago (77), Deerfield (7), Des Plaines (2), Downers Grove (7), Downtown Chicago (5), DT Chicago (2), Elk Grove (3), Elk Grove Village (24), Elkgrove Village (1), Evanston (1), Lake Forest (1), Lincolnshire (4), Northbrook (3), Oak Brook (5), Oakbrook (1), Oakbrook Terrace (5), Round Lake (3), Schaumburg (4), South Barrington (1), Springfield (2), Vernon Hills (6), Warrenville (7),    Fast-Paced Environment job openings in other states Jobs List IT Support Specialist IV (Lead) - 20230123100413 Create date: 23-Jan-2023 start date:2/13/2023 End date:3+Months from start date submission deadline:01/30/2023 Note: * Job Site: Remote Description: IT Support Specialists assist… Job Description: This person will support digital online applications that are custom-built banking solution.... (This job is for - Dynatrace Splunk Jobs in OH Columbus Specialist - (in Columbus, OH)) Business Systems Analyst III - 20221227085231 Create date: 27-Dec-2022 start date:1/9/2023 End date:1+YEARS from start date submission deadline:12/29/2022 Note: * Job Site: On-Site Description: • Reporting to the Director of People Analytics, the position collaborates with a small, centralized, global team of Wor.... (This job is for - job Jobs in NC Durham Analyst - (in Durham, NC)) Project Manager 3 - 108863 - SP Create date: 08-Sep-2022 start date:10/3/2022 End date: At least 18 Months from projected start date submission deadline:on 9/14 at 4:00PM CST. client info : DESE Note: * Virtual or Remote? * Preference will be given to local candidates and those who can be onsite when face-to-face collaboration is needed. W.... (This job is for - job Jobs in MO JeffersonCity Manager - (in Jefferson City, MO)) Help Desk Technician 4 - 108397 - SP Create date: 24-Aug-2022 start date:9/12/2022 End date:10/31/2022 submission deadline:9/1 at 4pm CST. client info : ITS Note: * Position will be 100% onsite at the Bismarck location. Local candidates only. Description: Individual will work as a member of.... (This job is for - job Jobs in ND Bismarck Consultant - (in Bismarck, ND)) Help Desk Technician 4 - 103995 - SP Create date: 05-May-2022 start date:5/23/2022 End date:10/31/2022 submission deadline:5/18/2022 client info:ITS Description: Individual will work as a member of a team that provides support for hardware and software applications on a variety of computing platforms in a large.... (This job is for - job Jobs in ND Bismark Consultant - (in Bismark, ND))     (Analyst: Fast-Paced Environment, Microsoft Excel, CSV, SQL Experience RxClaim Ad Hoc Programmin in Schaumburg, IL)

Featured Jobs QoS Analyst (Jobs in Dauphin County, Pennsylvania) Team Work Written Consultant (Jobs in Nashville, Tennessee) ASP.Net&C# Typescript MS SQL Server Specialist (Jobs in Raleigh, North Caro Project Manager Interpersonal Expert (Jobs in Raleigh, North Carolina) ASP.Net Typescript Web Specialist (Jobs in Raleigh, North Carolina) Tableau Consultant (Jobs in Dauphin County, Pennsylvania) Middleware C++ Expert (Jobs in Raleigh, North Carolina) BRD RTM SCRUM Analyst (Jobs in Richmond, Virginia) Documentation TechLead (Jobs in Madison, Wisconsin) ITSM Interpersonal Consultant (Jobs in Madison, Wisconsin)