Vacancy expired!
Position InformationTitle of Position
CRM Data AnalystRequisition Number
BES20190728PDepartment Posting Name
ENROLLMENT SRVCS MKT & COMMLocation
Main CampusRecruitment Type
ExternalPosition Type
This is a Classified, benefits eligible, position.Grant Funded?
NoHours per week
40If employee will be working a schedule other than Monday - Friday, 8:00am - 5:00pm, specify hours and days to be workedOccasional evenings and weekends.If Temporary, Ending DateRecruiting Rate
$39,703-$45,507 annualized (salary negotiable depending on qualifications)Beginning Salary Flexibility
YesPay Basis
SalaryRequired Education
Bachelor's DegreeDo you want to allow additional experience to substitute for required education?
Yes (2 Years Experience = 1 Year Education)Preferred EducationField of StudyMS Office Experience Required
Word, Excel, PowerPoint, OutlookWill this position require driving a UT or personally owned vehicle?
NoOther Computer and Software Skills RequiredPersonal computer and Mac, Microsoft Office Suite and Adobe Creative Suite.Experience and Other Skills RequiredThree years of experience in the area of data imports, data cleansing, data integrity, data architecture, or systems analysis.Skill working with data, data imports and data cleansing.Skill in writing queries, reports and technical documentation.Skill in testing applications.Demonstrated problem-solving and technical trouble-shooting skills combined with a strong work-ethic and the ability to learn.Ability to communicate effectively verbally and in writing.Criminal Background Check (CBC).Do you want to allow additional education to substitute for required experience?
NoOther Skills PreferredThorough knowledge of higher education policies and procedures within the enrollment field.Experience using SQL tools.Experience working in a Customer Relationship Management (CRM) system such as Salesforce CRM.Description of Job DutiesThe scope of this position is to perform highly complex data management tasks, including data conversion, de-duplication, data migration, and identification and repair of data quality issues within the university CRM platform.Assist departments with batch data importing of physical and digital data and assist in the development of the data import process into the CRM platform. This is to include the following:
a. Verify that data files are correct in format and quality before importing.
b. Importing data from various data loader tools into the CRM platform.
c. Importing data on a daily, weekly, and ad-hoc schedule (dependent on data source)
d. Scheduling for data relay that is optimal for assisted departmentsIdentify and reconcile routine and complex data input discrepancies and assist in the continual development of the data cleaning process. This is to include the following:
a. Mass profile de-duplication
b. Mass deletion of file upload records
c. Ad-hoc mass updates or deletion of records
d. Ad-hoc profile de-duplication via submitted support tickets
e. Monitor tables within the Student Information Systems in conjunction with CRM system tables, in order to note any data discrepancies caused by data integration.Produce routine and specialized reports. Disseminates reports according to established procedures and uses business intelligence and data analytics techniques to respond to, coordinate and execute information requests.Assist with the data needs for the contact center platform (dialer technology) and daily review the dialer call lists that are needed.Works with the CRM applications administrator and with our University Technology Solutions in regard to the following:
a. Testing new field integrations into the CRM platform
b. Record updates that may have been transmitted incorrectly
c. Provide resolution to integration errors caused by org settings
d. Provide insight into CRM-side manipulation of integrated data
e. Troubleshoot and report the issue for collaborative resolution.Create and maintain functional and technical documentation related to the Data Import Process, Data Cleaning Process, and Data Reporting Process. Maintain expert knowledge in the required standard tools and data frameworksTroubleshoots, analyzes problems, and resolution for data related issues. Conduct testing within the testing environment, prior to implanting changes in production. Test for errors within the CRM platform, and provide potential paths to resolution.Assist users in general best-practice use within the CRM platform and respond to requests for support and training on relevant applications and to troubleshoot applications problemsMaintain security at the highest level by ensuring that security standards and protocols are recognized and followed. Collaborate with fellow infrastructure teams to develop, test and ensure implementation of security best practices and policies.Perform other duties as assigned.Posting Open Date
11/25/2019Posting Close Date at midnight on
01/06/2020Open Until Filled
NoSpecial Notes To Applicants-UTSA is a tobacco-free campus.-UTSA is an Equal Employment Opportunity/Affirmative Action Employer. Minorities, women, veterans, and individuals with disabilities are encouraged to apply.-This is a security sensitive position. Employment is contingent upon a successful background check.-Applicants who are selected for interviews must be able to show proof that they are eligible and qualified to work in the United States by time of hire.-At the discretion of the hiring department, this position posting may be closed once a sufficient number of qualified applications has been received.
Vacancy expired!