Finance Data Analyst & Automation Developer

Gravity IT Resources; Monroe (NC); On-site; USD 70,000 - 110,000; Full time

Job summary

We are seeking a Data Analyst / Developer to join a school finance team onsite in North Carolina. The role focuses on modernizing finance operations by leveraging data from legacy databases, Access applications, and spreadsheet-based processes.

Key tasks include designing and maintaining automation solutions, developing SQL queries, and building internal tools with PHP where applicable. PowerShell scripting and data validation across systems are also essential, with close collaboration with

Qualifications

• Experience with Access databases and VBA forms/reports.
• Proficient in SQL and data integration across systems.
• PowerShell scripting or automation experience.
• Knowledge of PHP or NetBeans IDE is a plus.
• Ability to translate requirements into technical solutions.

Responsibilities

• Analyze existing finance workflows, databases, and spreadsheet-driven processes to identify automation opportunities.
• Design, develop, and maintain applications and utilities that improve business processes and reduce manual effort.
• Support and enhance legacy Microsoft Access databases and applications.
• Develop and optimize SQL queries, stored procedures, reports, and database structures.
• Create and maintain web-based tools and internal applications using PHP within the NetBeans development environment. (nice to have)
• Develop PowerShell scripts to automate data extraction, transformation, integration, and administrative tasks.
• Consolidate data from multiple sources and ensure data accuracy, integrity, and consistency.
• Work with finance and business users to gather requirements and translate them into technical solutions.
• Document systems, processes, and development standards.
• Troubleshoot application, database, and reporting issues and implement corrective actions.
• Support ongoing maintenance and continuous improvement initiatives.

Skills

Microsoft Access

SQL development

PHP / NetBeans

PowerShell

Data integration

Analytical skills

Stakeholder communication

Tools

NetBeans IDE

PHP

Job description

We are seeking a Data Analyst / Developer to join a school finance team onsite in North Carolina. The role focuses on modernizing finance operations by leveraging data from legacy databases, Access applications, and spreadsheet-based processes.

Key tasks include designing and maintaining automation solutions, developing SQL queries, and building internal tools with PHP where applicable. PowerShell scripting and data validation across systems are also essential, with close collaboration with