Excel/Access Developer

19 May 2024

Vacancy expired!

Duration: 6+ months contract to hire

Job Description:· Develops, prepares, and ensures all provider network analysis reports are completed accurately and timely.· Track and monitor provider network terminations, perform impact/disruption analysis as necessary.· Follow unit process for data integrity checks, issuance of correct actions plans or other documents within defined time frames.· Produce and give presentations on analysis conducted.· Provide data entry and review to meet unit needs.· Utilizes State approved GIS (Geographic Information System) to perform the tasks as requested.

Responsibilities:· Develops queries, VBA Modules and procedures, and prepare reports with metric/data analysis based upon data related to the Managed Care Organizations (MS Access, MS Excel).· Designs and develops audit tools that can interface with existing data sources utilizing applications such as MS Excel, Access, or SQL database functions.· Perform data audits utilizing developed business requirements.· Monitor, review and analyze MCO provider networks to ensure access to care.· Analyze MCO submitted reports and data.· Ability to review data and reports for timeliness, accuracy, and provider network adequacy including point in time, across time, and/or across programs.

Experience:· Multiple years of Project Management experience of IT / Software Development projects, using a Waterfall model.· Proficient with Project Management and Microsoft Office tools· Creates and implements project definitions, schedules, budgets, and objectives for one or more medium sized projects of low to moderate complexity following standard System Development Life Cycles (SDLC) and processes.

Skills:· Must be highly analytical and detail oriented with ability to creatively problem solve.· Proficient working knowledge of Microsoft Office products (MS Excel, MS Access, MS Word, Etc.)· Good working knowledge of GIS and Geocoding tools is a bonus.· Excellent verbal and written communication skills.· Strong self-starter with time management skills.· Ability to maintain attendance to support required quality and quantity of work.· Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA).· Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.

Education:· Bachelor’s degree or equivalent

About US Tech Solutions:US Tech Solutions is a global staff augmentation firm providing a wide range of talent on-demand and total workforce solutions. To know more about US Tech Solutions, please visit ;/p>

  • ID: #49961913
  • State: New Jersey Trenton 08602 Trenton USA
  • City: Trenton
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2023-05-19
  • Deadline: 2023-07-17
  • Category: Et cetera