Data & Systems Specialist

Description
ABOUT PUBLIC COUNSEL
Public Counsel is a nonprofit public interest law firm dedicated to advancing civil rights and racial and economic justice, as well as to amplifying the power of our clients through comprehensive legal advocacy. Founded on and strengthened by a pro bono legal service model, our staff and volunteers seek justice through direct legal services, promote healthy and resilient communities through education and outreach, and support community-led efforts to transform unjust systems through litigation and policy advocacy in and beyond Los Angeles.
Public Counsel organizes its work through seven legal teams: Child, Youth & Family Advocacy, Community Development, Consumer Rights & Economic Justice, Homelessness Prevention, Immigrants’ Rights, Education Equity, and our impact litigation team, Opportunity Under Law.
Public Counsel has a staff of approximately 170. We are committed to building a diverse staff and encourage applications from people of color, people with disabilities, and people of all gender identities, gender expressions, and sexualities. We recognize the essential role of staff in achieving our goals, and we have set a long-term intention to provide competitive compensation, benefits, training, mentorship, and overall workplace wellness, making Public Counsel a leader among nonprofit law firms.

ABOUT DATA, SYSTEMS & INNOVATION

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.

JOB SUMMARY
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. The position will have the following responsibilities:
Data Quality & Information Management
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
Reporting, Analytics & Business Intelligence
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
LegalServer & Systems Support
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
Technology, Automation & Process Improvement
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
Training, Documentation & User Support
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
Compliance & Organizational Support
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
Project Support
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
Requirements
ESSENTIAL JOB SKILLS AND ABILITIES
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
JOB TYPE AND BENEFITS
Full-time/non-exempt
Salary range is $62,030.95–$72,834.94 ($31.81–$37.35 per hour) depending upon years of experience.
Bargaining
Probationary period: 6 months
Public Counsel offers a competitive benefits package including
:
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)
Additional benefits:
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
Centrally located headquarters in the heart of Koreatown, a vibrant neighborhood with easy access to public transportation, diverse dining options, and cultural attractions
HOW TO APPLY
We value lived experiences and experiences working with clients across a range of settings. Please consider discussing such experiences in your cover letter, especially if they are not reflected in your resume.
PUBLIC COUNSEL VACCINATION POLICY AND COVID-19 PROTOCOLS
Public Counsel requires vaccination against COVID-19
for all employees, including new hires
. Pursuant to federal and state laws, Public Counsel will provide reasonable accommodations to qualified employees with disabilities or sincerely held religious beliefs, unless doing so would pose an undue hardship.
Public Counsel is generally office-based, but remote work was launched during the pandemic. All employees with Public Counsel are now required to work in the office
at least
one day per week, at the discretion of the head of department. Some positions require additional in-office days. This policy is subject to redesign by leadership. Public Counsel will work in a manner consistent with public health and local and state emergency orders.

PUBLIC COUNSEL EEO POLICY
Public Counsel is an Equal Opportunity Employer that does not discriminate against employees or prospective employees on the basis of union membership or activity, race, religious creed, religious observance, ethnicity, color, gender, sex, sexual orientation, gender identity, gender expression, genetic information or predisposition, military service, military and veteran status, pregnancy, child birth and related medical conditions, marital and family status, national origin, ancestry, age, medical conditions as defined by state or federal law, or disability, or any other basis prohibited by law.
All qualified applicants with criminal histories will be considered in a manner consistent with the requirements of the Los Angeles Fair Chance Initiative for Hiring.
Our leadership team is dedicated to this policy with respect to recruitment, hiring, placement, promotion, transfer, training, compensation, benefits, employee activities discipline, discharge and general treatment during employment.