Enterprise Applications Data Analyst

JOB TITLE: Enterprise Applications Data Analyst                                          
Pay Grade: TE07          
TERM: 240 Days 
DEPARTMENT: Technology Division

Primary Purpose 

The Enterprise Applications Data Analyst supports data management and reporting in the district's enterprise applications, primarily SkywardQ and Frontline ERP. Responsibilities include extracting data from the Student, Finance, and Human Resources systems, writing backend automation scripts, SQL procedures, and designing reports using JasperSoft, PowerBI, and Skyward Report Manager. This role acts as a primary bridge between unstructured raw backend data and the program users.

Qualifications:

• Bachelor's Degree and/or equivalent experience related to implementation, support and management of district-wide business systems.
  • Demonstrated competence in administrative software and database systems support, management, setup, maintenance, and interfacing for ERP and student information systems.

Experience: 

• Minimum 3 years' experience working directly with district-level enterprise applications management and support in ERP and student information systems (Frontline ERP and SkywardQ experience a plus).
  • Minimum 3 years' experience with maintenance of complex, enterprise-scale client/server systems.
  • Minimum 3 years' experience with report development 

Special Knowledge and Skills: 

• Excellent organizational, communication, and interpersonal skills.
  • Excellent problem solving and analytical skills.
  • Ability to develop and maintain systems documentation and end user manuals
  • Ability to work well with various stakeholders at all levels of the district.
  • Customer centered and service oriented

Preferred Technical Skills

• Jaspersoft/Jasper Studio
  • DBVisualizer
  • Microsoft SQL Server Administration
  • T-SQL Development
  • SSRS / Power BI
  • API integrations
  • SSIS package development
  • Database performance tuning
  • ERP import/export utilities
  • Identity management integrations
  • Azure or cloud-hosted ERP environments
  • SSO/MFA implementation 

Major Responsibilities and Duties:

1. Develop, maintain, and support SQL scripts, SSIS packages, API integrations, automated import/export processes, and reporting solutions for systems including Frontline, Skyward, Power BI, JasperReports, and other district applications.
2. Manage and support third-party system integrations, including timekeeping systems, benefits administration platforms, banking interfaces, identity management systems, budgeting applications, state reporting systems, and other enterprise solutions.
3. Monitor and maintain data quality, integrity, and consistency across databases, applications, and integrated systems.
4. Design, develop, and maintain data sources, dashboards, reports, and analytics solutions using tools such as ABRE Data Warehouse, Power BI, JasperReports, and other reporting platforms.
5. Identify, recommend, and implement automation opportunities to improve efficiency, reduce manual processes, and enhance data accuracy.
6. Configure and maintain system workflows, business rules, security roles, approval processes, and application settings to support district operations.
7. Collaborate with district departments and campus personnel to gather requirements, analyze business needs, and develop effective technology solutions that support operational and instructional objectives.
8. Coordinate with district staff, software vendors, and third-party providers regarding support requests, system enhancements, product issues, and performance concerns.
9. Develop and maintain technical documentation, process guides, and written procedures related to programming, system administration, integrations, and operational workflows.
10. Participate in ongoing professional development activities to maintain and expand knowledge of enterprise applications, database technologies, reporting platforms, and indu