Customer Relationship Management Project Administrator II (Remote)

Job Title

Customer Relationship Management Project Administrator II (Remote)

Agency

Texas A&M University - San Antonio

Department

AVP Enrollment Management

Proposed Minimum Salary

Commensurate

Job Location

San Antonio, Texas

Job Type

Staff

Job Description

We are seeking a data-driven professional to support Graduate and Undergraduate Admissions through advanced data analytics, automation, and CRM optimization. This role will help streamline operations, enhance reporting accuracy, and improve decision-making through the Microsoft Power Platform and CRM (i.e. Element451).

The ideal candidate will bridge the gap between CRM management and data analytics. They will help maintain and enhance CRM workflows, ensure accurate data integrations across systems, and design actionable dashboards that support graduate enrollment strategy. This position requires both technical expertise and the ability to translate complex data into clear insights for leadership and staff.

Responsibilities:

• Develop and maintain Power BI dashboards for graduate admissions and enrollment reporting (application trends, admit yields, enrollment outcomes, etc.).

• Use Power Query (M code) for data transformation from SharePoint, SFTP, and CRM exports.

• Automate recurring data processes using Power Automate (daily file transfers, scheduled data refreshes, CRM-to-SharePoint pipelines).

• Collaborate with Graduate Admissions leadership to align CRM setup, data collection, and exports with institutional reporting needs.

• Manage and optimize CRM processes (segment creation, form logic, data field mapping, and exports).

• Work with Institutional Research and ITS to troubleshoot data integrations between CRM, Banner/Argos, and Power BI.

• Document workflows and standard operating procedures in Confluence or shared team resources.

• Assist graduate admissions staff with troubleshooting CRM-related issues and provide training or guidance on CRM processes and data workflows as needed.

Required Education & Experience:

• Bachelor’s degree or higher in related field.

• Two (2) years of related experience in administration in a university setting or business environment.

Preferred Education & Experience:

• Bachelor’s degree in Data Analytics, Information Systems, Computer Science, Business Intelligence, or related field.

• 1–3 years of professional experience in data analytics or CRM administration.

• Experience supporting enrollment or admissions analytics preferred.

• Experience with Element451 preferred.

• Experience with other major CRMs (e.g., Salesforce, Slate, Technolutions, TargetX) also highly valuable.

Knowledge, Skills, and Abilities:

• Power BI: dashboard design, data modeling, DAX measures, and report publishing to Power BI Service.

• Power Query: data cleaning, column transformations, custom functions, and dynamic folder imports.

• Power Automate: automated flows for file movement, email triggers, and SFTP/SharePoint integration.

• Understanding of CRM field mapping, custom exports, and automation triggers.

• Familiarity with Banner/Argos (Oracle) data structures is a plus.

• Proficiency with Python or R for data analysis or automation scripting (Pandas, NumPy, etc.).

• Ability to interpret data trends and communicate insights effectively.

• Strong attention to data integrity and process documentation.

All positions are security-sensitive. Applicants are subject to a criminal history investigation, and employment is contingent upon the institution’s verification of credentials and/or other information required by the institution’s procedures, including the completion of the criminal history check.

Equal Opportunity/Veterans/Disability Employer.