Pro Bono Analytics Specialist

Cooley is seeking a Pro Bono Analytics Specialist to join the Pro Bono team.

Position summary: Under the direction of the Pro Bono Partner/Head of Social Impact and Sustainability, this role will oversee and analyze a broad array of quantitative and qualitative pro bono and social impact data assets to compile analyses and develop reports to manage the pro bono practice, answer client requests, make broad business impact and shape pro bono and social impact strategy.  Specific duties and responsibilities include, but are not limited to, the following:

Position 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

Skills and experience:

Required:

• 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). Senior candidates considered with 4+ years' experience with proven ability to operate at an elevated level.
• 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

Preferred:

• 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

Competencies:

• Demonstrate effectiveness using data to tell a story and translate data into reports, tables, graphs, charts, and presentations
• Passion for pro bono and social impact efforts
• Detail-oriented, organized and process driven
• Strong time management skills with the ability to prioritize tasks and coordinate multiple projects at once in a fast-paced environment
• Excellent interpersonal skills with the ability to maintain absolute confidentiality of department information
• Self-motivated and self-starter, looks for growth opportunities, takes leadership to develop solutions when answers are not readily apparent
• Enjoy working with a highly collaborative team
• Ability to handle sensitive data and confidential materials, demonstrating discretion and the ability to maintain confidentiality, as required
• Strong verbal and written communication skills
• Ability to organize, prioritize and coordinate multiple activities
• Strong judgment
• Team-player with collaborative spirit
• High level of professionalism at all times

Cooley offers a competitive compensation and excellent benefits package and is committed to fair and equitable employment practices. EOE.

The expected hourly pay range for this position with a work schedule of 40 hours per week is $39.50 - $58.00 ($82,160.00 - $120,640.00 annually). Please note that final offer amount will be dependent on geographic location, applicable experience and skillset of the candidate.

We offer a full range of elective benefits including 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 and other parental support benefits. In addition to elective benefit options, benefited employees receive firm-paid life insurance, AD&D, LTD, short term medical benefits as well as 20 days of Paid Time Off (“PTO”) and 10 paid holidays each year. We provide generous parental leave and fertility benefits. New employees will attend a detailed benefit orientation to learn more about our many benefits and resources.