Converse University
Programmer Analyst
Converse University, Spartanburg, South Carolina, United States, 29302
SUMMARY OF POSITION:
Reporting to the Chief Information Officer, the Programmer Analyst will be primarily responsible for supporting the university's enterprise system by managing complex system requests, consulting with stakeholders about system requirements and conducting research. This role supports the university's existing Integration platform and researches new platforms as needed. Maintains software environments for development and testing. Perform software upgrades, uploads, and deploy university and/or third party software. Setup, test and maintain test databases and/or testing environments and will execute test plans and test cases from specifications and compile results as well as performing programming, scripting task and perform other related duties as assigned.
ESSENTIAL DUTIES/NON-ESSENTIAL DUTIES AND RESPONSIBILITIES:
Database 30%Create and maintain accurate and efficient SQL code, views, stored procedures and scripts in accordance with conventional best practicesBuilds and maintains reports and data extraction processes through SQL, SSRS, Jenzabar, InfoMaker, and other BI tools as neededContinued validation of reports, scripts and processes ensuring data integrity and privacy prior to releasing informationManipulates database using software packages as well as original source-language programs.Systems and Programming 50%
Participate in all aspects of software development including requirements analysis, effort estimation, technical investigation, software design and implementation, unit testing, and error correctionPrepares data for analysis using software packages and original programs.Consults with data owners and users to clarify requests and/or intended use of data and explain results.Writes and documents computer programs/software packages requiring knowledge of software logic and some programming languages and statistical programs to run analysis of data.Collaborates with functional areas on requirements for KPIs and collaborates on the availability of data, reporting and analysis.Working with functional users and supporting partners to develop and support integrations between on- and off-premises systems, including authentication. Ensuring compatibility and interoperability of systemsConducts research on software products, tools and technologies to maintain understanding of emerging technologies, standards and tools to justify recommendations for improvement sustainability and to support purchasing effortsSecurity 20%
Managing system change requests, coordinating testing, recommending and implementing security changesMaintain and enhance technical documentation and assist in training administrators and end users with how to use the business systems.Responsible for periodic review of data security and privacy practices, to include but not limited to user, group, and role-based permissions on tables, views, stored procedures and systems that access the data.Works closely and collaboratively with the Network Administrator, System Administrator and Chief Information Officer to ensure the security and the backup of systems and data is performed at accurate and at predetermined intervalsJOB QUALIFICATIONS:
MINIMUM QUALIFICATIONS:
Bachelor's degree in computer science or information technologyTwo years' experience working with SQL, APIs, and ETLPREFERRED QUALIFICATIONS:
Experience working with Jenzabar, our ERP/SISProject management experienceWorking knowledge of process improvement and workflow modelingKNOWLEDGE, SKILLS, AND ABILITIES:
Working knowledge of Identity and Access ManagementAbility to communicate with self-awareness, sensitivity, and professionalism in a diverse work environment.Ability to prioritize work effectively and be self-motivated to work independently and follow-through to meet department deadlines.Ability to deliver high-level customer service.Excellent written and verbal communication skills.Experience with troubleshooting system problems and command line skills strongly preferred.Familiarity with project management methodology and ability to both lead, and participate in, projects.Strong computer, hardware, software, and analytical skills.Well-grounded philosophy of honesty, integrity and respectDemonstrated ability to establish and maintain effective working relationships with various constituents including both internal to the organization and with the publicPlan, design, and maintain custom and third party programsProvide technical support to usersExplain technical concepts in non-technical terms to faculty, staff and students;
GUIDELINES AND SUPERVISION:
Programmer Analyst will report to the Chief Information Officer and should be able to work autonomously with limited supervision. The position requires the use of sound independent judgment and the ability to work both independently and as a member of the Campus Technology team. The Programmer Analyst must maintain strict confidentiality of records and respect and that all aspects of the office work will be accomplished with the highest professional standards.
Work Schedule:
Hybrid
Hours:
The university's operating hours are Monday through Thursday 8am - 5pm and Friday 8am - 1pm. This position requires occasional weekends and hours outside of regular business hours.
Licenses : NA
DISCLAIMER:
The preceding job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this classification. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.
We believe that a diverse faculty and staff are essential to achieving academic excellence; thus, we strongly encourage applications from candidates from all racial, ethnic, and cultural backgrounds.
Reporting to the Chief Information Officer, the Programmer Analyst will be primarily responsible for supporting the university's enterprise system by managing complex system requests, consulting with stakeholders about system requirements and conducting research. This role supports the university's existing Integration platform and researches new platforms as needed. Maintains software environments for development and testing. Perform software upgrades, uploads, and deploy university and/or third party software. Setup, test and maintain test databases and/or testing environments and will execute test plans and test cases from specifications and compile results as well as performing programming, scripting task and perform other related duties as assigned.
ESSENTIAL DUTIES/NON-ESSENTIAL DUTIES AND RESPONSIBILITIES:
Database 30%Create and maintain accurate and efficient SQL code, views, stored procedures and scripts in accordance with conventional best practicesBuilds and maintains reports and data extraction processes through SQL, SSRS, Jenzabar, InfoMaker, and other BI tools as neededContinued validation of reports, scripts and processes ensuring data integrity and privacy prior to releasing informationManipulates database using software packages as well as original source-language programs.Systems and Programming 50%
Participate in all aspects of software development including requirements analysis, effort estimation, technical investigation, software design and implementation, unit testing, and error correctionPrepares data for analysis using software packages and original programs.Consults with data owners and users to clarify requests and/or intended use of data and explain results.Writes and documents computer programs/software packages requiring knowledge of software logic and some programming languages and statistical programs to run analysis of data.Collaborates with functional areas on requirements for KPIs and collaborates on the availability of data, reporting and analysis.Working with functional users and supporting partners to develop and support integrations between on- and off-premises systems, including authentication. Ensuring compatibility and interoperability of systemsConducts research on software products, tools and technologies to maintain understanding of emerging technologies, standards and tools to justify recommendations for improvement sustainability and to support purchasing effortsSecurity 20%
Managing system change requests, coordinating testing, recommending and implementing security changesMaintain and enhance technical documentation and assist in training administrators and end users with how to use the business systems.Responsible for periodic review of data security and privacy practices, to include but not limited to user, group, and role-based permissions on tables, views, stored procedures and systems that access the data.Works closely and collaboratively with the Network Administrator, System Administrator and Chief Information Officer to ensure the security and the backup of systems and data is performed at accurate and at predetermined intervalsJOB QUALIFICATIONS:
MINIMUM QUALIFICATIONS:
Bachelor's degree in computer science or information technologyTwo years' experience working with SQL, APIs, and ETLPREFERRED QUALIFICATIONS:
Experience working with Jenzabar, our ERP/SISProject management experienceWorking knowledge of process improvement and workflow modelingKNOWLEDGE, SKILLS, AND ABILITIES:
Working knowledge of Identity and Access ManagementAbility to communicate with self-awareness, sensitivity, and professionalism in a diverse work environment.Ability to prioritize work effectively and be self-motivated to work independently and follow-through to meet department deadlines.Ability to deliver high-level customer service.Excellent written and verbal communication skills.Experience with troubleshooting system problems and command line skills strongly preferred.Familiarity with project management methodology and ability to both lead, and participate in, projects.Strong computer, hardware, software, and analytical skills.Well-grounded philosophy of honesty, integrity and respectDemonstrated ability to establish and maintain effective working relationships with various constituents including both internal to the organization and with the publicPlan, design, and maintain custom and third party programsProvide technical support to usersExplain technical concepts in non-technical terms to faculty, staff and students;
GUIDELINES AND SUPERVISION:
Programmer Analyst will report to the Chief Information Officer and should be able to work autonomously with limited supervision. The position requires the use of sound independent judgment and the ability to work both independently and as a member of the Campus Technology team. The Programmer Analyst must maintain strict confidentiality of records and respect and that all aspects of the office work will be accomplished with the highest professional standards.
Work Schedule:
Hybrid
Hours:
The university's operating hours are Monday through Thursday 8am - 5pm and Friday 8am - 1pm. This position requires occasional weekends and hours outside of regular business hours.
Licenses : NA
DISCLAIMER:
The preceding job description has been designed to indicate the general nature and essential duties and responsibilities of work performed by employees within this classification. It may not contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees to do this job.
We believe that a diverse faculty and staff are essential to achieving academic excellence; thus, we strongly encourage applications from candidates from all racial, ethnic, and cultural backgrounds.