Data Analyst / Developer – Finance Systems & Process Automation

Gravity IT Resources; Monroe (NC); On-site; USD 55,104 - 82,656; Part time

Job summary

Gravity IT Resources is seeking a Data Analyst / Developer to support the Finance Department by designing, developing, and maintaining automation solutions. The role focuses on modernizing finance operations by leveraging data from legacy databases, Microsoft Access applications, and spreadsheet-driven processes.

The ideal candidate combines data analysis, database development, and automation skills, working with business stakeholders to identify inefficiencies and deliver scalable solutions

Qualifications

• 3+ years of experience in application development, database administration, or data analytics.
• Experience with Microsoft Access (design, forms, queries, reports, VBA).
• Strong SQL development and database experience.
• Experience developing in PHP and using NetBeans IDE.
• Scripting with PowerShell to automate data tasks.

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.
• 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.

Skills

Analytical thinking

Troubleshooting

Stakeholder communication

Problem solving

Data integration

Tools

Microsoft Access

SQL (SQL Server) databases

PHP development

NetBeans IDE

PowerShell scripting

Job description

Data Analyst / Developer – Finance Systems & Process Automation

Location: Monroe, NC

Department: Finance/IT

Position Type: 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.
• 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 in application development, database administration, or data analytics.
• Strong experience with:
  • Microsoft Access (database design, forms, queries, reports, and VBA)
  • SQL databases and advanced SQL development
  • PHP development
  • NetBeans IDE
  • PowerShell scripting
• 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.

Equal Employment Opportunity Statement

Gravity IT Resources is an Equal Opportunity Employer. We are committed to creating an inclusive environment for all employees and applicants. We do not discriminate on the basis of race, color, religion, sex (including pregnancy, sexual orientation, or gender identity), national origin, age, disability, genetic information, veteran status, or any other legally protected characteristic. All employment decisions are based on qualifications, merit, and business needs.