Programmer Analyst-Precision Medicine Data Management

Join an amazing global healthcare organization!

Excellent compensation package!

Awesome benefits, including dependent tuition reimbursement!

Sr. Programmer Analyst-Precision Medicine Data Management

Hybrid/Remote. In office 1-2 days amonth

Location: Johns Hopkins @ Harbor East 1000 Lancaster St., 5th Floor

Baltimore, MD 21202

Shift: Full Time (40 hours)

Day Shift, 8:30 am - 5:00 pm

This 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, including researchers for COVID-19.

This position reports to a Johns Hopkins IT Health Data Integration Services manager and 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.

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 team member will:

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 moderately complex problems by responding as problems arise, 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. Adhere 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.

Required Education: Two years college course work or trade school required. Additional experience may be substituted for education.

Equivalency Formula: JHU: 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.

Required Experience: Three years of related work experience with computer systems and applications. Additional education may substitute for experience.

Knowledge, Skills, & Abilities (KSA's):
• Requires a 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 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 moderately 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 is preferred, or must be obtained within 4 months of start date.
• Candidate must be detail oriented and have the ability to work on multiple priorities effectively and prioritize conflicting demands.

Johns Hopkins Health System and its affiliates are drug-free workplace employers.

We are committed to providing a healthy and safe environment for our patients, visitors and staff members. The Johns Hopkins Hospital has a tobacco-free at work policy. Employees must refrain from using any tobacco products during their work shifts — including while at lunch or on breaks, and whether they are on or off campus.