Data Analyst

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

Data Analyst / Developer – Finance Systems & Process Automation- ON SITE 5/days a week

Contract

Position Summary

Local school system is seeking a skilled Data Analyst / Developer to support the Finance Department by designing, developing, and maintaining business process automation solutions. This role will focus on modernizing and streamlining finance operations by leveraging data from legacy databases, Microsoft Access applications, and spreadsheet-based processes.

The ideal candidate will possess a strong blend of data analysis, database development, and automation expertise, with the ability to work directly with business stakeholders to identify inefficiencies and create scalable solutions that improve accuracy, reporting, and operational efficiency.

Key Responsibilities

• Analyze existing finance department 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 closely 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.

Required Qualifications

• 3+ years of experience with:
• Microsoft Access (database design, forms, queries, reports, and VBA)
• SQL databases and advanced SQL development- queries
• PHP development or NetBeans IDE are nice to have
• PowerShell scripting or some automation
• Experience integrating and validating data across multiple systems.
• Strong analytical, troubleshooting, and problem-solving skills.
• Ability to communicate technical concepts effectively to non-technical stakeholders.

Preferred Qualifications

• Experience with Power BI dashboards, reporting, and data visualization.
• Experience supporting finance, accounting, payroll, or public-sector systems.
• Knowledge of ETL processes and data migration projects.
• Familiarity with Microsoft SQL Server environments.
• Experience working within K-12 education, government, or public-sector organizations.

Desired Skills

• Business process analysis and automation
• Data modeling and database design
• Reporting and dashboard development
• Requirements gathering and stakeholder engagement
• Process improvement methodologies
• Documentation and technical writing
• Independent project execution and collaboration

What Success Looks Like

• Reduced manual spreadsheet processing through automation.
• Improved accuracy and timeliness of financial reporting.
• Streamlined workflows across finance functions.
• Reliable, maintainable applications that extend the life of legacy systems while supporting modernization efforts.
• Enhanced visibility into operational and financial data through reporting and dashboards.

This position is ideal for a hands-on developer who enjoys solving business problems, modernizing legacy processes, and building practical automation solutions that deliver measurable value to the organization.