Act Programmer

ACT Programmer

Position Summary
The ACT Programmer is responsible for maintaining and managing settlement databases and ensuring data is accurate, complete, and properly formatted throughout the administration process. This position works closely with case managers and other departments to scrub and validate data, assist with settlement calculations, upload and maintain data within ACT, and support the overall integrity and functionality of settlement databases.

Essential Duties and Responsibilities

• Review, scrub, clean, and validate incoming data to identify and resolve errors, duplicates, missing information, and inconsistencies.
• Prepare and format data for import into ACT and other settlement administration systems.
• Perform data uploads, imports, exports, and updates while ensuring data integrity.
• Assist with the development, testing, and execution of settlement calculations and allocation models.
• Review calculation results for accuracy and identify discrepancies or potential issues.
• Assist case managers with data-related questions, calculations, reports, and database requests.
• Maintain and update ACT databases throughout the life of each settlement.
• Create, modify, and maintain database fields, tables, queries, and other database components as needed.
• Perform ongoing database maintenance, including data corrections, updates, cleanup, and quality-control reviews.
• Maintain accurate records of database changes, uploads, calculations, and other processing activities.
• Troubleshoot data and database issues and work with team members to resolve them.
• Generate reports and data files as requested for internal review, client review, and settlement administration purposes.
• Compare source data against processed data to ensure information has been accurately transferred and maintained.
• Assist with testing database changes, calculations, mailings, and other system processes before production.
• Maintain confidentiality and security of claimant, financial, and other sensitive settlement information.
• Follow established procedures and internal controls for data handling and database management.
• Perform other duties related to data processing, database administration, and settlement administration as assigned.

Required Skills and Qualifications

• Strong attention to detail and commitment to data accuracy.
• Experience working with databases and large volumes of data.
• Strong Excel skills, including sorting, filtering, formulas, and data manipulation.
• Experience with ACT or similar database/software systems preferred.
• Ability to identify discrepancies and troubleshoot data issues.
• Ability to understand and work with calculation formulas and allocation methodologies.
• Strong organizational and time-management skills.
• Ability to manage multiple projects and deadlines.
• Ability to work independently while also collaborating effectively with case managers and other team members.
• Ability to handle confidential and sensitive information appropriately.

Preferred Qualifications

• Experience with class action, mass arbitration, settlement administration, or legal-related databases.
• Experience with ACT database programming or customization.
• Experience developing or modifying settlement calculation models.
• Experience with data imports/exports and database migration.
• Advanced Excel skills and/or experience with SQL or other database tools.
• Experience performing quality-control reviews on large datasets.

Pay: $60.00 - $75.00 per hour

Expected hours: 40.0 – 60.0 per week

Benefits:

• 401(k) 4% Match
• Dental insurance
• Health insurance
• Paid holidays
• Paid time off

Work Location: In person