Programmer Analyst 1

The University of New Mexico; Albuquerque, Northern (NM, KY); Hybrid; USD 31,000 - 43,000; Part time

Job summary

The University of New Mexico Southwest Center for Advancing Clinical & Translational Innovation (SW CACTI) seeks a part-time Programmer Analyst 1 in Albuquerque to support the preparation and delivery of clinical data for research. You will gather data requirements, develop queries, extract and clean data, and ensure privacy protections.

Under supervision, you will collaborate with faculty, staff, students, and informatics teams to translate requests into clear specifications, document

Qualifications

• Experience with relational databases and SQL, including writing, testing, and troubleshooting queries.
• Experience with data cleaning, transformation, validation, management, analysis, or reporting.
• Experience with scripting, statistical, or programming tools such as Python, R, SAS, or comparable technologies.
• Experience with electronic health record data; Oracle Health/Cerner preferred.
• Background in health informatics, clinical care, public health, biomedical research, or related field.
• Knowledge of HIPAA, IRB requirements, protected health information, or secure handling of sensitive data.
• Ability to communicate technical information clearly to non-technical personnel, orally and in writing.
• Strong attention to detail and documentation skills; ability to meet deadlines in a collaborative environment.
• Strong interpersonal and communication skills, flexibility, customer-service orientation, and willingness to seek guidance.

Responsibilities

• Assist with data mining and extraction from clinical databases and EHRs using SQL and BI tools.
• Prepare research datasets by cleaning, transforming, linking, and merging data from multiple sources.
• Apply de-identification methods to protect privacy.
• Perform routine quality assurance of data completeness, validity, reproducibility, and consistency; document findings.
• Meet with faculty and staff to translate study questions into clear specifications and deliverables.
• Maintain documentation of data definitions, query logic, methods, decisions, limitations, and deliverables; use version-control processes.
• Follow HIPAA, IRB, data-use and institutional requirements for access, storage, and transmission of research data.
• Develop familiarity with evolving clinical data resources and informatics procedures; provide team support and training.
• Performs miscellaneous job-related duties as assigned.

Skills

SQL

Data mining

Data extraction

Data cleaning

Data transformation

Data linking

Privacy

Education

Bachelor's degree

Experience related to duties

Tools

Oracle Health/Cerner

Relational Databases

Job description

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.

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

• 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 budgetary constraints, the department is unable to sponsor or take over sponsorship of an employment visa at this time. Applicants must be authorized to work for any employer in the United States.

This position is based in Albuquerque, New Mexico. 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.

Finalists may be asked to submit up to three work samples representing a range of relevant products, such as code samples, technical documentation, data dictionaries, formatted reports, GitHub links, or comparable materials. Applicants may redact confidential or proprietary information.

Health Sciences Center (HSC) - Albuquerque, NM

CTSC Administration Gen (672B)

Staff

Term - Part-Time

06/30/2027

Non-Exempt

Hourly: $22.40 - $31.46

This is a benefits eligible position. The University of New Mexico provides a comprehensive package of benefits including medical, dental, vision, and life insurance. In addition, UNM offers educational benefits through the tuition remission and dependent education programs. See the Benefits home page for more information.

As a condition of employment, eligible employees working greater than .25 FTE as determined by the New Mexico Education Retirement Act must make mandatory retirement contributions. For more information, review the Benefits Eligibility at a Glance grid.

Yes

9/22/2026

Positions posted with a Staff Type of Regular or Term are eligible for the Veteran Preference Program. See the Veteran Preference Program webpage for additional details.

The University of New Mexico is committed to hiring and retaining a diverse workforce. We are an Equal Opportunity Employer, making decisionswithout regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, veteran status, disability, or anyother protected class.

The University of New Mexico requires all regular staff positions successfully pass a pre-employment background check. This may include, but is not limited to, a criminal history background check, New Mexico Department of Health fingerprint screening, New Mexico Children, Youth, and Families Department fingerprint screening, verification of education credentials, and/or verification of prior employment. For more information about background checks, visit https://policy.unm.edu/university-policies/3000/3280.html. Refer to https://policy.unm.edu/university-policies/3000/3200.html for a definition of Regular Staff.