Programmer Analyst 1

The University of New Mexico•Albuquerque, NM

1d•Onsite

About The Position

The University of New Mexico Southwest Center for Advancing Clinical & Translational Innovation (SW CACTI), located within the Health Sciences Center, is seeking a part-time Programmer Analyst 1 to support the preparation and delivery of clinical data for research. Working under the direct supervision of senior technical staff, the Programmer Analyst 1 will assist with gathering data-request requirements; developing and maintaining routine to moderately complex queries and scripts; extracting, cleaning, linking, validating, and documenting datasets; and applying established safeguards for data security and patient privacy. The position will collaborate with faculty, staff, students, and Informatics team members to support clear, actionable, and compliant research data requests. SW CACTI is part of the national Clinical and Translational Science Awards (CTSA) consortium, funded by the National Center for Advancing Translational Sciences, National Institutes of Health. Translational science supports the movement of discoveries from laboratory and clinical research into health systems and communities.

Requirements

Bachelor's degree; at least 6 months of progressively responsible experience directly related to the duties and responsibilities specified.
Completed degree(s) from an accredited institution and/or experience that is directly related to the duties and responsibilities specified may be interchangeable on a year-for-year basis.
Applicants must be authorized to work for any employer in the United States.
The anticipated schedule is 20 hours per week and will be established with the supervisor based on operational needs and candidate availability.
Candidates who are not local must be willing to relocate at their own expense if required for the approved work arrangement.

Nice To Haves

Experience and proficiency with relational databases and SQL, including writing, testing, and troubleshooting queries.
Experience with data cleaning, transformation, validation, management, analysis, or reporting.
Experience with one or more scripting, statistical, or programming tools such as Python, R, SAS, or comparable technologies.
Experience with electronic health record data; experience with Oracle Health/Cerner is preferred.
Education, training, knowledge or experience in health informatics, clinical care, public health, biomedical research, or a related field.
Familiarity, knowledge or experience with HIPAA, IRB requirements, protected health information, or secure handling of sensitive data.
Ability to communicate technical information clearly to non-technical personnel, both orally and in writing.
Strong attention to detail and demonstrated ability to document work, follow established procedures, organize priorities, and meet deadlines in a collaborative environment.
Strong interpersonal and communication skills, flexibility, customer-service orientation, and willingness to seek guidance and incorporate technical review.

Responsibilities

Assist with data mining and extraction from clinical databases and electronic health records (EHRs) using SQL, business intelligence tools, and other approved technologies.
Prepare research datasets by cleaning, transforming, linking, combining, and merging data from multiple sources in accordance with established specifications and procedures.
Apply established de-identification methods, which may include removal of direct identifiers, date shifting, randomization, and other approved privacy-preserving techniques.
Perform routine quality assurance to evaluate data completeness, validity, reproducibility, and consistency; document findings and escalate complex issues for senior technical review.
Meet with faculty, staff, and students to gather information about study questions and data needs; assist with translating requests into clear specifications, deliverables, and documented work requirements.
Maintain clear documentation of data definitions, query logic, methods, decisions, limitations, and final deliverables; contribute to established request-tracking and version-control processes.
Follow HIPAA, Institutional Review Board (IRB), data-use, and institutional requirements governing the access, storage, transmission, and use of clinical and research data.
Develop familiarity with evolving clinical data resources, medical concepts, and informatics procedures through guided training, collaboration, and professional development; provide team coverage and operational support within the assigned schedule; and, participate in relevant meetings and training.
Performs miscellaneous job-related duties as assigned.