Skip to main content

Sr. Software Engineer-TIC

Sr. Software Engineer

Requisition ID 303685

Work Location: Johns Hopkins Hospital, Rangos Building, Baltimore, MD 21287

Grade: IW

Join an amazing global healthcare organization!

Excellent compensation package (base + optional sign-on or relocation incentive)

Temporarily remote through the pandemic with hybrid model afterwards.

Awesome benefits, including dependent tuition reimbursement.

Serious applicants ready to hit the ground running only!

Position Summary:

The Sr. Software Engineer position supports the Johns Hopkins inHealth Precision Medicine initiative. The position has several responsibilities, including building ingest of data from source systems to the Precision Medicine data lake and transforming data to serve a number of different data consumers.

This project is focused on establishing provenance and expanding the use of critical hospital operations and categorical billing data – specifically admit, transfer and discharge (ADT) data, ICD-10 codes, procedure codes and the groupings and scores derived subsequently. This data instrumental in determining the distribution of hospital operations resources, the quality ratings of the institutions, and the downstream research outcomes and fundamentally to creating a learning health system.

Job Responsibilities:

The primary responsibility of the Software Engineer is to work on data extraction, transformation and load to support research and data visualization projects. This may involve extending the data lake with additional data to meet business needs. To achieve this the Data Engineer will:

DESIGN, DEVELOPMENT, and DEPLOYMENT

  1. Implement data ingest pipelines and transformations into the Precision Medicine Analytics Platform data lake;
  2. Extract and transform data to comply with team requirements;
  3. Extract and transform data to comply with requirements from data visualization applications and other kinds of reports;
  4. Deliver data to operations groups using the Precision Medicine Analytics Platform;
  5. Design and deliver guidelines that allow a broad base of internal and external developers to build content sourced in the data lake while adhering to established standards and strategy;
  6. Develop and validate the creation and maintenance of enterprise data definitions and metadata;
  7. Serve as a specialist/consultant on complex projects;
  8. Formulate and articulate plans for data or infrastructure architecture as needed;
  9. Participate in project planning to ensure effective use of technology and/or business process to meet customers’ needs;
  10. Track relevant cloud technologies to:
    1. Determine their maturity and applicability to the enterprise;
    2. Assess the relative impact to IT strategy and interpret meaning to senior IT leadership team;
    3. Lead and manage strategic activities, including adoption of cloud services and continuous integration strategies;

IMPLEMENTATION AND MAINTENANCE

  1. Monitor changes and resolve highly complex problems by responding as problems arise; Accomplish this by reviewing all processing and output of the newly implemented solution, and by proactively ensuring the solution works successfully in order to satisfy customer requirements and to provide a smooth transition to the new solution;
  2. Oversee 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;
  3. Conform to data policies, governance structures and control frameworks for the ongoing management of data to ensure convergence, synchronization, accuracy, completeness and reliability;
  4. Make recommendations for optimization and performance improvements to database design, as well as improvements to ETL processes and tuning of software and hardware for existing and projected needs;
  5. Work with source system owners to establish and measure data quality metrics, investigate and resolve source data issues, and continuously evaluate and refine transformation rules;
  6. Define roles and responsibilities for centralized and decentralized data management functions.

STRATEGY/LEADERSHIP

  1. Establish and monitor project and task schedules and ensure adherence to work deadlines;
  2. Contribute to staff evaluations.

Knowledge, Skills, & Abilities (KSA’s):

  • Requires a thorough knowledge of data modeling, data management, and database development. Experience working in these areas in health system operations is preferred.
  • Requires strong technical knowledge of data integration tools, data modeling tools, metadata tools, and database design. Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimization, and performance tuning.
  • Requires strong proficiency in SQL programming, query writing, query performance tuning, and database technologies.
  • Requires experience with all phases of the Software Development Life Cycle (SDLC).
  • Requires analytical ability to solve complex technical problems and participate as part of a diversified staff in matrix-managed groups.
  • Requires ability to articulate technical and organizational approaches to meet operational data requirements.
  • Requires ability to convey technical methods, approaches, and plans to an audience of varying degrees of technical understanding including peers and customers.
  • Knowledge of ETL processes, cloud-based storage and data management technologies, such as Azure Databricks and Azure Data Factory is preferred.
  • Preferred Experience with the following databases, workbenches, and codebases: SQL Server, SQL Server Management Studio, SSIS, Python, Jupyter, or R.
  • Technical certification in Epic Clarity and/or Caboodle is preferred.
  • Candidate must be detail oriented and have the ability to work on multiple priorities effectively and prioritize conflicting demands.

Required Education:

Bachelor’s degree required. Additional experience may be substituted for education.

Technical certifications in Epic Clarity or Caboodle, preferred.

Equivalency Formula:

JHH: Related experience beyond minimum training experience qualifications may substitute for formal education requirement on a two years experience-for-one year education basis

Required Experience:

Six years of related work experience with computer systems and applications. Experience with Java, Vue.js and working knowledge of Linux system administration.