Scheduled Hours
37.5
Position Summary
The Senior CRM Analyst serves as a vital technical marketing leader for the CRM Ecosystem and the CRM Team. The Senior CRM Analyst applies a solution design approach that demonstrates This position sits within the CRM Team in the Strategic Insights department and is a vital forward-looking role for the Olin Business School. This is a senior level position responsible for collecting, analyzing, interpreting, communicating and automating delivery of data requirements for various departments within Olin Business School. The Senior Reporting and CRM Analyst is responsible for working with business departments to gather and understand data requirements, provide impactful insight and deliver innovative solutions to enhance business department decision making. This role is responsible for analyzing organizational processes, converting those processes to business workflows--driving school adoption of the CRM Platform. This role is a technical expert to all departments and areas to create, customize and improve the CRM platform. The role will be working alongside other analysts across the university and within the school to provide performance and strategic insight for Olin Business School leadership.
Job Description
Primary Duties & Responsibilities:
Reporting and Data Analysis
- Develop and maintain automated reporting solutions for school leadership.
- Lead conversations with internal customers to understand data and report requirements and recommend solutions.
- Understand all data sources including Olin CRM (Salesforce database and WashU Warehouse and how to integrate to build impactful reports.
- Construct automated dashboards to track Key Performance Indicators (KPIs) aligned with school strategic initiatives supporting multiple departments.
- Translate the data to easily understood stories. Convert complex data findings into audience tailored summaries, tables, graphs, and data visualizations.
- Prepare reports and presentations to communicate findings and recommendations to internal customers and leaders.
- Identify opportunities to use data to develop new strategies and improve business performance.
- Stay updated on industry trends and best practices in reporting and data analysis to enhance reporting.
- Organize and analyze data to identify trends and elevate insights related to building and enhancing connection with target audiences for school priorities.
- Conduct data analysis in support of a variety of different projects across multiple departments and multiple audiences.
- Provide actionable insight—findings are ready to package in summaries and story format.
- Create and produce forecasts, year-over-year comparisons, and analyze progress against targets.
- Support quick-turnaround ad hoc reporting requests.
Operational Activities
- Manage day-to-day administration of Salesforce and related integrated third-party tools including, but not limited to, Nintex, Accredible, FormAssembly, Workday, and Canvas.
- Facilitate system administration and help streamline business functionality including profiles/permissions, role hierarchy, security models, application customization, reports, and dashboards, etc.
- Create automation based on Flows, Process Builders, and Workflows, in support of high configuration (declarative), low coding (programmatic) standards.
- Maintain, evaluate, and advise on selection of 3rd party technologies to improve productivity and quality of systems.
- Manage API development, testing and support into WashU and Olin platforms including Workday, Canvas, and WashU data warehouse platforms.
- Develop reusable templates and maintain Business Systems Analyst methodology.
Data Management and Quality
- Plan and manage data acquisition, evaluation, and submission for multiple reporting destinations.
- Document data acquisition, hygiene, and reporting processes, procedures, and decisions.
- Extract, clean, maintain, manipulate, and share institutional data.
- Identify and define data quality improvements.
- Ensure compliance with data privacy and security.
- Demonstrate alignment with reporting requirements by performing data quality audits and analysis.
- Be aware of how data is collected and stored in university central data systems and how it maps to report requirements.
Perform other duties as assigned.
Working Conditions:
Job Location/Working Conditions
Physical Effort
Equipment
The above statements are intended to describe the general nature and level of work performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all job duties performed by the personnel so classified. Management reserves the right to revise or amend duties at any time.
Required Qualifications
Education:
Bachelor's degree
Certifications:
The list below may include all acceptable certifications and issuers. More than one credential or certification may be required depending on the role.Salesforce Administrator - Salesforce
Work Experience:
Salesforce Business Or Database Analyst, With Hands On Configuration Experience. (5 Years), Experience Using Databases Or Other Electronic Systems For Tracking, Reportiong And Managing Information. (5 Years)
Skills:
Not Applicable
Driver's License:
A driver's license is not required for this position.
More About This Job
Preferred Qualifications:
- Three years or more of experience with marketing analytics tools, such as Salesforce or other CRM systems, Google Analytics, and social media analytics platforms.
- Three years or more of experience with business intelligence and reporting platforms (Cognos, Power BI, Tableau).
- Experience using databases and data warehouses.
- Knowledge of best practices in data management, data hygiene, and overall data quality processes.
- Advanced Microsoft Excel skills, including pivot tables, macros and vlookups.
- Salesforce certification.
- SQL and Python experience.
- Higher education experience.
Preferred Qualifications
Education:
No additional education beyond what is stated in the Required Qualifications section.
Certifications:
No additional certification beyond what is stated in the Required Qualifications section.
Work Experience:
No additional work experience beyond what is stated in the Required Qualifications section.
Skills:
Adaptability, Analytical Thinking, Customer Service, Detail-Oriented, Employee Relationship Management, Hyper Text Markup Language (HTML), IBM Cognos Business Intelligence, Interpersonal Communication, Microsoft SharePoint, Microsoft SQL Server, Oral Communications, Project Administration, Stress Management, Tableau (Software), Teamwork, Written Communication
Grade
G13
Salary Range
$65,900.00 - $112,700.00 / AnnuallyThe salary range reflects base salaries paid for positions in a given job grade across the University. Individual rates within the range will be determined by factors including one's qualifications and performance, equity with others in the department, market rates for positions within the same grade and department budget.
Questions
For frequently asked questions about the application process, please refer to our External Applicant FAQ.
Accommodation
If you are unable to use our online application system and would like an accommodation, please emailCandidateQuestions@wustl.eduor call the dedicated accommodation inquiry number at 314-935-1149 and leave a voicemail with the nature of your request.
All qualified individuals must be able to perform the essential functions of the position satisfactorily and, if requested, reasonable accommodations will be made to enable employees with disabilities to perform the essential functions of their job, absent undue hardship.
Pre-Employment Screening
All external candidates receiving an offer for employment will be required to submit to pre-employment screening for this position. The screenings will include criminal background check and, as applicable for the position, other background checks, drug screen, an employment and education or licensure/certification verification, physical examination, certain vaccinations and/or governmental registry checks. All offers are contingent upon successful completion of required screening.
Benefits Statement
Personal
Up to 22 days of vacation, 10 recognized holidays, and sick time.
Competitive health insurance packages with priority appointments and lower copays/coinsurance.
Take advantage of our free Metro transit U-Pass for eligible employees.
WashU provides eligible employees with a defined contribution (403(b)) Retirement Savings Plan, which combines employee contributions and university contributions starting at 7%.
Wellness
Wellness challenges, annual health screenings, mental health resources, mindfulness programs and courses, employee assistance program (EAP), financial resources, access to dietitians, and more!
Family
We offer 4 weeks of caregiver leave to bond with your new child. Family care resources are also available for your continued childcare needs. Need adult care? We’ve got you covered.
WashU covers the cost of tuition for you and your family, including dependent undergraduate-level college tuition up to 100% at WashU and 40% elsewhere after seven years with us.
For policies, detailed benefits, and eligibility, please visit: https://hr.wustl.edu/benefits/
EEO Statement
Washington University in St. Louis is committed to the principles and practices of equal employment opportunity and especially encourages applications by those from underrepresented groups. It is the University’s policy to provide equal opportunity and access to persons in all job titles without regard to race, ethnicity, color, national origin, age, religion, sex, sexual orientation, gender identity or expression, disability, protected veteran status, or genetic information.Washington University is dedicated to building a community of individuals who are committed to contributing to an inclusive environment – fostering respect for all and welcoming individuals from diverse backgrounds, experiences and perspectives. Individuals with a commitment to these values are encouraged to apply.
