Overview:The Lead Accounting Subject Matter Expert (SME) serves as the functional authority for accounting and financial business processes throughout the implementation. This individual will represent the Water Revenue Bureau's (WRB) Accounting Division during all phases of the project, including statement of work requirements, solution design, configuration, testing, data conversion, training, cutover planning, and post-go-live stabilization.
Work Activities:- Provide functional expertise regarding current Basis2 accounting processes and business rules
- Define and validate future-state accounting workflows and system functionality
- Review and validate functional requirements, design documents, configuration workbooks, and business process documentation
- Identify opportunities to standardize, streamline, and improve accounting processes while minimizing customizations
- Collaborate with Finance, Customer Service, Billing, Collections, Payment Operations, IT, and vendor implementation teams
- Participate in system configuration workshops and design sessions
- Validate accounting-related system configurations and ensure compliance with City accounting policies and governmental accounting standards
- Support data cleansing, data validation, and financial data conversion activities
- Validate current and future-state billing and revenue accounting processes
- Review billing transactions, revenue recognition, and financial impacts
- Validate billing adjustments, reversals, cancel/rebill processing, and account corrections
- Verify billing calculations, meter read impacts, and billing exception processing
- Ensure accounting requirements are accurately reflected in the configured solution
- Validate payment processing across all payment channels, including ACH, lockbox, credit/debit card, and electronic payments
- Review payment settlement and reconciliation processes
- Validate returned payments, reversals, refunds, and adjustment processing
- Verify daily balancing, settlement, and cash reconciliation functionality
- Validate payment processing interfaces and related financial transactions
- Validate customer accounts receivable balances and financial transactions
- Review processing for credits, refunds, write-offs, adjustments, and payment applications
- Validate collections-related accounting transactions and financial impacts
- Verify aging calculations, receivable balances, and financial reporting
- Ensure accounts receivable transactions are processed accurately throughout the customer lifecycle
- Validate General Ledger posting logic and accounting distributions
- Review Chart of Accounts mappings and financial transaction processing
- Verify journal entries and financial interface transactions
- Validate integrations between the CIS and enterprise financial systems
- Review month-end, year-end, reconciliation, and revenue reporting processes
- Validate accounting controls, audit requirements, and financial compliance
- Review segregation of duties and financial security requirements
- Verify system controls supporting accurate financial reporting
- Validate financial data integrity throughout accounting processes
- Identify accounting risks and recommend appropriate resolutions
Required Skills:- Candidates must possess extensive hands-on experience using the Basis2 Customer Information System within Water Revenue Bureau's accounting operations.
- Demonstrated expertise in water utility accounting processes
- Thorough understanding of customer billing and revenue accounting
- Strong knowledge of payment processing and settlement operations
- Experience with Accounts Receivable Accounting.
- Experience validating General Ledger postings and financial reconciliations
- Knowledge of governmental accounting principles and financial controls
- Experience interpreting accounting transactions and financial reporting
- Ability to analyze current business processes and identify improvement opportunities
- Ability to translate business requirements into functional system requirements
- Ability to evaluate proposed system functionality against operational needs
- Experience participating in cross-functional initiatives involving accounting, operations, and technology
Highly Desired:- Previous participation in CIS, ERP, billing, or financial system implementation
- Experience supporting system testing, including User Acceptance Testing
- Experience validating financial data conversions
- Knowledge of utility billing and customer information systems
- Experience working with system integrators or software vendors
- Familiarity with system interfaces, data migration, and reporting validation
- Bachelor's degree in Accounting, Finance, Business Administration, or a related field CPA or governmental accounting experience is a plus
Skills:Basis2 CIS,Utility Accounting,Customer Billing,Revenue Accounting,Accounts Receivable,Government Accounting