Req#: 641228 Sr. Programmer Analyst-Precision Medicine Data Management

Monday-Friday (8:30-5)

Hybrid/Remote

Johns Hopkins @ Harbor East

750 E. Pratt Street

5th Floor

Baltimore, MD 21202

Position Summary: The Sr. Programmer Analyst supports the Johns Hopkins in Health 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, including researchers for COVID-19.

The Sr. Programmer Analyst position reports to the Johns Hopkins IT Health Data Integration Services manager but is also expected to work closely with the Technology Innovation Center. This position plays an important role in helping Johns Hopkins leverage electronic medical record and other data assets for clinical research and for the development of clinical and patient facing applications. It is important for this role to understand the information and integration needs, source systems, quality standards, report and analytic requirements, and electronic medical record data to support centralized and decentralized development of institutional and business intelligence content.

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

• Requires some knowledge of data modeling, data management, and database development. Experience working in these areas in health system operations is preferred.
• Requires some 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 some proficiency in SQL programming, query writing, query performance tuning, and database technologies.
• Requires some 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 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, Java, C++, PHP, Python, IIS, SharePoint and 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.

Job Responsibilities: The primary responsibility of the Sr Programmer Analyst 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 Analyst will:

*In the office one day per month.

*In the office for special projects and Go Lives.

DESIGN, DEVELOPMENT, and DEPLOYMENT

1. Implement data ingest pipelines and transformations into the Precision Medicine Analytics Platform data lake;
2. Transform data to comply with standards such as the OMOP Common Data Model;
3. Extract and transform data to comply with researcher requirements;
4. Extract and transform data to comply with requirements from data visualization applications;
5. Deliver data to research groups using the Precision Medicine Analytics Platform;
6. 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;
7. Develop and validate the creation and maintenance of enterprise data definitions and metadata;
8. Participate in project planning to ensure effective use of technology and/or business process to meet customers' needs;

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. 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;
4. Define roles and responsibilities for centralized and decentralized data management functions.

Required Education: Bachelor's degree required. Additional experience may be substituted for education.

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: Three years of related work experience with computer systems and applications. Additional education may substitute for experience.