Sr. Programmer Analyst

Johns Hopkins University

Baltimore , MD

ID: 7135633
Posted: March 22, 2023
Application Deadline: Open Until Filled

Job Description

Carey Business School is seeking a Senior Programmer Analyst who is responsible for understanding and maintaining software applications utilized by the Carey Business School, and working with end users to assess and evaluate business needs, from new software implementations as well as existing software. The ideal candidate will love working with various kinds of data, and be skilled in data extraction, transformation and reporting from various systems.

Specific Duties & Responsibilities
Applications Software Development & Support
Initiating and managing COTS (Commercial off-the shelf) or SaaS (software as a Service) projects and running project team meetings.
Establish concrete project goals.
Configuring COTS applications software. Working across functions to re-engineer and/or streamline processes and procedures in the context of fully utilizing system features/functions.
Develop and support system interfaces. Provide help desk support for applications software.
Liaison to software vendors – identifying software enhancements, testing vendor supplied solutions, understanding new enhancements/what to expect with system upgrades.
Provide data analysis and technical support for systems supported.
Analyze, propose and mange upgrades and/or replacements of existing database technologies; identifying costs, organizational impacts and training needs.
System interface design/development/support.
User report design/creation.
Assure quality and integrity of data collected and reports generated.
Become the system expert on any system(s) supported.
Build collaborative work environments; team building

Data Extraction, Transformation & Reporting
Plays role in contributing to the ETL (Extract Transform Load) design, evaluation, selection, implementation and support of databases solutions. Works closely with the Data/BI (Business Intelligence) Architect, software engineers on ETL development and BI Reporting. Troubleshoots problems regarding the databases, applications and provides technical support. Identifies and analyzes queries and stored procedures for optimization.
Develop/change data input, files/database structures, data transformation, algorithms, and data output by using appropriate computer language/tools to provide technical solutions for moderately complex application development tasks.
Document code and associated processes by adhering to development methodologies, adding code comments and appropriate documentation to various knowledge-base system(s) to simplify code maintenance and to improve support.
Analyze complex reporting needs and develop complex reports.

Testing & Documentation
Create and document moderately complex test scenarios using the appropriate testing tools to validate and verify application functionality.
Test all changes by using the appropriate moderately complex test scenarios to ensure all delivered solutions work as expected and errors are handling in a meaningful way.
Author and maintain documentation by writing audience-appropriate materials to serve as technical and/or end-user references.
Other duties as assigned.

Special Knowledge, Skills & Abilities
Demonstrable experience with SQL Query writing and analyzing.
Demonstrable experience with database development, management and access software, including Microsoft SQL Server, and other SQL tools.
Experience with implementing and customizing/extending a vendor-provided solution.
Experience with SSRS and/or other reporting tools.
Experience developing dashboards with PowerBi, Tableau or similar tools.
Experience with data manipulation tools.
Ability to adapt to changes in technology and environment quickly and easily. Must be able to serve as a change agent in promoting change among colleagues within the organization and its user communities.
Excellent verbal/written communication skills and ability to interact effectively with functional and technical communities.
Skilled in managing multiple projects and working independently.
Ability to effectively communicate technical information to non-technical staff.
Strong ability to work within a team and communicate effectively via all mediums.
Ability to work effectively with other people.
Ability to be creative and exercise initiative.
Excellent interpersonal, written, and verbal skills.
Must be able to stay abreast of technologies that are relevant to daily duties through formal training programs and/or independent study, as well as explore new technologies that would benefit the organization or its initiatives.

Minimum Qualifications
Bachelor's Degree.
Three years related experience.
Additional education may substitute for required experience and additional related experience may substitute for required education, to the extent permitted by the JHU equivalency formula.

Preferred Qualifications
Knowledge of Handshake, or other Career Services systems.
Knowledge of Qualtrics or other survey software.
Experience working with software vendors.
Experience with mobile deliver.