Description
Position summary
The Alumni Relations Operations & Data Analyst supports the firm's Alumni Relations function by maintaining, analyzing, and reporting on alumni data across multiple systems. This role is responsible for data quality, research, dashboard development, and standard reporting, and supports Alumni Relations programs and firmwide initiatives by analyzing alumni engagement, communications, and employment data and preparing related reports and materials. The Analyst works with Alumni Relations and firmwide teams that support data and related systems to ensure consistency of data definitions, alignment across systems, and effective use of alumni data.
Job duties and responsibilities
- Serve as primary technical liaison for the firm's external website vendor (Aluminati): attend weekly working sessions, track sync health, triage and resolve data errors, document workflows and decisions, and drive a backlog of enhancements.
- Use independent judgment and discretion to monitor and validate data and content feeds from the firm's website to the alumni website, ensuring updates are posted timely and new features are reflected as released; make routine updates where appropriate and coordinate with vendors or other teams for more complex changes.
- Proactively monitor and troubleshoot alumni website membership and user experience to identify functionality issues and sources of incorrect data, resolving issues independently where appropriate or coordinating with the website vendor as needed.
- Coordinate alumni connections and membership within the LinkedIn alumni group and the Alumni Network external website.
- Utilize platform configuration and “build” capabilities to implement customizations updates; apply light HTML/CSS where appropriate to optimize data capture and presentation.
- Monitor and report on user and content engagement (Insights) for the external website; recommend UX optimizations based on observed behaviors.
- Develop and maintain familiarity with the firm's alumni data population and categories, and adhere to applicable consent, eligibility, and other guidelines for communication.
- Maintain, cleanse, and enrich alumni data across multiple systems and sources, ensuring accuracy, completeness, and consistency of contact, employment, location, and affiliation data; review and remediate data quality issues, including formatting inconsistencies, incomplete fields, and duplicate records; and perform regular data quality checks, audits, and reconciliations.
- Use independent judgment to conduct targeted research using internal systems and external sources to support business development and retention initiatives and to validate and update alumni records, documenting sources and changes in accordance with firm guidelines and applicable privacy standards.
- Partner with firmwide administrative, operational, and data teams—including more senior Alumni Relations data roles as applicable—to obtain data segmentations, align data definitions, ensure consistency across systems, resolve cross-functional data issues, support forward-looking analytics, and operationalize data insights.
- Coordinate the vendor relationship with external vendors to support delegated data processing activities and review vendor outputs to ensure accuracy and adherence to defined data standards.
- Generate targeted invitation and outreach lists based on defined criteria and segmentation logic; verify list accuracy and readiness for use in campaigns and reporting.
- Prepare and deliver clear, concise outputs for program and leadership teams, including progress updates, ad hoc data requests, and leadership-ready materials; translate complex data into accessible narratives, charts, and infographics, ensuring accuracy and timeliness.
- Analyze trends related to alumni milestones, including participation, employment, education, and related indicators; synthesize findings into clear, actionable recommendations.
- Maintain dashboards and standard reports tracking alumni engagement, event participation, communication preferences, employment trends, and other key metrics.
- Perform other duties as assigned.
Job duties and responsibilities included are not exhaustive and may be supplemented as necessary. Reed Smith reserves the right to revise or modify job duties and responsibilities at any time.
Requirements
Requirements
Education: Bachelor's degree in Data Analytics, Statistics, Economics, Social Sciences, Computer Science, or a related field.
Experience: Minimum of five (5) years of experience in data analysis, reporting or related analytical roles.
Prior experience working with CRM platforms or other database collection systems.
Experience with Salesforce preferred.
Experience utilizing social media platforms as data sources and research tools.
Advanced Excel capabilities (e.g. PowerQuery) preferred.
Experience with data visualization and presentation tools (e.g., PowerPoint, Power BI or similar platforms).
Experience managing or supporting a community-based website or platform, including content maintenance, member engagement support, and coordination with internal stakeholders.
Skills:
Ability to proactively navigate various programs and resources.
Ability to work independently, including in a remote or hybrid work environment without direct oversight.
Strong Excel skills.
Strong interpersonal skills and the ability to communicate effectively with all organizational levels, both verbally and in writing.
Skilled in translating complex technical concepts into clear, understandable language for non-technical audiences.
Strong research and critical thinking skills, including the application of logical reasoning, analysis, and evaluation to make informed decisions and sound judgments.
Strong attention to detail with a commitment to accuracy and quality.
Highly organized and self-directed, with the ability to manage multiple priorities and competing deadlines.
Other
Supervisory responsibilities: None
Equipment to be used: Personal computer and other office equipment such as telephone, calculator, copier, scanner, etc.
Essential job functions:
Ability to sit or stand for extended periods and perform tasks requiring prolonged and/or extensive computer use.
Ability to use computers, telecommunications, and digital collaboration tools to perform core job responsibilities.
Ability to engage in effective and professional communication.
Ability to analyze complex information, maintain attention to detail, manage multiple priorities, and exercise sound judgment.
Ability to access, use, and safeguard confidential and sensitive information while performing job responsibilities in work environments that support confidentiality, privacy, and information security requirements.
Ability to work extended hours and in the office as required to meet business client or project needs.
Working conditions: Works remotely. Occasionally called upon to work hours in excess of your normal daily schedule. Potential for in-office work requests as needed, so proximity to the office is important.
Pay range
This position is non-exempt. The hourly wage range for this role is outlined below, with corresponding estimated annual compensation based on standard weekly hours:
Pittsburgh, Richmond, Texas, Denver, Atlanta: $35.58 - $39.42 per hour (40-hour workweek; approximately $74,000 - $82,000 annually)
Miami: $37.95 - $42.05 per hour (37.5-hour workweek; approximately $74,000 - $82,000 annually)
Philadelphia, Wilmington: $37.98 - $42.31 per hour (40-hour workweek; approximately $79,000 - $88,000 annually)
Chicago: $43.41 - $48.35 per hour (35-hour workweek; approximately $79,000 - $88,000 annually)
This represents the presently anticipated low and high end of Reed Smith's pay range for this position. Actual pay may vary based on various factors, including but not limited to location and experience.
Employee benefits overview
Reed Smith offers a comprehensive benefits package designed to support the well-being and financial security of our employees. Benefits include:
401(k) retirement savings plan
Medical, dental, and vision insurance
Health savings account (HSA)
Flexible spending accounts (FSA)
Virtual health services
Life insurance
Short-term disability (STD)
Long-term disability (LTD)
Accident insurance
Hospital indemnity insurance
Critical illness insurance
Paid family leave (eligibility varies)
Paid time off (PTO) for all full-time, non-temporary employees
Paid sick time
Employee assistance program through Lyra Health
Transportation benefits
Back-up child care
College Coach program
Pet insurance
Equal opportunity statement
Reed Smith is an equal opportunity employer. We are committed to providing equal employment opportunities to all individuals regardless of race, color, religion, sex, gender identity or expression, sexual orientation, national origin, age, disability, veteran status, or any other characteristic protected by applicable law.
We are also committed to providing reasonable accommodations for qualified individuals with disabilities and for sincerely held religious beliefs, in accordance with applicable law.
