Published date Posted on Indeed on Oct 14, 2021 (2 d ago)
Sr. Programmer Analyst

The Institute of Clinical and Translational Research seeks a Senior Programmer Analyst who will be responsible for the creation, implementation, maintenance, performance, production support and documentation of various departmental and enterprise-wide application systems. This includes but is not limited to the installation, modification, and testing of new and/or upgraded applications (packages or home grown), operating systems, file structures, hardware, communication devices, and productivity tools. This role applies analysis techniques and procedures to gather and then translate business requirements into functional/technical specifications and designs, uses functional specifications and designs, produces all or part of the deliverables as well as maintains databases and application system code.

Job Scope/Complexity:
  • Under limited guidance, responsible for full life-cycle of small to medium sized moderately complex projects.
  • Demonstrates strong ability in technology and/or strong understanding of the business/clinical/education process.
  • Builds and maintains client relationships through positive interactions.

Specific Duties & Responsibilities:

Analysis and Requirements Gathering:
  • Define moderately complex business/clinical/education problems by meeting with clients to observe and understand current processes and the issues related to those processes. Provide written documentation of findings to share with the client and other IT colleagues.
  • Gather moderately complex system requirements by meeting with clients and researching existing technology to understand the business requirements and possible solutions for new applications.

Design and Development:
  • Develop detailed tasks and project plans by analyzing project scope and milestones for moderately complex projects in order to ensure product is delivered in a timely fashion according to software lifecycle standards.
  • Write functional/technical specifications by taking the provided moderately complex system requirements and putting them into functional and technical descriptions for use by programmers and business analysts to develop technical solutions.
  • 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.

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.

Implementation and Maintenance:
  • Implement changes by adhering to the change management policies and procedures for any given project to communicate to all parties the nature, significance, and risk factors of the solution.
  • Monitor changes and resolve moderately complex problems by responding as they occur, by reviewing all processing and output of the newly implemented solution, and by proactively ensuring the solution works successfully in order to satisfy the customer requirements and to provide a smooth transition to the new solution.
  • Provide support by triaging and resolving moderately complex issues to ensure prompt, effective service.

The responsibilities listed above are typical examples of the work performed by this position. Not all duties assigned to this position are included, nor is it expected that everyone in this position will be assigned every job responsibility.

Minimum Qualifications (Mandatory):
  • Bachelor's degree required. Additional experience may be substituted for education.
  • Three years of related work experience with computer systems and applications. Additional education may substitute for experience.

Preferred Qualifications:
  • Knowledge in the assigned application as well as the platform on which it runs.

Special Knowledge, Skills & Abilities:
  • Must possess all requisite knowledge, skills, and abilities as posted in the supplemental section.
  • Must demonstrate strong critical thinking and analytical reasoning skills.
  • Ability to work on multiple priorities effectively.
  • Ability to prioritize conflicting demands.
  • Ability to execute assigned project tasks within established schedule.
  • Ability to work collaboratively in a team environment.
  • Ability to communicate effectively in the service of users and colleagues.
  • Writes and communicates clearly and concisely.
  • Possesses sound documentation skills.
  • Ability to maintain confidentiality.
  • Must demonstrate exemplary customer service skills.

Physical Requirements:
  • Sitting in a normal seated position in office setting.
  • Standing and/or walking for extended periods of time.
  • Lifting and/or assisting patients during evaluations within crowded clinical environment.
  • Reaching by extending hand(s) or arm(s) in any direction.
  • Finger dexterity required to manipulate objects with fingers rather than with whole hand(s) or arm(s), for example, using a keyboard.
  • Communication skills using the spoken word.
  • Ability to see within normal parameters.
  • Ability to hear within normal range.
  • Ability to move about.

Position Overview: This position is responsible for writing and maintaining extract/transform/load routines to get data from institutional data sources for use by clinical researchers.

Position's roles & interactions:

This position will require a significant level of collaboration with other members of the Core for Clinical Research Data Acquisition (CCDA) team and with the Precision Medicine team. It will also require working closely with our Medical Director/Honest Broker on specific projects and techniques. This position will also require working closely with our research customers to discern their needs and to understand and address changes that arise from end user acceptance testing. A weekly scrum is held with the entire team to review all work. The senior programmer analyst will use Jira to document and track assignments. Data must be delivered in a secure manner, following all applicable institutional policies and State and Federal regulations for privacy, security, and the conduct of human subject research.

The specific systems, applications, projects for which the position is responsible:
This position is will work on extract/transform/load projects which could last in duration from 1 day to 2 weeks. The major systems with which the position interfaces are: Epic, Precision Medicine Analytic Platform(PMAP), and DataMart/CaseMix.

Scale/size of area, project and/or system supported

This position could work with about one hundred different users annually, primarily from the Johns Hopkins School of Medicine, but also from the Johns Hopkins School of Public Health, Nursing, and the Engineering Program at the Homewood Campus. The position will require some travel to the Johns Hopkins Hospital and possibly to other locations in Baltimore in order to meet with customers. The most complex part of this job is learning

Required & preferred skills specific to position:

Required: Experience using SQL Server to extract and transform data.

Preferred skills:

Experience with mining data from one or more of the following systems: Epic, EPR2020, Sunrise Clinical Manager, PMAP, DataMart/CaseMix.

Full command of and experience with complex SQL, including:

DBA-level understanding of SQL Server database and table design and performance, including logs, fillfactor settings, optimization, SQL Server Agent, user permissions and schema, transaction management, iSQL, bcp, batch files.

Advanced DDL statements, including:

CREATE/ALTER/DROP tables, constraints, indexes, referential integrity, primary and foreign keys, data typing, defaults, defaults, check constraints, rules, triggers, logging, sort orders and character sets, transaction logs, global and local temporary objects, locking and lock contention/escalation, killing spids.

Advanced DML statements, including:

CASE statements, PATINDEX/CHARINDEX parsing, regular expressions, aggregate queries/scalar and vector aggregates, stored procedures, parameters, local and global variables, delimiters, CAST and CONVERT, datetime arithmetic, Boolean comparisons, while loops, cursors, RAISERROR, query optimization, SQL functions, system functions, querying system tables, query optimization.

SQL Server Management Studio experience, including compiling and scripting stored procedures, database mail, log analysis, optimizing/analyzing indexes.

SQL Server Integration Services experience include project and package creation/design; data flow tasks and data conversion; OLE, flat file and Excel data sources/destinations and connection managers; scheduled jobs; monitoring; data transformation; email notification.

Basic command of clinical research methods and epidemiologic principles, including missing-data handling, imputation (and its perils), parametric vs. non-parametric analysis, skewed distributions, implications of continuous vs. categorical data, assessing measurement error, form design, PID validation, CPT data, and ICD9/ICD10 diagnosis categories and handling within Epic.

On call requirements (if applicable): There are no on call requirements for this job.

Additional information:

If the candidate does not already have Epic Clarity Certification, then s/he will be expected to attend training sessions at Epic Headquarters in Verona Wisconsin for training leading to Clarity certification. Certification is required for this job. In order to remain employed in this position, the candidate must pass the certification test in 3 attempts.

JHU Equivalency Formula: 30 undergraduate degree credits or 18 graduate degree credits = 1 year of experience. For jobs where equivalency is permitted, up to two years of non-related college coursework may be applied towards the total minimum education/experience required for the respective job.

Classified Title: Sr. Programmer Analyst
Role/Level/Range: ATP/04/PD
Starting Salary Range: $59,280 - $81,435 annually (commensurate with experience)
Employee group: Full Time
Schedule: M-F; 8:30am-5:00pm
Exempt Status: Exempt
Location: JH at Harbor East
Department name: SOM ICTR Inst Clin Translational Resrch
Personnel area: School of Medicine

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 HR Business Services Office at For TTY users, call via Maryland Relay or dial 711.

The following additional provisions may apply depending on which campus you will work. Your recruiter will advise accordingly.

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.

Equal Opportunity Employer
Note: Job Postings are updated daily and remain online until filled.

EEO is the Law
Learn more:

To apply, visit


Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Error on reporting

Related jobs

Piper Companies Piper Companies |
2 d ago

Piper Companies is looking for a Database Architect who would like to join an industry leader in the financial services sector located in Philadelphia, PAThis is a Remote Opportunity!Responsibilities for the Database Architect include:You will be responsible for providing leaders

Description:Job Summary:Under limited supervision, this position will be responsible for configuring and building all software applications with regards to the test, pre-production and production environments. Work closely with Software Development and Software Quality Assurance.

Overview: AM LLC has an immediate opening for (1) remote Database Administrato / Developer to support our Veterans Administration client. Note: Due to federal government security clearance requirements, applicants must be a US citizen or Green Card holder to be considered.Respons

PRIMARY RESPONSIBILITY: Perform database engineering and administration activities including design, planning, configuration, monitoring, automation, self-serviceability, alerting, and space management, database backup and recovery. Plan computerized databases, including base def

Morgan 6 is a fast-growing leader in the government contracting field based in Charleston, SC. Our mission is to expertly apply state of the art technology to improve the lives of Warriors – past, present, and future. Our core solutions include Software Engineering and Agil

Introduction:Our goal at Pivotree is to help accelerate the future of frictionless commerce. We will help lead this change over the next decade because we believe a future where technology is embedded intimately into all aspects of our everyday lives can benefit everyone and will