Senior Data Analyst

  • 151 Lawrence St, Brooklyn, NY 11201, USA
  • Full-time

Company Description

CASES is a New York City non-profit organization at the forefront of alternative to incarceration programs and comprehensive services for criminal justice-involved populations. If you are passionate about emerging data reporting and analysis techniques and take pride in your craft come join our team. CASES’ seeks a Senior Data Analyst for the data reporting and analysis unit. We need a team member with extensive knowledge of Salesforce. Our ideal candidate is curious, highly skilled in relational databases and Excel formulas and able to hustle to meet recurring weekly, monthly, quarterly and ad hoc deadlines.

Job Description

  •  Develop expertise and advanced competence in a customized Salesforce platform and as needed familiarity and competence with government databases to enter performance data and to extract data for analysis, build and configure large data files for invoicing and reporting
  •  Responsible for billing, data reporting and analysis for programs using Salesforce
  •  Develop automated data reports to analyze program performance and submit weekly, monthly and quarterly data reporting and billing
  •  Work collaboratively with quality assurance analysts to identify missing, inaccurate, or otherwise problematic data and contribute to oversight procedures to monitor and track the timeliness, accuracy, and usefulness of data
  •  Extract, format and transform data from agency databases into tables, figures, and charts, and data reports according to program contract management and set protocols for invoicing, financial projection analysis, and performance management
  •  Develop and present monthly and year-to-date program performance using data visualizations providing year-to-date trend analysis and performance trends
  •  Develop and use protocols to identify problems with data entry, datasets and routine extraction processes, rectify issues, and systematize processes for efficient workflows in collaboration with information services and program staff
  •  Contribute to continuous quality and efficiency improvement to innovate and streamline ways to bring together data for timely, error-free invoicing back-up reports, and performance tracking, and data visualizations in seamless processes
  •  Review invoice backup data for contracts to ensure the data is reported accurately and that verifiable back-up documentation is available and maintained for audits
  •  Conduct regular data quality assurance checks to ensure accuracy of data reports produced and of the data in the database, following quality assurance protocols for random peer-to-peer review of analysis conducted by other analysts and reports before distribution internally and to government and funding agencies
  •  Produce analysis on key program and operational outcomes and drivers that influence year-over-year program performance to enhance agency understanding of underlying program issues,
  • trends and performance to ease the use of data to inform program decision-makers
  •  Execute queries in databases to extract program datasets for analysis to respond to the needs of senior staff, program staff and external requests from funders, collaborators, policymakers, donors, and other stakeholders
  •  Communicate clearly and accurately in both verbal and written mode concisely describing problems, solutions, specifications and plans related to data reports
  •  Lead projects on data reporting, analysis, management and planning initiatives
  •  Participate in program planning efforts by contributing insights about program data, to support the creation of outcomes and plans to track and report on benchmarks
  •  Manage special assignments that may include analytical support needed to assist in responses for proposals, foundation reports and fundraising
  •  Deputize for the Director Data Reporting & Analysis at meetings with government agencies and for quality assurance and change management projects
  •  Perform end user and application support functions including problem solving and resolution of Salesforce application function defects. Provide staff training and support.
  •  Perform duties in accordance with CASES’ mission, cultural competency, anti-discriminatory and other policies and procedures
  •  Any other duties as required by the Director and senior staff

Qualifications

  •  Masters degree in related field and at least 2 years of experience as a data analyst, or
  •  Bachelor’s degree in related field with at least 3-5 years of experience as a data analyst working with relational databases
  •  Salesforce experience required
  •  Salesforce certified professional a plus
  •  Advanced proficiency in SQL, SPSS (and other statistical software), MS Excel (Pivot Tables, Advanced functions, Get and Transform), MS Access, MS Project, Visio and other products in MS Suite
  •  Experience with Power BI a plus
  •  Ability to work well in a fast-paced environment and multitask while adhering to deadlines
  •  Project management experience preferred
  •  Be comfortable in situations where asked to lead projects and participate in ways to innovate creation of data solutions
  •  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 Information

The salary range for this position is competitive and commensurate with demonstrated experience and skills

In one document, attach your cover letter and resume in PDF or Word format. No phone calls please. Only applicants selected for interviews will be contacted.

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 justice system.Your information will be kept confidential according to EEO guidelines.