Data Analyst (Visual Basic Application) Onsite Hamilton, NJ

Date: Apr 9, 2024

Location:

Bridgewater, NJ, US, 08807-2441

Req ID: 23293

Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.

Summary

As a Managed Care Organization Data Analyst (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.

#LI-DN1

#LI-Remote

The pay range for this position is $69,400.00 - $99,200.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.

We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.

Gainwell Technologies is committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.