Job Title: Senior Data Analyst Job Summary: CASES is a leading non-profit organization in New York City, dedicated to providing innovative alternatives to incarceration and comprehensive services for individuals impacted by the justice system. Our mission is to drive positive change and support transformative outcomes for our community. We are seeking a dynamic and detail-oriented Senior Data Analyst to join our Admin team. In this role, you will play a critical part in supporting the reporting needs of our pretrial services department. If you are passionate about data reporting and analysis, and excel in your craft, we invite you to apply and contribute to our mission. Salary: The salary for the Senior Data Analyst position is $70,000 per year. Shift Hours: The Senior Data Analyst position is full time from Monday through Friday 9am to 5pm. Location Address: 151 Lawrence Street Brooklyn, NY 11201. Workplace Flexibility: Remote. Th Senior Data Analyst position is primarily remote however it will require a candidate to be available for occasional mandatory in-office training and team meetings. What you will be doing:
- The Senior Data Analyst will oversee all aspects of data management, including reporting and analysis, for a comprehensive pretrial services program, utilizing Salesforce/Exponent Case Management (ECM) as the primary platform.
- The Senior Data Analyst will generate insightful analyses of crucial programmatic and operational results, aiming to deepen the agency's grasp of fundamental program challenges, patterns, and efficacy, thereby facilitating informed, data-centric decision-making.
- Will conduct database queries to retrieve analytical datasets for the program, addressing the requirements of the executive team, pretrial management, and external inquiries from sponsors, regulatory bodies, legislators, and other key parties.
- Will craft and showcase monthly as well as cumulative data on program performance through the year, employing data visualizations and dashboards for clarity and impact.
- Will participate in program planning efforts with pretrial services leadership by contributing insights about program data.
- Will create automated reporting systems to evaluate the program's performance relative to contractual objectives and establish procedures for billing, financial forecasting, and performance oversight.
- Will partner with the quality assurance team to pinpoint and rectify any discrepancies or omissions in data and play an active role in ongoing quality enhancement initiatives to ensure the aggregation of data for prompt and accurate billing and performance monitoring.
- Will supply the New York State Office of Court Administration with annual reports on pretrial services, featuring descriptive statistics, outcomes, and trend analyses.
- Will oversee special projects and provide support in the preparation of proposals, the compilation of foundation reports, and the coordination of fundraising efforts.
- Execute responsibilities in alignment with CASES' core values, embracing cultural diversity, upholding anti-discrimination principles, and adhering to established policies and protocols.
What we are looking for:
- High School diploma/GED/HSE or Bachelor's degree in related field with at least 3-5 years of experience as a data analyst working with relational databases; or a Master's degree in related field with at least 2 years of experience as a data analyst,
- Advanced proficiency in MS Excel (Pivot Tables, Advanced functions, Get and Transform), proficiency in other products in MS Suite required.
- Ability to work well in a fast-paced environment and multitask while adhering to deadlines.
- Be comfortable in situations where it's asked to lead projects and participate in ways to innovate creation of data solutions.
- Superior communication skills with the ability to work effectively with diverse teams and remain highly organized.
- Commitment to social justice and knowledge of NYC criminal justice system and alternatives to incarceration programs.
Additional, preferred skills we are looking for but are not required:
- Experience with Power BI highly preferred.
- Project management experience preferred.
- Salesforce experience highly preferred; Salesforce certified professional a plus.
- Other statistical software a plus.
- Experience with SQL, Python, SPSS (or other statistical software) a plus.
Employee Benefits: CASES cares about employee wellbeing, and we offer a comprehensive benefits package to support you and your family, including:
- Medical
- Dental
- Vision
- Vacation and Paid Time Off - starting at 25 days
- 12 Paid Holidays per year.
- Retirement 403(b) Competitive matching up to 6%.
- Employee Referral Program
Although we would love to learn about the skills of every candidate, only selected candidates that are selected will receive a response. We encourage you to apply for any position(s) you feel you are qualified for. CASES is proud to be an Equal Opportunity Employer. Employment with CASES is based solely on qualifications and competence for a particular position without regard to race, color, ethnic or national origin, age, religion, creed, gender, sexual orientation, disability, or marital, military, or citizenship status. We also actively recruit individuals with prior involvement in the criminal legal system.