Position Summary:

The Systems & Data Management Administrator will perform various tasks that include data migrations, creating analytics dashboards using Business Intelligence tools, and ensuring the data held within the Customer Relationship Management (CRM) system is complete and accurate. They will map, transform, and load data into CRM from a range of source systems while managing the day-to-day operations of Salesforce. This position will assist in providing technical assistance in examining, improving, designing, and developing data systems and processes to meet stakeholders’ requirements and goals and support the whole organization. 

Essential Duties and Responsibilities:

• Assist in gathering and refining requirements from stakeholders to build systems and solutions utilizing various systems to meet the organization’s goals
• Assist in managing CRM systems to track and report on performance relative to goals and develop improvement action plans 
• Build and manage Dashboards utilizing Salesforce Reports, Google Data Studio, and Power BI to track the performance of the organization for various department heads and leadership
• Perform Data modeling where necessary to enable BI development
• Perform data migration projects from other systems/applications into Salesforce, ensuring data integrity and completeness
• Manage tech solutions for ministries using platforms and software such as Salesforce, Connections, StudioC, Active Campaign, Planning Center, HelpScout, Twilio, Form Assembly, etc. 
• Assist in managing the day-to-day operations of Salesforce system via user management and permissions, updating solutions and automation, offering training and training materials to all users, and employing any fixes and updates, as needed 
• Assist in managing support tickets and requests to help manage tasks and projects by helping implement fixes and solutions to reported problems in a timely manner and with good customer service.
• Help manage contractor and vendor agreements, budgets, invoices, etc.
• Stay knowledgeable on the latest advancements in technology and data systems as well as releases for existing systems 
• Assist in coordinating the work of teammates to accomplish CRM, Business Intelligence, or Data management objectives
• Daily update progress, planned work, and roadblocks in project management software.
• Help manage online giving support to ensure customer service issues are resolved in an appropriate and timely manner.
• Responsible for weekly reconciliation of all unmatched donations to correct contact in CRM.
• Design, build, and configure applications that are highly functional, scalable, and easily maintained.
• Automate business processes using Salesforce automation tools, such as Process Builder, Workflows, Formulas, Flow, Assignment Rules, and email Alerts.
• Build and maintain Dashboards utilizing Salesforce Reports, Google Data Studio, and Power BI to track performance of the organization for various department heads and leadership (Google Data Studio and Power BI prior experience not required but preferred).
• Manage the day-to-day operations of Salesforce via user management and permissions, updating solutions and automation, offering training and training materials to all users, and employing any fixes and updates as needed.
• Increase data integrity by consolidating business rules across multiple channels into one business layer using SOA architecture.

The above summary of duties represents the major tasks and duties. This is not intended to be an exhaustive list of all responsibilities. Therefore, the individual may perform other related tasks under the leadership of the Director of Systems & Data Management.

Job-related Qualifications: Education, Training, and Experience

• 2-4 years experience as a CRM System Manager 
• Previous experience in tech solutions and training.
• Previous experience in project management.
• Customer service experience required experience with managing and troubleshooting databases 
• Bachelor’s Degree in computer science, information technology, or related field preferred 

Job Skills, Knowledge, Abilities

• Christ-centered work ethic in all areas of administration.
• Commitment to excellence in all aspects of ministry.
• Must have the ability to grasp new technology and perform duties in compliance with Rock Church Tech Solutions and Data Management policies and procedures.
• Demonstrated skills and techniques to recognize problems, issues, and situations and apply resourcefulness in finding appropriate solutions to mitigate potential negative effects. Ability to follow through to ensure effective resolution. 
• Proven ability to interact in a consistently positive manner with external clientele, including applicants, volunteers, vendors, visitors, and guests, using a high degree of tact, diplomacy, discretion, flexibility, respect, and courtesy in gesture and speech. Demonstrated ability to make independent decisions based on the vision and values of Rock Church.
• Strong attention to detail and accuracy, including excellence in oral and written communications to verbalize issues clearly, concisely, and competently in positive or negative situations.
• Must possess strong computer skills, including proficiency with spreadsheets, databases, and word-processing software. 
• Adapts to changes in the work environment; able to deal with frequent change, delays, or unexpected events with poise and professionalism.
• Identifies and resolves problems in a timely manner; responds promptly to requests for service and works well in group problem-solving situations; strong team player who meets commitments. 
• Ability to work in a high-volume environment while maintaining solid productivity and quality of work.
• Strong communication and relational skills.
• Self-motivated and flexible, with strong organizational skills and the ability to work well with timelines and short deadlines.
• Ability to multitask, prioritize assignments, and provide excellent customer service. 
• Work productively, both independently and collaboratively with others.
• Follow verbal and written instructions.
• Proficiency with Microsoft Office for MAC (Outlook, Word, Excel, and PowerPoint).
• Ability to recognize and maintain confidentiality as appropriate.

Organizational and Spiritual Requirements:

•  Contributing member of the Rock Church (or willing to transfer membership to the Rock Church). 
• Christ-centered behavior at all times by treating people with dignity, respect, compassion, and integrity.
• Utilize the principles of Matthew 18 and Ephesians 4:15 to resolve differences of opinion with others.
• Successful completion of a thorough pre-employment references and background checks, which includes: social security verification, Local, State & Federal criminal conviction records search, national security database, and sex offender registry.
• Attendance at all mandatory meetings and events.  This includes serving at Good Friday, Easter, and Christmas services, as well as the annual volunteer appreciation event.
• Regular involvement in Rock Church activities, ministries, and events.
• Tithe 10% to the Rock Church.
• Signed acknowledgment of the Rock’s Statement of Faith.
• Ability to interpret and adhere to the Rock’s policies, procedures, and employee handbook.
• Be self-motivated and goal-oriented, use good judgment, and be flexible and innovative.
• Professional attitude and demeanor.

Physical Requirements:

Reasonable accommodations may be made to enable individuals with disabilities to perform these essential functions. Must be able to work independently, communicate effectively, and lift up to 25lbs (with or without assistance). This position also may require long periods of sitting, standing, walking, and hand/eye coordination for keyboard data entry and viewing data on a computer monitor. External and internal applicants, as well as position incumbents who are or become disabled, as defined under the Americans with Disabilities Act, must be able to perform the Essential Job Functions either unaided or with the assistance of a “reasonable accommodation”, if such is determined, on a case-by-case basis.

Employment At-Will:

Employment at the Rock Church and Academy is “At-Will,” meaning either the Rock or the employee may terminate the employment relationship at any time, for any reason, with or without advance notice. 

Nothing contained in this job description or any other communication (written or verbal) the employee received is intended to be, nor should it be, construed as a guarantee that employment or that any benefit will be continued for any period of time. Compensation information provided to an employee, whether stated in hourly, bi-monthly, annual, or other terms, is not intended, nor does it constitute an employment contract or agreement for any specific period of time.

No manager, supervisor or employee of the Rock Church and Academy has any authority to enter into any agreement for employment for any specified period of time or to make any agreement for employment other than at-will.