The Legal Aid Society · New York, NY
The Legal Aid Society, the nation’s oldest and largest nonprofit law firm serving New York City, exists for one simple yet powerful reason: to ensure that no one is denied the right to equal justice because of poverty. For over 140 years, we have protected, defended, and advocated for those who have struggled in silence for far too long – working on the front lines and behind the scenes to offer our clients the exceptional legal services they deserve. Through our Civil, Criminal Defense, and Juvenile Rights Practices, we offer an unmatched depth and breadth of legal expertise to vulnerable New Yorkers in over 300,000 legal matters each and every year. Every day, in every borough.
The 2,200+ members of our staff who directly represent clients, advocate and litigate for systemic reform, and provide the administrative infrastructure for our organization are key to our success and ability to meet our mission.
As part of the continuing effort to improve the functionality of the Society's database management systems, the Application Development Group is currently looking for a Data Analyst to assist with the customized reporting, coding, testing and support of the Society-wide Law Manager application. The Data Analyst will interact with business users from all practice areas within Legal Aid, in order to provide the best software solutions to the Society.
- Contribute to the report development lifecycle, including the gathering and understanding of requirements, database and report development using SQL Server Management Studio and SQL Server Reporting Services
- Develop stored procedures for use in reporting and analysis, including ad-hoc and stand-alone reports
- Maintain a clear understanding of business rules, policies and operations among different Legal Aid practices
- Use understanding of the Law Manager database structure and data flow to help business users and management with the data analysis
- Assist with the review process for the numerous reports that are used by Legal Aid staff in Civil, Criminal and Juvenile Practices
- Identify and research data inconsistency issues, and work with business partners to resolve and improve the data flow
- Maintain several report developments projects concurrently, along with meeting separate deadlines
- Work with business users on data visualization to capture complex data relationships and data-driven insights in a way that is easy to understand
Please submit these documents as a single combined PDF when you apply via the LAS (Legal Aid Society) Recruitment Portal.
- Cover Letter
- A sample of written work product – either a reporting format, communication capturing a business need, or a data visualization product
- Ability to learn and fully grasp the business practice and rules that apply to Legal Aid computer systems
- Ability to obtain a basic understanding of the Law Manager database schema
- Ability to understand and follow established business and legal procedures within practice areas in order to expedite the data review process so as to help the Society staff to serve their clients
- Good understanding of SQL Query language is required
- Proficient in MS SQL Server, including Management Studio and SQL Server Reporting Services
- PowerShell scripting is a strong plus
- Familiarity with Power BI is highly desired
- Experience visualizing SQL (or other data source) data using Tableau, Power BI or other data visualization tools
- Familiarity with M365, SharePoint online and Teams
- Excellent attention to detail and the ability to deliver on-time
- Ability to work collaboratively while providing valuable creative input
- Bachelor’s degree or equivalent work experience
- Excellent knowledge transfer skills
- Strong communications skills
The posting reflects the range of potential salaries for the role. The specific salary offers will be dependent on candidate qualifications, including collectively bargained salary steps for unionized roles.
$87,000 - $98,000
SALARY AND BENEFITS
The leadership of The Legal Aid Society believes in attracting and retaining exceptional talent committed to serving our clients. We offer a generous benefits package including health insurance, paid vacation, disability, and life insurance, and more. Salaries for our unionized jobs are governed by our Collective Bargaining Agreement. Please visit our Careers page for additional information. Salary and benefits information will be available to applicants, when and if, an offer is made.
OUR COMMITMENT TO DIVERSITY, EQUITY, AND INCLUSION
The leadership of The Legal Aid Society is committed to a work culture of zealous advocacy, respect, diversity and inclusion, client-oriented defense, access to justice and excellent representation. We are dedicated to building a strong professional relationship with each of our clients, to understanding their diverse circumstances, and to meeting their needs. Our ability to achieve these goals depends on the efforts of all of us.
COVID VACCINATION INFORMATION
The Legal Aid Society is taking precautions and implementing safety measures to help prevent the spread of COVID-19 and to comply with New York City's requirements concerning Covid-19. All members of the Legal Aid community have a shared responsibility to support and comply with policies and protocols to protect the health and safety of our community. Learn more about our COVID-19 policy by visiting our website.
HOW TO APPLY
All applications must be completed online. We do not accept paper submissions. Please visit our Careers Page to review all current job postings, and instructions on the application process. For technical difficulties or questions regarding this posting, please email [email protected] opens an email client application.
As an Equal Employment Opportunity (EEO) Employer, The Legal Aid Society prohibits discriminatory employment actions against and treatment of its employees and applicants for employment based on actual or perceived race or color, size (including bone structure, body size, height, shape, and weight), religion or creed, alienage or citizenship status, sex (including pregnancy), national origin, age, sexual orientation, gender identity (one’s internal deeply-held sense of one’s gender which may be the same or different from one’s sex assigned at birth; one’s gender identity may be male, female, neither or both, e.g., non-binary), gender expression (the representation of gender as expressed through, for example, one’s name, choice of pronouns, clothing, haircut, behavior, voice, or body characteristics; gender expression may not be distinctively male or female and may not conform to traditional gender-based stereotypes assigned to specific gender identities), disability, marital status, relationship and family structure (including domestic partnerships, polyamorous families and individuals, chosen family, platonic co-parents, and multigenerational families), genetic information or predisposing genetic characteristics, military status, domestic violence victim status, arrest or pre-employment conviction record, credit history, unemployment status, caregiver status, salary history, or any other characteristic protected by law.