Data Analyst

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 mission

Design 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.