Data & Systems Specialist

Public Counsel•Los Angeles, CA

12h•$62,031 - $72,835•Hybrid

About The Position

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. This position is part of the emerging Data, Systems & Innovation team, which strengthens how Public Counsel manages and uses data and technology. The team oversees data governance, quality, privacy, and reporting; manages LegalServer and related systems; and leads systems development, integration, automation, and process improvement. The team also 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.

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

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