Programmer/Analyst Enterprise applications

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

Job summary

Pasadena Independent School District in Pasadena, TX seeks a Programmer/Analyst Enterprise Applications to develop and maintain complex reports, applications, and databases. You will work with Power BI, SSRS, SQL Server, and Frontline/Skyward data sources to support district operations and instructional objectives.

The role requires a BS in CS or related field, 3+ years in enterprise systems, strong analytical and communication skills, and the ability to document processes and collaborate with

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

Report writing

SQL

Database systems

Organizational skills

Communication

Interpersonal skills

Problem solving

Documentation

Stakeholder management

Customer service

Education

BS in Computer Science

Related area or equivalent experience

Tools

SSRS

Power BI

DBVisualizer

Microsoft SQL Server Administration

T-SQL Development

Database performance tuning

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.

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.