Salesforce and Database Administrator/Data Analyst
The Resurrection Project
March 7, 2018
Full Time - Experienced
4 Year Degree
Organization General Description
After 28 years and an initial seed capital of $30,000 from area parishes, The Resurrection Project (TRP) has grown to become a powerful and effective social enterprise that seamlessly blends community development, community organizing, and advocacy with human service delivery to create vibrant, healthier, and involved communities. Our efforts have resulted in leveraging over $469 million in community investment.
General Job Description
The Salesforce and Database Administrator/Data Analyst (SDADA) is responsible for managing the organization’s Customer Relationship Management (CRM) and integrated platforms for the organization’s data collection, management, and reporting needs. This position reports to the Director of Information Technology, and works closely with the IT Coordinator and organizational Pillar Heads to plan, coordinate, and convey the visual representation of the qualified data, information, and knowledge. The SDADA’s goal is to maintain effective and efficient utilization of the CRM, and to facilitate collection and extraction of key performance indicator metrics. The SDADA will be responsible for sourcing, qualifying, and validating CRM data outputs for reporting needs and ensuring data integrity during the collection process.
Job Duties and Responsibilities
Salesforce and Database Administration: • Manage and administer the CRM. • Manage users, and customize and implement profiles, roles, and security settings. • Coordinate training needs, and create and maintain training materials and user documentation, as well as provide user training. • Design and create automated processes including alerts, field updates, and email generation using Process Builder, Standard, and Visual Workflows. • Document company processes and workflows. • Develop process documentation and field maps. • Create new processes and associated reporting. • Batch/bulk exports, imports, and updates of data. • Manage third party extensions, including complex reporting tools. • Manage SQL Databases. • Manage Salesforce API interfacing with other TRP platforms.
Data Analysis: • Data management, analysis, and manipulation. • Monitor and improve data quality. • Import data as appropriate. • Regularly perform data and clean-up procedures. • Audit, uncover, and resolve data integrity issues. • Deliver training and communication to TRP Staff. Create and administer training to existing or new users/groups. Provide one-on-one training to end users on an ongoing basis. • Develop reports, dashboards, and processes to support department operations. • Qualify report data, identify, and resolve user input errors. • Oversee and assure the compliance and data integrity of reports, as well as the backup and audit-ready hard copy files and documentation. Prepare monthly, quarterly, and annual dashboard reports for staff and board members. • Quality control and sharing of the following regular reports: • Monthly and quarterly management dashboards and scorecard reports. • Quarterly and annual board reports. • Quarterly and semi-annual grant reports as assigned. • Other duties as assigned.
Essential Knowledge and Skills
• Bachelor’s degree required. • Strong overall technical background. • 3 to 5 years’ Salesforce.com administration experience. • Experience with Apex and VisualForce development required. Salesforce Platform Developer 1 or higher certification strongly preferred. • Strong understanding of Salesforce.com best practices and functionality. • Excellent project management and organization skills. • Understanding of relational databases and database integrity tools. • Experience using data loader and de-duplication tools. • Proficiency in data manipulation using Excel and other related tools. • SQL Database management and query experience. • Strong research, troubleshooting, and creative problem-solving skills. • Team player with positive attitude. Proactive, organized, and logical. • Great communication skills.
Special Working Conditions and Demands • Must be able to work some evenings and weekends.
Statement of Equal Opportunity
The Resurrection Project is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy), national origin, ancestry, age, marital status, sexual orientation (including gender identity), military status, disability, language (any language use not related to job duties), or any other status protected by applicable federal, state, or local law.