Applications Analyst II
Somerville, MA

Job Description

About Us:

As a not-for-profit organization, Partners HealthCare is committed to supporting patient care, research, teaching, and service to the community by leading innovation across our system. Founded by Brigham and Women's Hospital and Massachusetts General Hospital, Partners HealthCare supports a complete continuum of care including community and specialty hospitals, a managed care organization, a physician network, community health centers, home care and other health-related entities. Several of our hospitals are teaching affiliates of Harvard Medical School, and our system is a national leader in biomedical research.

We're focused on a people-first culture for our system's patients and our professional family. That's why we provide our employees with more ways to achieve their potential. Partners HealthCare is committed to aligning our employees' personal aspirations with projects that match their capabilities and creating a culture that empowers our managers to become trusted mentors. We support each member of our team to own their personal development-and we recognize success at every step.

Our employees use the Partners HealthCare values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.

General Summary/Overview Statement:

The Research Patient Data Registry (RPDR) is a centralized clinical data registry designed for facilitating research across the Partners HealthCare enterprise. Our team is focused on the consolidation of data from a variety of hospital systems into an organized format that can be easily queried by investigators from across the organization. We provide tools to search this data as well as process workflows for the dissemination of clinical data for IRB approved studies. Our repository contains over 3 billion individual data points on over 7 million patients. Our team handles over 30,000 query requests from over 1500 researchers annually, including the creation and delivery of over 3000 identified data sets. The total value of grants that depend on data delivered from the RPDR for their associated research projects is estimated to be over $1 billion.

Under the direction of the Senior Manager of Operations, we are looking for an Associate Applications Analyst to be a key member of the RPDR (Research Patient Data Registry) team. We are looking for a self-motivated, qualified individual who demonstrates great attention to detail and can work as part of a small, but very efficient group of analysts, developers, and research-based teams.

The incumbent's primary responsibilities will focus on analytical support for multiple complex projects within Partners clinical systems that are being integrated into the RPDR data warehouse. S/he would participate in the design, development, testing, implementation, and on-going support and maintenance of new and existing clinical interfaces. The ideal candidate will possess the ability to understand and document source functionality and data points, system dependencies, and integration requirements. This role will be interacting with analytical, development, and operational team members across the team and organization.

Principal Duties and Responsibilities:

The candidate should have prior experience working with clinical data, reading specifications, understanding of processes, and should have an understanding of healthcare data delivery. This position requires knowledge of healthcare data, databases, SQL, as well as experience in ETL development and testing.

Additional requirements:

* Develop project scope, objectives, specifications, and critical path actions; plans project life-cycle deliverables, and timetables; participates in the exploration, evaluation, and design of technical solutions.
* Perform in-depth analysis of source data and participate in the development of the ETL process as well as performing data validation and testing processes.
* Ensure completion of all projects in accordance with an established project timeline.
* Coordinate multiple complex tasks to completion independently or with minimal guidance.
* Perform application testing as necessary.
* Collaborate with RPDR technical and operational teams to deploy and validate that the tools are working properly.
* May be responsible for planning and managing new development and support efforts in the query tool and other RPDR products and services.
* May include creating, analyzing, and documenting large and complex health care data sets.
* Troubleshoot, diagnose, and accurately document problems and their probable causes and work closely with developers to identify, test, and implement solutions.
* Use the Partners HealthCare values to govern decisions, actions and behaviors. These values guide how we get our work done: Patients, Affordability, Accountability & Service Commitment, Decisiveness, Innovation & Thoughtful Risk; and how we treat each other: Diversity & Inclusion, Integrity & Respect, Learning, Continuous Improvement & Personal Growth, Teamwork & Collaboration.
* Performs all other duties as required.
* Bachelor's Degree Required.
* 3-5 years of analytical experience working with complex data from enterprise applications.
* Expertise in creating and executing detail-oriented test plans/cases and related documentation.
* Familiarity working with large datasets and relational databases including SQL and Microsoft Access; familiarity with HL7 interfaces.
* Ability to work with developers, data analysts, and key stakeholders to facilitate the ETL process development.
* Understand the flow of data through complex architecture with demonstrated ability to identify issues, hypothesize solutions, and see them through to completion
* Knowledge of hospital and clinical information systems, familiarity with electronic health records is ideal.
* Working knowledge of medical terminology and healthcare/medical concepts; knowledge of standard code sets such as ICD9, ICD10, CPT, SNOMED, LOINC preferred.
* Strong PC skills required, including MS Office suite.
* Strong SQL skills required.

Skills/Abilities/Competencies Required:

* Strong, demonstrable analytical/problem-solving skills and detail-oriented.
* Demonstrated ability to work independently, taking initiative to outline work tasks and deliverables, including prioritizing multiple tasks at the same time.
* Uses rigorous logic and testing methodologies to understand root causes of problems
* Ability to carry out position with quality customer service and serve as an exemplary representative of the RPDR Team.
* Ability to work and thrive in a large complex organization.
* Ability to quickly grasp objectives and align with priorities and opportunities of the research community.
* Excellent verbal and written communication skills.