What are the responsibilities and job description for the Programmer/Analyst Enterprise applications position at Pasadena Independent School District?
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
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.
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.
- Minimum 3 years' experience with maintenance of complex, enterprise-scale client/server systems.
- Minimum 3 years' experience with report development
- 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
- SSRS / Power BI
- DBVisualizer
- Microsoft SQL Server Administration
- T-SQL Development
- Database performance tuning
- Microsoft Visual Studio experience a plus
- 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.