AR Systems Analyst

AR Systems Analyst San Jose, CA Job Details Full-time $20 - $24 an hour 1 day ago Benefits Health insurance Dental insurance Paid time off Vision insurance Retirement plan Paid sick time Qualifications Performance dashboard reports VLOOKUP function Associate's degree in accounting Business financial process improvement Accounting systems Dashboard development Certified Salesforce Administrator Financial close processing Internal controls Google Sheets Data Integration (Data management) PCI Automation Financial transaction processing Financial reporting Processing cash transactions Process improvement Data reporting Associate's degree in finance Mid-level Finance Salesforce Cloud Financial report interpretation Data quality monitoring Staff training Data entry Accounting and finance experience CRM system proficiency Deposits Data validation Sage Intacct Batch data processing Financial audit support Associate's degree Accounting Communication skills Balancing end-of-day transactions Financial compliance Excel data analysis Full Job Description Monday through Friday 8:30am-5:00pm Job description:

POSITION SUMMARY

The AR Systems Analyst owns the end-to-end flow of donor revenue—from weekly cash and check counts to online gifts processed in Pushpay—into our Salesforce CRM and Sage Intacct General Ledger. Blending accounts-receivable fundamentals with data-management savvy, you will ensure that every contribution is captured accurately, reconciled promptly, and reported clearly for multiple legal entities. Success in this role hinges on meticulous attention to detail,strong internal-control instincts, and a passion for leveraging systems to support ministry impact.

KEY RESPONSIBILITIES

Donation Processing (Cash & Checks) o Receive, open, and count weekly cash and check offerings under dual control. o Prepare batched deposit slips and post gifts by entity, fund, and campaign in Salesforce/Pushpay "Offline Gifts." o Reconcile physical deposits to Salesforce, Sage Intacct, and bank reports; research and resolve discrepancies. o Maintain secure custody of undeposited funds following segregation-of-duties policies. Online Gifts & Data Integration o Import, validate, and post daily Pushpay transactions into Salesforce via flows or data-loader tools. o Map new funds, campaigns, and giving types, ensuring correct AR/GL coding for each entity in Sage Intacct. o Monitor automated sync jobs and troubleshoot errors quickly. General Ledger & Sage Intacct o Prepare and upload journal entries or import files to record donor revenue in Sage Intacct.

Maintain dimension mappings (entity, location, department, project, class) to ensure accurate financial reporting. o Assist the Accounting team with month-end close tasks, account reconciliations, and audit schedules derived from Sage Intacct. Data Quality & Governance o Run weekly audits to identify duplicates, incomplete records, or out-of-policy values; merge or correct as needed. Enforce naming conventions, field-level security, and picklist standards; maintain the Finance Data Dictionary. Reconciliations & Reporting o Reconcile Pushpay settlements, cash/check deposits, Salesforce data, and Sage Intacct GL against bank activity for multiple entities. o Produce recurring dashboards (giving trends, pledge progress) and deliver month-end donor-revenue summaries to Accounting. Process Improvement & Support o Partner with Salesforce Admins and Accounting to refine automation, validation rules, and page layouts that streamline AR tasks. o Train ministry staff on proper gift entry and basic reporting; field donor-data questions. Compliance & Confidentiality o Safeguard donor information and physical funds in alignment with

PCI-DSS, IRS

regulations, and internal policies. Assist with year-end giving statements and external audit requests Requirements

REQUIRED QUALIFICATIONS

Education & Experience o Associate degree in Accounting, Finance, or related field (Bachelor's preferred). o 1+ year handling accounts receivable or contribution processing, including data entry in Salesforce (NPSP/Nonprofit Cloud) and Pushpay (or similar). o Exposure to Sage Intacct or another cloud GL system; understanding of multi-entity GL coding. Technical Skills o Working knowledge of Salesforce reports, dashboards, and data-loading tools. o Basic navigation, import/export, and report-running skills in Sage Intacct. o Intermediate Excel/Google Sheets (v-lookups, pivot tables). o Comfort manipulating CSV files and large data sets. Soft Skills o Impeccable attention to detail and strong sense of internal control. o Clear written and verbal communication; able to translate technical issues for non-technical staff. o Alignment with the mission and values of Redemption Church; treats donor data and funds with discretion and respect. Preferred (Nice-to-Have) Salesforce Administrator (ADM-201) or NPSP/Nonprofit Cloud certification. Prior hands-on experience posting transactions or running financial reports in Sage Intacct. Familiarity with nonprofit revenue-recognition rules (ASC 958). Work Environment & Physical Demands Typical office environment plus time in a secured count room/vault; prolonged periods at a computer workstation. Regular handling of currency and deposits; occasional lifting of up to 25 lbs. Some evenings/weekends during high-volume giving seasons or audit fieldwork Redemption Church is an equal-opportunity employer and welcomes candidates who reflect the diversity of our congregation and community. All offers of employment are contingent upon a background check Benefits Medical, Dental, Vision Accrued Vacation, and front-loaded Sick pay Retirement Plan Options Staff Appreciation Days with pay as provided by Leadership Flex Days as provided by

Leadership/ Supervisor Benefits:

Dental insurance Health insurance Paid time off Retirement plan Vision insurance

Work Location:

In person

Pay:

$20.00 - $24.00 per hour

Benefits:

Dental insurance Health insurance Paid sick time Paid time off Retirement plan Vision insurance

Work Location:

In person