Customer Relationship Management Project Administrator II (Remote)

Texas A&M•San Antonio, TX

12d•Remote

About The Position

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.

Requirements

Bachelor’s degree or higher in related field.
Two (2) years of related experience in administration in a university setting or business environment.
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.
Strong attention to data integrity and process documentation.

Nice To Haves

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

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.