Job Req ID:  112667

Sr. Software Engineer

We are seeking a Sr. Software Engineer.


Specific Duties & Responsibilities

  • Service extract, transform, and load (ETL) requests from the clinical research community for data from our information systems such as and Epic Clarity, Epic Data Warehouse, Sunrise Clinical Manager, CaseMix/DataMart, and EPR2020.
  • This includes the ability to meet with researchers to understand their needs, write a specification that reflects the work to be done, extract data from the appropriate source systems, transform the data to meet the customers’ needs, package the data into the appropriate format for transmittal, and set up recurring ETL jobs.
  • This position will also work on i2b2 as needed. I2b2 is a tool which allows researchers to use a drag and drop user interface to explore deidentified data for research use.
  • Research informatics support for EPIC, i.e. Cogito data warehouse validation process and data element evaluation for ACO; Continue maintain and support for CRU Online and gSurvey application, build extra reporting and exporting; excel spreadsheet functions for both application for large dataset output; Enhance ICTR Connection request/management system for allowing multiple review scoring sheets and multiple versions for request form.
  • Trials at Hopkins search engine query not only from depository database but also from clinicaltrials.gov; Centralized JHED login for all applications through ICTR web server, secured with cross site scripting prevention as well as log monitor mechanisms.
  • Ongoing development of online ICTR evaluation/survey tolls and IRB Survey system, Clinical research network investigator information registration form.
  • ICTR utility report and email list report; Real-time, on-demand, linked utilization and financial reporting, providing overall budgetary expenditures on yearly grant awards.
  • Data sharing with current and future institutional databases (e.g., eiRB, EPIC), eiRB feed.
  • Registry service for ICTR annual events, such as Henrietta Lacks Memorial Lecture and Introduction to Clinical Research Course; Database design services for ICTR supported principal investigators and their study team.


Roles & Interactions

  • The Sr. Software Engineer will take their primary direction for day-to-day tasks from the ICTR Informatics Project Manager.
  • They will often interact with their research community customers, including principal investigators, physicians, research nurses, study coordinators, and research data managers to help solve their data needs.
  • They will also work closely with research informaticians.


Specific systems, applications, projects for which the position is responsible.

  • This position is responsible for all ICTR Informatics extraction projects tracked in our JIRA system. These projects vary from month to month but in general include extracting, transforming, and loading data.
  • They must have a good understanding of at least one of our primary information systems (Epic, SCM, EPR) and will be expected to learn the data infrastructure of the remaining applications.


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

  • This engineer will access systems which contain data for about 5M patients for Johns Hopkins Hospital, Johns Hopkins Bayview Medical Center, Johns Hopkins Community Physicians, Howard County General Hospital, Sibley Memorial Hospital, and Suburban Hospital.


Required & Preferred skills specific to position.

  • This position requires 4 or more years of experience as a Microsoft SQL server data analysis, with experience in TSQL, SSIS and stored procedure development.
  • This position requires mastery of clinical data in at least one of the following systems: Epic, Sunrise Clinical Manager, EPR2020, CaseMix/DataMart.
  • In addition to the technical skills listed, this position requires previous demonstration of good teamwork skills, the ability to write clear requirements and design documents, and the ability to be successfully in direct customer-facing interactions.


On Call Requirements

  • This position does not currently have on call requirements, however, on call could be introduced in the future to support i2b2.
  • If that were to occur, then they would share on call responsibilities with teammates, being on call 24x7 about 1 week per month and receiving the standard IT@JH stipend for this service.


Primary Purpose

  • Participate in the development of solutions using extensive programming/analytical expertise for long-term projects to include maintenance, modification or development of applications/solutions.


General Responsibilities

  • Apply system analysis techniques and procedures to gather and then translate business requirements into high level functional/technical specifications and designs.
  • Research technology developments and measure their impact on existing standards and application architectures. Coordinate & provide experienced leadership to strategic planning, design, implementation, and verification of software, software system models, platform software advancement and product software.
  • Serve as a technical resource for the development team working on highly complex applications.
  • May be required to use technical expertise to install/maintain specialized areas of OS and related software.
  • Create, review & implement automated facilities that result in cost reduction, operating efficiency and increased user satisfaction.


Work Complexity

  • Work is complex and varied in nature.
  • Define and discern key aspects of a problem and develops an integrated solution within a broad technical and business context.
  • May provide guidance/training to more junior staff.
  • Recognized expert internally within a discipline.


Leadership

  • Is expected to lead as a technical expert and to participate with senior business leaders to affect change in the environment.
  • Is a resource/mentor for others within and beyond the organization.


Life Cycle Skills

  • Serves as project leader for moderate and large projects.
  • Will be responsible for a significant function/phase of the largest projects.


Degree Of Independence Supervision

  • Generally, works independently.
  • Responsible for general oversight of any size project.
  • Examples are not readily available in existing code or online.
  • Experience and broad principles guide development.
  • Serve as a resource to more junior staff.


Training and Mentoring

  • Participate in a training program jointly developed with their manager/supervisor to gain technical and soft skills.
  • Serve as technical consultant for both internal and external areas.
  • Mentor lower-level IT personnel as well as user community with their expert knowledge of the application.


Authority

  • May oversee work of more junior staff / be a team leader.


Minimum Qualifications
  • Bachelor's Degree.
  • Six years of 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
  • Skills and experience that are highly preferred but not required are: use of SSRS, i2b2.

 


 

Classified Title: Sr. Software Engineer 
Role/Level/Range: ATP/04/PF  
Starting Salary Range: Min $84,700 - Max $148,300 Annually ($97.880 targeted; Commensurate with experience) 
Employee group: Full Time 
Schedule: M-F, 8:30 am - 5:00 pm 
Exempt Status: Exempt 
Location: Remote 
Department name: SOM ICTR Inst Clin Translational Resrch  
Personnel area: School of Medicine 

 

Total Rewards
The referenced salary range is based on Johns Hopkins University’s good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education/training and skill level. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/

 

Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines:
JHU Equivalency Formula: 30 undergraduate degree credits (semester hours) or 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.

**Applicants who do not meet the posted requirements but are completing their final academic semester/quarter will be considered eligible for employment and may be asked to provide additional information confirming their academic completion date.


The successful candidate(s) for this position will be subject to a pre-employment background check. Johns Hopkins is committed to hiring individuals with a justice-involved background, consistent with applicable policies and current practice. A prior criminal history does not automatically preclude candidates from employment at Johns Hopkins University. In accordance with applicable law, the university will review, on an individual basis, the date of a candidate’s conviction, the nature of the conviction and how the conviction relates to an essential job-related qualification or function.

 

The Johns Hopkins University values diversity, equity and inclusion and advances these through our key strategic framework, the JHU Roadmap on Diversity and Inclusion.

 

Accommodation Information

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 Talent Acquisition Office at jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit accessibility.jhu.edu.

 

Johns Hopkins has mandated COVID-19 and influenza vaccines, as applicable. The COVID-19 vaccine does not apply to positions located in the State of Florida. Exceptions to the COVID and flu vaccine requirements may be provided to individuals for religious beliefs or medical reasons. Requests for an exception must be submitted to the JHU vaccination registry. For additional information, applicants for SOM positions should visit https://www.hopkinsmedicine.org/coronavirus/covid-19-vaccine/ and all other JHU applicants should visit https://covidinfo.jhu.edu/health-safety/covid-vaccination-information/.

 

The following additional provisions may apply, depending on campus. Your recruiter will advise accordingly.

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.

 

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

 

 

Total Rewards
The referenced salary range is based on Johns Hopkins University’s good faith belief at the time of posting. Actual compensation may vary based on factors such as geographic location, work experience, market conditions, education/training and skill level. Johns Hopkins offers a total rewards package that supports our employees' health, life, career and retirement. More information can be found here: https://hr.jhu.edu/benefits-worklife/.

Accommodation Information
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 Talent Acquisition Office at jhurecruitment@jhu.edu. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit https://accessibility.jhu.edu/.

Equal Opportunity Employer
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

EEO is the Law:
https://www.eeoc.gov/sites/default/files/2023-06/22-088_EEOC_KnowYourRights6.12ScreenRdr.pdf

Remote