Data Analyst / Developer - Finance Systems & Process Automation

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., * 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., * 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.

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., * 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