Sign In
Database Administrator, Program Evaluation and Data Analysis

CAMBA's Program Evaluation and Data Analysis Department maintains the agency's client tracking database (including client demographics, service delivery and outcomes), and agency-wide program dashboards. We train program staff in data entry, and generate reports for agency executive and managers, as well as for funders.  We design program evaluation projects (sometimes along with external researchers at universities and research organizations), collect and analyze data, and report on results.

 

Essential Duties and Responsibilities: The person filling this position is expected, under general supervision to: (1) serve as a Database Administrator for the implementation of CAMBA's electronic case management system for CAMBA's contracts/programs; (2) perform and coordinate functions related to CAMBA's electronic case management system on a day-to-day basis; and, (3) Create application-, management- and ad hoc reports using SQL Server Business Intelligence Development Studio (BIDS); including the following:​

  • Maintain professional relationships with clients, and client confidentiality.
  • Practice Universal Precautions/Standard Protocol & Procedures.
  • Comply with any and all Federal, State, City and CAMBA security and privacy polices intended to protect the security and privacy of individually identifiable health information.
  • As new programs emerge, incorporate these programs into the CAMBA database (creating appropriate username, passwords, and proper forms, fields to address specific program needs, and training the staff in how to use the system).
  • Manage the creation of new roles, user group security and permissions based the program's protocols.
  • Manage TSP Hours and troubleshoot tech support tickets from staff and fellow DBAs.
  • Collaborate with program staff to identify their data tracking and reporting needs.
  • Build and modify question templates, queries and management reports based on program needs.
  • Create and maintain reports using various reporting software (i.e., Basic Visual Studios, SQL Server Report Services [SSRS], etc.)
  • Maintain communication and "fast-feedback" with supervisor and other parties involved concerning all design tasks.
  • Meet with supervisor regularly to discuss system integrity and administrative issues.
  • May schedule and analyze monthly CSV downloads and upload files to DHS Foothold database.
  • May troubleshoot, repair, and update legacy scripts and reports written by other DBAs using TSQL.

Minimum Education/Experience Required:

  • Bachelor's degree (B.A. or B.S.) in Computer Science and two years of applicable experience and/or equivalent experience.

Other Requirements:

  • Proficiency with Microsoft Access, SQL Server 2008; SQL Server Reporting Services (SSRS), and Microsoft Visual Studio.
  • Proficient in writing complex SQL Scripts (T-SQL).
  • Proficient in creating stored procedures.
  • Proficient in writing VBA scripts
  • Proficient in creating Alteryx workflows.
  • Must have strong knowledge of relational databases and advance Excel features (creating Macros with VBA code).
  • Knowledge of VB and ASP .Net is a plus.
  • Knowledge of SQL Server Integration Services (SSIS) & SQL Server Analysis Services (SSAS) is a plus.
  • Attend trainings for system administrators on or off site as needed.
  • Ability to converse with clients in a language other than English (Haitian/Creole, French, Spanish, Russian, etc.), desirable but not required. 

back to Careers