Data Analyst​/Developer – Finance Systems & Process Automation

Data Analyst / Developer – Finance Systems & Process Automation

Location: Monroe, NC

Department: Finance/IT

Position Type: Contract

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.

• 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 Net Beans development environment.
• Develop Power Shell 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.

• 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
  • Net Beans IDE
  • Power Shell 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.

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

• 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

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

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.