This job is expired.
Full Job Description
JOB TITLE: Hybrid VBA Programmer
JOB LOCATION: Hybrid, 2-3 days on site in Hamilton (Trenton)
WAGE RANGE*: $48hr to $50hr
JOB NUMBER: 25-02614
REQUIRED EXPERIENCE:
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).
JOB DESCRIPTION
o 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).
o Designs and develops audit tools that can interface with existing data sources utilizing applications such as MS Excel, Access, or SQL database functions.
o Perform data audits utilizing developed business requirements.
o Monitor, review and analyze MCO provider networks to ensure access to care.
o Analyze MCO submitted reports and data.
o Ability to review data and reports for timeliness, accuracy, and provider network adequacy including point in time, across time, and/or across programs.
o Develops, prepares, and ensures all provider network analysis reports are completed accurately and timely.
o Track and monitor provider network terminations, perform impact/disruption analysis as necessary.
o Follow unit process for data integrity checks, issuance of correct actions plans or other documents within defined time frames.
o Produce and give presentations on analysis conducted.
o Provide data entry and review to meet unit needs.
o Utilizes State approved GIS (Geographic Information System) to perform the tasks as requested.
o Proficient working knowledge of Microsoft Office products (MS Excel, MS Access, MS Word, Etc.)
o Good working knowledge of GIS and Geocoding tools is a bonus.
o Excellent verbal and written communication skills.
o Strong self-starter with time management skills.
o Ability to maintain attendance to support required quality and quantity of work.
o Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA).
o Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.
Equal Opportunity Employer, including Veterans and Individuals with Disabilities
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
JOB LOCATION: Hybrid, 2-3 days on site in Hamilton (Trenton)
WAGE RANGE*: $48hr to $50hr
JOB NUMBER: 25-02614
REQUIRED EXPERIENCE:
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).
JOB DESCRIPTION
o 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).
o Designs and develops audit tools that can interface with existing data sources utilizing applications such as MS Excel, Access, or SQL database functions.
o Perform data audits utilizing developed business requirements.
o Monitor, review and analyze MCO provider networks to ensure access to care.
o Analyze MCO submitted reports and data.
o Ability to review data and reports for timeliness, accuracy, and provider network adequacy including point in time, across time, and/or across programs.
o Develops, prepares, and ensures all provider network analysis reports are completed accurately and timely.
o Track and monitor provider network terminations, perform impact/disruption analysis as necessary.
o Follow unit process for data integrity checks, issuance of correct actions plans or other documents within defined time frames.
o Produce and give presentations on analysis conducted.
o Provide data entry and review to meet unit needs.
o Utilizes State approved GIS (Geographic Information System) to perform the tasks as requested.
Knowledge, Skills and Abilities
o Proficient working knowledge of Microsoft Office products (MS Excel, MS Access, MS Word, Etc.)
o Good working knowledge of GIS and Geocoding tools is a bonus.
o Excellent verbal and written communication skills.
o Strong self-starter with time management skills.
o Ability to maintain attendance to support required quality and quantity of work.
o Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA).
o Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.
Equal Opportunity Employer, including Veterans and Individuals with Disabilities
* While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
Job Information
Job Category:
Other
Spotlight
Employer
Related jobs
Administrative Assistant
City of Cambridge
ESSENTIAL DUTIES AND RESPONSIBILITIES:Under the direction of the City Electrician and/or the Asst. City Electrician, assumes responsibility for all office administrative functions, including inv...
May 14, 2025
Cambridge, MA
Stewardship Associate, Frank and Joan Randall Tehachapi Preserve
The Nature Conservancy
OFFICE LOCATION
Bakersfield, California, USA.The Stewardship Associate position will work about 25% of the time on the Preserve and 75% of the time from a home office. The Associate is responsible fo...
May 14, 2025
Bakersfield, CA
Range Technician
The Nature Conservancy
OFFICE LOCATION
Center, North Dakota, USAWhile this position will work primarily from the Cross Ranch office, you will occasionally travel and stay overnight at other work locations within the MN-ND-...
May 14, 2025
Center, ND