Business Systems Analyst – Level III

Spark Tek Inc

🇺🇸 United States

On-site

Staff / Principal

1 month ago

1 month ago

Not scoredNo CV on file. Upload one and this job gets a score out of 100.Upload CV

Role: Business Systems Analyst – Level III
Location: Santa Clara, CA
Duration: Contract

JD:
CPQ-to-BRIM Data Flow

Design and validate end-to-end usage data pipelines from Sales CRM (upstream contract and usage records) into BRIM Convergent Mediation, ensuring accurate billable-item creation and commitment-vs.-actual reconciliation
Convergent Mediation Configuration — Configure and troubleshoot
Work on integration with CI

Disposition & Invoice Execution

Manage billable-item disposition workflows: validate incoming disposition requests from Sales CRM, create or modify invoices, apply goodwill adjustments, split composite BITs, and ensure compliance with contract terms

Integration Testing Between CPQ and BRIM

Lead functional and technical testing across CPQ-to-Billing pipeline (willingness to learn and test, not expert-level required):
Validate event schema definitions and payload structure between Sales CRM and BRIM
Test bidirectional event flows: disposition requests → BRIM, BIT alerts → Sales CRM, invoice-created events → Sales CRM
Perform end-to-end event delivery testing, including timing, retry logic, and failure scenarios
Test threshold-based event triggers (e.g., (USD)25K outstanding-balance alert)
Validate data transformation and mapping logic in AEM or Business Technology Platform (BTP) adapters
Identify and document integration gaps or timing issue

Documentation & Runbooks

Create operational documentation covering data mappings, event schemas, failure-recovery procedures, escalation paths for commitment-related billing disputes, and integration test plans

Skills:
What you will need to be successful in this role:

3+ years with BRIM (specifically Convergent Mediation and Convergent Invoicing), with hands-on configuration of mediation rules, rating, invoice generation, disposition workflows, and goodwill handling
CPQ cycle expertise — Deep understanding of contract terms, commitment models, usage tracking, and overage scenarios (Salesforce CPQ, CPQ, or equivalent)
Integration testing willingness & knowledge — Experience testing data flows and event-driven integrations; comfort with test planning, test data setup, and validation scenarios. Knowledge of Advanced Event Mesh (AEM), Business Technology Platform (BTP), or similar integration platforms preferred (not expert-level required); openness to learn and improve integration skills on the job
Mediation & invoicing tables — Comfort querying BRIM data model (FKKBODP, FKKDI, FKKINV, contract-account tables, BIT tables) to validate mediation logic and reconcile data discrepancies
SQL — Ability to write queries to validate data transformations and troubleshoot billing issues
Communication — Ability to translate between business stakeholders (revenue, sales ops, finance) and technical teams; clear documentation of design decisions and trade-off

Must Have:

Good knowledge of Mediation configuration but not necessarily he will do hands on
Good knowledge of Convergent Invoicing configuration but not necessarily he will do hands on

Nice to Have:

Mediation rules and rating algorithms to transform raw usage records into billable items
Overage-event handlers and threshold-based pricing logic
Commitment burn-down calculations and proration rules (time-based, unit-based)
Data validation and exception handling for malformed usage records
Mediation job scheduling and batch processing parameters
Invoice template design, line-item logic, and aggregation rules
Tax determination and withholding configuration
Split and composite BIT handling for multi-tier commitments
Invoice document type mapping and number-range assignment
Goodwill adjustments, write-offs, and credit-note processing
Invoice status workflows and dunning/collection triggers

Business Systems Analyst – Level III · Spark Tek Inc