Sign In
Database Administrator, Data Anlysis, Research & Evaluation

Who We Are: CAMBA is a community of staff, volunteers, clients, donors, neighbors and partners who work together to build an inclusive New York City, where all children and adults have access to the resources and supports they need to thrive.  We take a comprehensive approach by offering more than 160 integrated programs in:  Education & Youth Development, Family Support, Job Training & Employment Support Services, Health, Housing, and Legal Services. We reach more than 65,000 individuals and families each year at our 90 locations, including 10,000 youth.  CAMBA serves a diverse cross section of New Yorkers from new mothers in Brownsville to job seekers in the Rockaways. More than half of our clients are immigrants and refugees from around the globe. Over 85% of our families are in living in poverty, reflecting the challenges faced by nearly 1.7 million New Yorkers today. 

CAMBA's Data Analysis, Research and Evaluation 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.

Responsibilities: 

  • Maintain clients' data 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 system (creating proper forms and fields to address specific program needs, and training the staff in how to use the system).
  • Build and modify question templates/assessments, queries and management reports based on program needs.
  • Research all aspects of CAMBA's data tracking and outcomes reporting requirements.
  • Create and maintain reports and dashboards using various reporting software (i.e. Tableau, SQL Server Report Services (SSRS), Crystal Reports, etc.)
  • Manage the creation of new user accounts, new roles, user group security and permissions based on programs' protocols.
  • Document all design and development work.
  • Create mapping of various database structures and prepare data for data migration across different systems/databases.
  • Extract data from various sources including Excel Source, Flat File Source, DBF Source, CSVs text file etc.
  • Write scripts to ensure that data is consistent in the database. 
  • Write scripts for data cleansing within the database and scripts to migrate data into different databases.
  • May troubleshoot, repair, and update legacy scripts/reports written by other DBAs using TSQL.
  • Apply various business logic to validate/convert /allocate the data using string manipulations, analytical functions, data conversion functions, user defined functions, stored procedures and ad-hoc queries.
  • Verify and analyze data sets and query results for accuracy.
  • Schedule and analyze monthly CSV downloads and upload files to DHS Foothold database.
  • Maintain professional relationships with system users.
  • Collaborate with program staff to identify data tracking and reporting needs.
  • Assist program staff with conducting data analysis to ensure data integrity (i.e., ensure data entries are accurate and unduplicated).
  • Provide technical assistance to CAMBA staff as part of a Help Desk team.
  • Visit program sites to train, assist program staff and collect feedback/ requirements
  • Interact with users periodically to elicit user feedback, "lessons learned" and future enhancements.
  • Prepare for and co-facilitate user group or one-on-one trainings for staff.
  • Manage system development hours and troubleshoot Tech Support Tickets from staff and fellow DBAs via Help Desk.
  • Participate in administrative and staff meetings/calls.
  • Provide all required information for weekly/monthly/quarterly/annual reports to CAMBA management and/or to funders.
  • Maintain communication and "fast-feedback" with supervisor and other parties involved concerning all design and development tasks.
  • Meet with supervisor to discuss system and administrative issues.​

Requirements:

  • Bachelor's degree (B.A. or B.S.) in Computer Science and two years of applicable experience and/or equivalent experience.
  • Must have strong knowledge of relational databases.
  • Proficiency with Microsoft Access, SQL Server 2008, 2014; SQL Server Reporting Services (SSRS), and Microsoft Visual Studio.
  • Proficient in writing complex SQL Scripts (T-SQL).
  • Knowledge of SQL Server Integration Services (SSIS) & SQL Server Analysis Services (SSAS) is a plus.
  • Proficient in creating stored procedures and views.
  • Proficient in creating Alteryx workflows.
  • Proficient in migrating data across systems/databases.
  • Must have a strong knowledge of advance Excel features (creating Macros with VBA code).
  • Proficient in writing VBA scripts
  • A solid understanding of how users go through change and the change process.
  • Experience and knowledge of change management principles, methodologies and tools
  • Excellent active listening skills.
  • Ability to clearly articulate messages to a variety of audiences.
  • Ability to influence others and move toward a common vision or goal.
  • Problem solving and root cause identification skills
  • Attend trainings for system administrators on or off site as needed.
  • Knowledge of VB, ASP .Net and R is a plus.
  • Ability to converse with clients in a language other than English (Haitian/Creole, French, Spanish, Russian, etc.), desirable but not required. 
EOE:
CAMBA is an Equal Opportunity Employer. We value a diverse workforce and inclusive workplace. People of color, people with disabilities, and lesbian, gay, bisexual, and transgender people are encouraged to apply. We consider all applicants without regard to race, color, religion, creed, gender, gender identity, gender expression, national origin, age, disability, socio-economic status, marital or veteran status, pregnancy status or sexual orientation.​​​

back to Careers