Senior Database Developer (ACCESS/SQL/VBA)

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 Senior Database Developer (ACCESS/SQL/VBA) 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

 

Take a close look at some of the details that contribute to Gainwell’s industry-leading tools and technologies in this challenging position. 

 

• Develops queries, VBA, Visual Basic for Applications, 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. MCO Reporting is network analysis reports on the managed care organizations.
• 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.
• 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.

What we're looking for

 

• 6+ years of database and applications development experience with proficiency in VBA (Visual Basic for Applications) modules, SQL and ACCESS and Microsoft Office products (Excel, Word, etc)
• Must be highly analytical and detail oriented with ability to creatively problem solve.
• 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.

What you should expect in this role

 

• FULLTIME ONSITE ROLE:  Must live within a commutable distance from Trenton, NJ 08625 and agree to be onsite Monday to Friday.   
• Will consider candidates that are out of state that are able to relocate at their own expense (relocation assistance/bonus is not available)
• Video cameras must be used during all interviews, as well as duri