The University of Southern California (USC), founded in 1880, is located in the heart of downtown L.A. and is the largest private employer in the City of Los Angeles. As an employee of USC, you will be a part of a world-class research university and a member of the âTrojan Family,â which is comprised of the faculty, students and staff that make the university what it is.
University Advancement is committed to fostering a diverse, equitable, and inclusive culture in which all advancement staff and our stakeholders have the opportunity to connect, belong, and grow while supporting the University of Southern Californiaâs mission, values, and goals. Â
University Advancement is seeking a Data Analyst to join its team. The Data Analyst will be responsible for developing and maintaining reports in Cognos and other University Advancement applications. The ideal candidate is able to measure and show various KPIs to inform decisions and develop visualizations to support University-wide fundraising efforts. Â
Develop and maintain reports from Salesforce using Cognos, Tableau, and/or other reporting software Â
Contribute to the definition and development of the overall reporting roadmap Â
Translate reporting requirements into reporting models, visualizations, and reports Â
Create data tables from Salesforce CRM for email marketing campaigns Â
Work closely with Senior Programmer/DBA to insure integrity of data tables Â
Flag cases of data inconsistencies so that they may be addressed by the Salesforce team or business owner(s) Â
Respond to ad hoc report requests from schools and units
Performs other related duties as assigned or requested. The university reserves the right to add or change duties at any time.
Bachelorâs degree in computer science, business, or other technical area Â
Expert knowledge of Cognos or similar report developer software Â
2 - 3 years of experience with SQL coding Â
2 years of experience in Tableau or similar tools Â
Database management skills using Microsoft SQL Server, Oracle, Salesforce or other cloud databases Â
Salesforce experience is a plus Â
Practical knowledge of the systems development lifecycle and rapid application development encouraged Â
Strong problem solving and analytical skills Â
Excellent interpersonal and communications skills Â
Required Documents and Additional Information
Resume and cover letter required (may be uploaded as one file). Please do not submit your application without these documents.
USC has excellent benefits, including health benefits for staff & their family with access to the renowned university medical network; eligibility for retirement plans with employer contributions once you meet Program's eligibility; tuition benefits for staff & their family; free professional development online courses; central Los Angeles location with easy access to commuter trains, buses & free tram pick up services; discounts to football, basketball & other campus events.
The University of Southern California values diversity and is committed to equal opportunity in employment. Â
Minimum Education: Bachelorâs degree or equivalent combination of experience and educationÂ Â
Minimum Experience: 2 years
Minimum Education: Master's degree, Combined experience/education as substitute for minimum educationMinimum Experience: 2 years, Combined education/experience as substitute for minimum experienceMinimum Field of Expertise: Biometry, Biostatistics or Statistics; mainframe computer and PC experience; experience with SAS, Epilog, BMDP, GLIM or SPSS.
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.