Sr. Programmer Analyst

John Hopkins University


Sr. Programmer Analyst
John Hopkins University

General Description

The Senior Programmer/Analyst is a member of the software application development team and involved in software/database development, application maintenance and database system administration. Responsibilities include designing and developing databases from project and users requirements, maintaining and enhancing applications and systems and providing user support when application and system are in production lines; installation, testing, and upgrading new applications and software. This position participates in various IT and research projects and joins project teams with other application programmers and database administrators. This position works closely with the Office of Assessment and Evaluation staff, providing technical expertise, database, reporting and analytics support. The Senior Programmer/Analyst reports to the Director, School of Medicine Office of Information Technology.

Specific Responsibilities:

• Database design, development and implementation, including user and system requirements collection, proto-typing and testing, application database schemes design and integration with applications, production maintenance and user support.

• Create SQL reports and work with end users on report specifications; create and run queries as needed, both scripted and ad hoc.

• Microsoft SQL Server administration – creating and maintaining users, permission, backups, recovery, monitoring, database optimization, performance tuning.

• Performs tasks that relates to systems programming, administration and database programming including stored procedures scripting on MS SQL server and Shell scripting in Windows-based environment.

• Configure, implement and support data analytics projects (WebBI, Tableau, Panorama Nicto).

• Participates in institutional-level information technology initiatives as assigned.

• Participates in campus-wide technical projects as assigned.

• Other duties and projects as assigned.

Qualifications

Bachelors degree in Computer Science, Information Science, or related field required.

Minimum three years of related work experience with computer systems and applications required.

Additional education may substitute for experience or additional experience may substitute for education, to the extent permitted by the JHU equivalency formula.

Knowledge of and experience in database design, development and administration with MS-SQL is required.

Work experience programming in Windows-based environment is required.

Experience with Internet and Web programming using ASP.NET or JSP and JavaScript, HTML, PHP and CGI/Shell is desirable

Experience and knowledge with XML, .Net, J2EE, Web Services, and Open source software and standards are a strong plus.

Demonstrated ability to work in a team environment with a customer focus.

Effective communication skills, both oral and written, required.

Must be able to communicate effectively, both orally and written, in English.

JHU Equivalency Formula: 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.

Preferred Qualifications

Masters preferred.

Some experience with data analytics or statistical packages preferred.

NOTE: The successful candidate(s) for this position will be subject to a pre-employment background check.

If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the School of Medicine HR Divisional Office at 410-955-2990. For TTY users, call via Maryland Relay or dial 711.

During the Influenza (“the flu”) season, as a condition of employment, The Johns Hopkins Institutions require all employees who provide ongoing services to patients or work in patient care or clinical care areas to have an annual influenza vaccination or possess an approved medical or religious exception. Failure to meet this requirement may result in termination of employment.

The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.

For full application instructions and position description, visit https://jobs.jhu.edu/jhujobs/jobview.cfm?reqId=314688&postId=15269