Database Assistant at Village Enterprise

Key Roles and Responsibilities

• Support onboarding of new projects into the system by providing necessary user logins and supporting basic setup.
• Support system prep for new data entry cycles, ensuring they are completed in a timely manner.
• Consult with field data collection and project teams on configuring the Salesforce and TaroWorks interface to their preferences.
• With supervision from the direct supervisor, support in design, development and deployment of TaroWorks forms and ensure correct mapping to Salesforce.
• Support in Salesforce schema updates such as field creation and/or updates with supervision.
• Support system/helpdesk, track and respond to user requests in a timely and effective manner.
• Perform regular file archiving and purges as necessary.
• Create and change user accounts as requested.
• Develop and maintain reports on Salesforce as requested.
• Manually upload data as necessary to support project teams with the creation of large numbers of records and any mass modification of existing records.
• Perform weekly data cleaning, interpret reports and send logs to relevant project teams.
• Support teams to drive data quality by proactively identifying areas with data quality issues and recommending potential solutions.
• Creatively and proactively respond to user bottlenecks, developing ad hoc tools as needed.
• Participate in technology planning in collaboration with other members of the Technology Solutions team.
• Manage the sandboxes and users that have access to the sandbox environments.
• Manage Salesforce Storage limits and data backups

Responsibilities

• All systems and database process manuals should be well documented and up to date including, but not limited to, database structure, data dictionaries, integrations and procedures
• Systems and database cleanup done on regular basis as per best practice and compliance procedures
• Adequate support to users regarding DB access, data entry, troubleshooting and overall best practices
• Manage user access and controls to ensure data security and integrity
• Quality checks to ensure data is entered correctly and completely and run data maintenance reports

Safeguarding Expectations

• Safeguarding is everyone's responsibility at Village Enterprise and it begins with individual staff;
• Continuously sensitize program participants on safeguarding.
• Ensure compliance with Village Enterprise’s safeguarding policies.
• Report any incident of safeguarding in program operations for appropriate action/follow up.

Requirements

• Bachelor’s degree with a technical major, such as engineering or computer science.
• Relevant working knowledge in relational database management, ie, MySQL, PostgreSQL
• One-year experience in systems administration, with particular emphasis on data management
• Knowledge of or willingness to learn Salesforce terminology and administration.
• Knowledge of or willingness to learn TaroWorks.
• Ability to proactively identify and address complex problems in a way that responds to end user needs.
• Ability to communicate complex technology to users of all ability levels in a way that is understandable, respectful and engaging.
• Ability to work independently and remotely while contributing to a team effort.