Enterprise Applications Programmer & Analyst | SQL & BI

Pasadena Independent School District; Pasadena (TX); On-site; USD 85,000 - 115,000; Full time

Job summary

The Pasadena Independent School District seeks a Programmer/Analyst Enterprise Applications to develop and maintain complex reports, SQL scripts, and databases to support district operations.

The role requires collaboration with district departments to gather requirements, ensure data quality, and implement scalable technology solutions using Power BI, SSRS, and a variety of data sources.

Qualifications

• BS in Computer Science, or related area, or equivalent professional experience.
• Demonstrated competence in report writing, SQL, and database systems support, management, setup, maintenance, and interfacing.

Responsibilities

• Develop and maintain complex reports using PowerBI, Frontline, and Skyward, using multiple data connections to various data source types.
• Develop, maintain, and update complex SQL scripts.
• Monitor and maintain data quality, integrity, and consistency across databases, applications, and integrated systems.
• Design and design other solutions when necessary, including minor projects using Microsoft Visual Studio or other aspx languages.
• Configure and maintain system workflows, business rules, security roles, approval processes, and application settings to support district operations.
• Collaborate with district departments and campus personnel to gather requirements, analyze business needs, and develop effective technology solutions that support operational and instructional objectives.
• Coordinate with district staff, software vendors, and third-party providers regarding support requests, system enhancements, product issues, and performance concerns.
• Develop and maintain technical documentation, process guides, and written procedures related to programming, system administration, integrations, and operational workflows.
• Participate in ongoing professional development activities to maintain and expand knowledge of enterprise applications, database technologies, reporting platforms, and industry best practices.
• Provide technical support and assistance to users through help desk tickets, email, telephone, and other support channels.
• Perform other duties as assigned.

Skills

SQL

Report development

Communication

Analytical skills

Education

BS in Computer Science or related field

Tools

SSRS

Power BI

DBVisualizer

Microsoft SQL Server Administration

T-SQL Development

Microsoft Visual Studio

Job description

The Pasadena Independent School District seeks a Programmer/Analyst Enterprise Applications to develop and maintain complex reports, SQL scripts, and databases to support district operations.

The role requires collaboration with district departments to gather requirements, ensure data quality, and implement scalable technology solutions using Power BI, SSRS, and a variety of data sources.