Classified title: Sr. Programmer Analyst Role/Level/Range: ATP/4/PD Starting Salary Range ($s): Commensurate with experience Employee group: Full time Schedule (hours/days): 37.5 Hours per week Employee subgroup (FLSA Status): Exempt Location: JH at Legg Mason Harbor East Department name: Software and Reporting Services Group Personnel area (School): Carey Business School
Purpose of Position:
The Sr. Business Analyst is responsible for maintaining software applications utilized by the Carey Business School, with primary focus on Symplicity, a Career Services System. S/he will be responsible for data extraction, transformation and reporting from Symplicity and other systems supported by the Johns Hopkins Carey Business School.
Primary Duties and Responsibilities:
Applications Software Development and 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 and 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 and 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
Education, Experience, Licensure, Certification:
Bachelor's degree required.
Three years of related work experience with computer systems and applications required.
Three to five years' experience preferred.
Additional experience may be substituted for education and additional education may substitute for experience. Equivalency Formula: 30 undergraduate degree credits or 18 graduate degree credits = 1 year of experience.
Knowledge and Skill:
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 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.
Knowledge of Symplicity, Slate or other Career Services systems.
Experience working with software vendors.
Experience with mobile delivery strategies.
Experience with SalesForce
Carey Career Development Office: Exchange information, Advise/Consult, Negotiate/Influence
Carey IT and Administrative Office Staff: Exchange information, Advise/Consult, Negotiate/Influence
Carey Faculty, Staff and Students: Exchange information
Central IT Team: Exchange information, Advise/Consult, Negotiate/Influence
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130... years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Baltimore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.