IS Programmer Analyst I Per Diem BWH Rheumatology

General Summary

The Section of Clinical Sciences in the Division of Rheumatology is seeking a Database Analyst I to work closely with Principal Investigators, database administrators, data managers, and potential collaborators to support the department in collecting, organizing, retrieving, tracking, analyzing data related to a new effort to establish a bioinformatics platform. Responsibilities include organizing and managing databases/data marts, extracting data from a variety of sources, preparing data for analyses, and documenting of all aspects of data warehouses, data marts, and related programs and procedures.

Analyst will write programs using SQL as well as other established programming languages. The position requires the ability to develop an in-depth understanding of our data and data structures as well as the ability to translate specifications into programming logic

Primary Responsibilities

Design, build, test, and maintain efficient, reusable, and reliable SQL Scripts and database designs.

Support all phases of release lifecycle - Analysis, Design, Development, Testing, Deployment, and Support.

Confirms project requirements by studying user requirements; conferring with others on project team.

Works closely with investigators to meet requests in a timely manner.

Develop recording systems assuring that the flow of data is tracked in an accurate and timely fashion.

Develops, maintains, and improves MS Access databases for research projects in consultation with researchers.

Documents all aspects of data management, such as database structure and related data cleaning procedures. Maintains data dictionary and metadata.

Meeting and working closely with other staff members and attending larger study and staff meetings.

Performs other duties as assigned

Qualifications

Qualifications

Bachelor's degree in computer science or related field.

Experience writing and editing complex SQL scripts and stored procedures is essential.

Experience working with MS SQL Server, Excel and ACCESS

Previous experience in research is preferred.

Skills, Abilities, Competencies Required

Must have interpersonal skills to interact effectively with persons of all levels.

SQL programming is required.

Data management skills, including the creation, modification and merging of computerized databases in a variety of studies is required.

Knowledge of medical and analytical terminology.

Willingness to learn new pipelines and methods for data analyses, e.g., natural language processing.

Knowledge of clinical epidemiology and biostatistics.

Must be able to prioritize and organize work responsibilities in order to meet deadlines.

Must possess a great deal of integrity to maintain confidentiality. Must demonstrate accuracy in maintaining data.

Must be able to make independent judgments under general supervision for the above-mentioned job duties and responsibilities.

Knowledge of Python and Java programming language or similar preferred but not required.

Experience with database ETL preferred but not required.

EEO Statement

BWH is an Affirmative Action Employer. By embracing diverse skills, perspectives and ideas, we choose to lead. All qualified applicants will receive consideration for employment without regard to race, color, religious creed, national origin, sex, age, gender identity, disability, sexual orientation, military service, genetic information, and/or other status protected under law. We will ensure that all individuals with a disability are provided a reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment.