Programmer Analyst 1

University of New Mexico; Albuquerque (NM); On-site; USD 30,000 - 43,000; Part time

Job summary

University of New Mexico is seeking a part-time Programmer Analyst 1 to support clinical data preparation for research at the Health Sciences Center in Albuquerque. The role involves gathering data needs, developing queries, and ensuring data privacy and security.

Under supervision, you will extract and clean data from multiple sources, document data definitions and procedures, and collaborate with researchers and informatics staff to fulfill data requests.

Qualifications

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

Responsibilities

• Assist with data mining and extraction from clinical databases and EHRs using SQL, BI 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 de-identification methods to protect privacy.
• Perform routine quality assurance to evaluate data completeness, validity, reproducibility, and consistency; document findings and elevate complex issues.
• Meet with faculty, staff, and students to gather study questions and data needs; translate requests into clear specifications, deliverables, and documented work requirements.
• Maintain documentation of data definitions, query logic, methods, decisions, limitations, and deliverables; contribute to request-tracking and version-control processes.
• Follow HIPAA, IRB, data-use and institutional requirements governing access, storage, transmission, and use of clinical and research data.
• Develop familiarity with evolving clinical data resources and informatics procedures; provide team support within the assigned schedule; participate in meetings and training.
• Perform miscellaneous job-related duties as assigned.

Skills

SQL

Data cleaning

Python

HIPAA

Communication

Team collaboration

Education

Bachelor's degree

Tools

Oracle Health/Cerner

BI tools

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.

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.

Employment Type

Staff

Staff Type

Term - Part-Time

Term End Date

06/30/2027

Status

Non-Exempt

Pay

Hourly: $22.40 - $31.46

Campus

Health Sciences Center (HSC) - Albuquerque, NM

Department

CTSC Administration Gen (672B)

Position Grade

12

Conditions of Employment

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

Minimum Qualifications

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.

Preferred Qualifications

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

Additional Requirements

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

Benefits Eligibility

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 a more information.

ERB Statement

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.

Background Check Required

Yes

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 decisions without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, veteran status, disability, or any other 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.