Pro Bono Analytics Specialist

Cooley LLP • Los Angeles, CA

1d

About The Position

Under the direction of the Pro Bono Partner/Head of Social Impact and Sustainability, the Pro Bono Analytics Specialist will oversee and analyze a broad array of quantitative and qualitative pro bono and social impact data assets. This role is crucial for compiling analyses and developing reports to effectively manage the pro bono practice, respond to client requests, make significant business impact, and strategically shape the firm's pro bono and social impact initiatives.

Requirements

• After orientation at Cooley LLP, exhibit proficiency in the Microsoft Office suite, iManage and other firm applications
• Available to work overtime, as required
• 3+ years direct applicable experience (e.g., working in a data management and analysis role and developing summary reports and presentations)
• Advanced background in Excel experience building and maintaining spreadsheets, utilizing pivot tables and advanced formulas, identifying and tracking trends over time and other key metrics as needed
• Advanced background in Powerpoint and demonstrated ability to present data sets and analysis to a range of audiences in clean and compelling format
• Advanced background in Power BI including importing data from multiple assets
• Experience performing quantitative and comparative data validation and analytics
• Ability to communicate takeaways, methodologies, and assumptions for data analysis
• Experience with reporting and query tools (i.e., Sharepoint, Tableau, Business Objects, etc.), databases and data management

Nice To Haves

• Bachelor’s degree
• Law firm or professional services industry experience
• Workday reporting experience
• Salesforce CRM experience
• Adept in writing database queries (i.e., SQL, MySQL, PL/SQL, T-SQL) using SQL Developer, etc. and programming (VBA, C#, Python, Javascript or ETL frameworks)
• Ability to merge and synthesize data from multiple sources into unified reports and presentations

Responsibilities

• Maintain key data assets related to pro bono and social impact data
• Produce regular reports, infographics, and presentations involving pro bono and social impact data
• Lead processing and completing pro bono and social impact data requests, questionnaires and reports from both internal and external stakeholders
• Develop new reports and infographics that will enhance management of the practice
• Work with accounting and other firm departments to address data questions and inconsistencies
• Serve as the department point person and liaise with the marketing department to complete all pro bono & SIS data components of client-issued requests and RFPs
• Collaborate with marketing department on data collection and reporting for external certifications and surveys
• Utilize benchmarking tools to monitor Cooley’s progress
• Proactively build relationships with different stakeholders across the firm
• All other duties as assigned or required

Benefits

• Competitive compensation
• Excellent benefits package
• Medical
• Health savings account (with applicable medical plan)
• Dental
• Vision
• Health and/or dependent care flexible spending accounts
• Pre-tax commuter benefits
• Life insurance
• AD&D
• Long-term care coverage
• Backup care for children and/or adults
• Other parental support benefits
• Firm-paid life insurance
• Firm-paid AD&D
• Firm-paid LTD
• Short term medical benefits
• 20 days of Paid Time Off (“PTO”)
• 10 paid holidays each year
• Generous parental leave
• Fertility benefits
• Tools, training and mentoring
• Ability to balance work and family obligations
• Community involvement

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 501-1,000 employees