Programmer Analyst

Programmer Analyst 1

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.

Duties and 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 elevate 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.
• Perform miscellaneous job-related duties as assigned.

TERM APPOINTMENT; FUNDING AVAILABLE THROUGH 06/30/2027; CONTINUANCE BEYOND THAT DATE SUBJECT TO AVAILABILITY OF ADDITIONAL FUNDING. The CTSC has received continuous funding for over two decades.

See the Position Description for additional information.

Staff

Term - Part-Time

06/30/2027

Non-Exempt

Hourly: $22.40 - $31.46

Health Sciences Center (HSC) - Albuquerque, NM

CTSC Administration Gen (672B)

12

• Specialty licensure/certification may be required, as specified by the department.
• Successful candidate may be subject to a criminal background check prior to starting work.

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.

• 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.

• Due to…