Finance Systems Automation: Data Analyst & Developer

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

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