Job Description:

As a Data Analyst (Visual Basic Application) (Onsite) at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve "” a community's most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare's biggest challenges. Here are the details on this position."‹Your role in our missionDesign your career for growth, new possibilities and refining your valuable skills:"‹Develop queries, Visual Basic for Applications (VBA) Modules, and procedures to extract and analyze data pertinent to Managed Care Organizations (MCO), utilizing tools such as MS Access and MS Excel.Design and implement audit tools to seamlessly integrate with existing data sources, leveraging applications like MS Excel, Access, or SQL database functions.Conduct thorough data audits based on established business requirements.Monitor, evaluate, and analyze MCO provider networks to ensure optimal access to healthcare services.Assess submitted reports and data from MCO, ensuring timeliness, accuracy, and network adequacy across various parameters.Prepare comprehensive provider network analysis reports accurately and within specified timelines.Track and manage provider network terminations, conducting impact analyses as needed.Adhere to unit processes for data integrity checks, issuing action plans, and other documentation within defined time frames.Deliver insightful presentations based on conducted analyses.Provide data entry and review support to meet unit needs.Utilize State-approved Geographic Information Systems (GIS) as required for assigned tasks.What we're looking for Proficiency in developing queries, Visual Basic for Applications (VBA) Modules, and procedures for data analysis using MS Access and MS Excel.Experience designing and implementing audit tools with applications like MS Excel, Access, or SQL database functions.Strong analytical skills with the ability to perform detailed data audits based on business requirements.Excellent monitoring and analytical abilities to ensure optimal access to care within Managed Care Organization (MCO) provider networks.Attention to detail in reviewing and analyzing MCO submitted reports and data and effective communication skills to deliver presentations on analysis findings.Familiarity with Geographic Information Systems (GIS) preferred.What you should expect in this role This is a full-time on-site position in Hamilton, New Jersey.Opportunities to travel through your work (0-10%)"‹Video cameras must be used during all interviews, as well as during the initial week of orientation.