Programmer/Analyst Enterprise applications

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

JOB TITLE

Programmer/Analyst Enterprise Applications

Pay Grade: TN05

REPORTS TO: Director of Enterprise Applications

TERM: 240 Days

DEPARTMENT: Technology Division

Primary Purpose

The Enterprise Applications Report Writer/Programmer develops and maintains applications, reports, and databases.

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.

Experience

• 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

• SSRS / Power BI
• DBVisualizer
• Microsoft SQL Server Administration
• T-SQL Development
• Database performance tuning
• Microsoft Visual Studio experience a plus

Major Responsibilities And Duties

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

Working Conditions

Mental Demands: Ability to read, write, understand, interpret, and apply information at a moderately complex level essential for successful job performance; math skills at a college proficiency level; judgement and the ability to process information quickly; learn quickly and follow verbal procedures and standards; give verbal instruction; rank tasks in order of importance; copy, compare, compile and coordinate information and records. Understand how to manage stress and work with frequent interruptions.

Physical Demands/Environmental Factors

Repetitive hand motions; prolonged use of computers; steady phone interactions; continuous sitting, reaching, and bending. Must be able to lift at least 10 pounds.