The Enrollment Services Office of Communications and Data & Mail is seeking a Data Management Specialist to join our team. This role creates and maintains databases, while engaging in data collection of requested formats. The Data Management Specialist runs statistical analysis programs, generates charts and graphs. This position provides the data that is used in the sending of 200+ email campaigns and 60+ mail campaigns each year.
Over the last year, there has been an increase in the number of communications sent to prospective and admitted students and families, including an increase in the requests received from the President and Provostâs Offices as well as the Student Healthâs Office. These communications require a person who is knowledgeable in the building of data queries. This position is integral in the communications for Undergraduate and Graduate Admission, Academic Records and Registrar, Financial Aid and Orientation programs. They are also key in assisting the Provost Office with updating the parent database for continuing students. Responsibilities include, but are not limited to the following:
Data queries and reports that are related to the recruitment, admission and conversion of students.
Data reports that are related to the recruitment of graduate students, including I-20 support for international students.
Management of data that is used for the marketing and informational campaigns .
The selected candidate will be expected to:
Leverage Slate software technologies to build slate instance/queries for various mail and email campaigns that are sent to prospective and admitted students and their parents.
Create an access database that is used for admission packet tracking purposes.
Use SIS as a super user to extract undergraduate and graduate reports and datasets. These reports are used for marketing and recruitment to prospective, admitted and current students.
Create AdHoc reports for admission related data queries used by departments throughout the university using SQL and Slate.
Providing reports to the Provost Office to maintain the current student parent database.
Create and maintain reports for USCâs International Offices to ensure their ability to communicate with prospective and admitted students.
Use of PE (person entity) to build views in Oracle SQL to connect data to Campaign Enterprise.
Be Proficient in Microsoft Office tools and applications.
Have demonstrated experience with ODBC data querying tools such as MYSQL, SQL, etc.
Experience using one or more of the following: Tableau, IBM Cognos, IBM Cognos TM1, etc.
In alignment with university services, this position ensures proper data integrity that permit the successful launch of all communications campaigns, including direct mail, outreach, community relations, safety concerns, marketing and conversion events.
Please submit cover letter and resume as part of your application.
Job QualificationsMinimum Education: Related undergraduate study, Combined experience/education as substitute for minimum educationMinimum Experience: 1 year, Combined education/experience as substitute for minimum experienceMinimum Field of Expertise: Working knowledge of personal computer software including database, spreadsheet, graphics and desktop publishing programs.Preferred Education: Bachelor's DegreePreferred Experience: 2 Years
USC is the leading private research university in Los Angeles—a global center for arts, technology and international business. With more than 47,500 students, we are located primarily in Los Angeles but also in various US and global satellite locations. As the largest private employer in Los Angeles, responsible for $8 billion annually in economic activity in the region, we offer the opportunity to work in a dynamic and diverse environment, in careers that span a broad spectrum of talents and skills across a variety of academic and professional schools and administrative units. As a USC employee and member of the Trojan Family—the faculty, staff, students, and alumni who make USC a great place to work—you will enjoy excellent benefits, including a variety of well-being programs designed to help individuals achieve work-life balance.