Data & Systems Specialist

Public Counsel • Los Angeles, CA

14d • Hybrid

About The Position

The Data, Systems & Innovation team is an emerging team that strengthens how Public Counsel manages and uses data and technology. Combining strategic leadership with hands-on support, it oversees data governance, quality, privacy, and reporting; manages LegalServer and related systems; and leads systems development, integration, automation, and process improvement. The team provides staff training and user support while exploring responsible use of emerging technologies, including artificial intelligence. By partnering across teams, it supports grant compliance, informed decision-making, and effective service delivery to advance Public Counsel’s access-to-justice mission.

Reporting to the Director of Data, Systems & Innovation, the Data & Systems Specialist will play a key role in ensuring the accuracy, reliability, security, and effective use of organizational data and systems that support legal services, advocacy, compliance, grant reporting, and operational effectiveness.

Requirements

• Bachelor's degree or equivalent combination of education and experience
• 1-3 years of experience in data management, reporting, business intelligence, systems administration, technology support, nonprofit operations, legal services, or related fields
• Experience with databases, case management systems, CRM platforms, or enterprise applications preferred
• Experience with Microsoft Excel and Power BI strongly preferred
• Experience with LegalServer or similar case management systems is a plus
• Strong attention to detail and commitment to data accuracy
• Excellent organizational and problem-solving skills
• Ability to learn new systems and technologies quickly
• Strong written and verbal communication skills
• Ability to manage multiple priorities and meet deadlines
• Commitment to confidentiality and responsible handling of sensitive information
• Familiarity with data visualization concepts and dashboard design
• Experience with Power BI, Power Query, SQL, DAX, reporting tools, or related technologies is preferred
• Demonstrated curiosity, initiative, and commitment to continuous learning

Nice To Haves

• Experience with LegalServer or similar case management systems is a plus
• Experience with Power BI, Power Query, SQL, DAX, reporting tools, or related technologies is preferred

Responsibilities

• Perform routine data quality reviews and audits to identify incomplete, inaccurate, duplicate, or inconsistent records
• Support data cleanup, validation, and standardization initiatives across organizational systems
• Assist with implementing and maintaining data standards, procedures, and best practices
• Monitor data integrity and escalate quality concerns as appropriate
• Maintain documentation related to data governance, reporting, and business processes
• Support organizational efforts to improve trust, consistency, and reliability of information assets
• Generate recurring and ad hoc reports for programs, leadership, funders, and external stakeholders
• Support grant reporting, outcome measurement, and organizational performance tracking
• Develop, maintain, and enhance Power BI dashboards and reporting solutions
• Assist in the design, testing, and validation of Power BI datasets, measures, visualizations, and data models
• Support data analysis and visualization efforts that communicate organizational performance and community impact
• Validate reporting outputs and troubleshoot reporting discrepancies
• Monitor dashboard functionality and identify opportunities for improvement
• Assist in developing key performance indicators and reporting frameworks
• Provide day-to-day support for LegalServer users and related organizational systems
• Assist with user account administration, permissions management, and access requests
• Support system testing, quality assurance, and deployment of new features and enhancements
• Maintain forms, workflows, templates, reports, and system documentation
• Track, troubleshoot, and resolve routine system issues and support requests
• Support integrations and reporting workflows between LegalServer, Power BI, Microsoft 365, and other organizational platforms
• Assist in validating data flows and ensuring consistency between source systems and reporting environments
• Support LegalServer administration activities as assigned
• Assist in identifying opportunities to improve operational efficiency through technology, automation, and process improvements
• Participate in implementation of new tools, workflows, and system enhancements
• Support automation initiatives involving reporting, data collection, and business processes
• Document and test system changes and process improvements
• Contribute to continuous improvement initiatives across departments
• Assist with onboarding and training staff on LegalServer, Power BI, and related systems
• Develop and maintain user guides, training materials, and procedural documentation
• Respond to user questions and provide technical support
• Promote best practices in data stewardship, reporting, and system utilization
• Support adoption of new technologies and workflows
• Assist with maintaining records and documentation required for grant reporting, audits, and compliance activities
• Support privacy, confidentiality, and data security practices through adherence to organizational policies and procedures
• Assist with information requests, audits, and reporting reviews
• Support organizational accountability through accurate and timely reporting
• Participate in system implementation, migration, upgrade, and integration projects
• Coordinate assigned project tasks, testing activities, documentation, and follow-up actions
• Assist with deployment of reports, dashboards, automations, and system enhancements
• Support vendor coordination and project communications as assigned
• Perform other duties as assigned

Benefits

• Medical coverage with an option for 100% employer-paid employee and dependent child(ren)’s premiums; buy-up options are available for other HMO and PPO coverage
• Dental and vision coverage
• Option to enroll in a Flexible Spending Account
• Employer-paid life insurance and disability plans
• Generous paid time off (per year): 15 accrued vacation days that increase to 20 days after 3 years of employment
• 12 accrued sick days that may be used for physical and mental health needs
• 2 personal observance days
• 11 paid holidays plus 2 one-week office closures (during the summer and winter)
• Up to 60 hours of compensatory time per calendar year (for exempt staff only)
• 403(b) retirement plan with an elective employee contribution, and after a year of employment a discretionary employer contribution
• Free on-site parking or public transportation reimbursement
• $45 per pay period for employees who use non-English language skills to perform work duties
• Up to 6 months of parental leave
• Organizational and team wellness activities to build team cohesion and camaraderie
• Professional development support and opportunities
• Annual payment of dues for required licenses or certifications (state bar dues for attorneys) and for a mutually agreed-upon professional organization

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree