TSQL Excel Power BI Salesforce

We are looking for a candidate who can ideally join us within the next 2 to 3 weeks. Given the tight timeline, it is imperative that we identify suitable candidates as soon as possible. Job Title: Salesforce-business/Functional Analysis Job Role:...

We are looking for a candidate who can ideally join us within the next 2 to 3 weeks. Given the tight timeline, it is imperative that we identify suitable candidates as soon as possible.


Job Title: Salesforce-business/Functional Analysis

Job Role: Billing Analyst with Financial Data and Business Analysis skills

Location: Madrid, Spain (preferred)

Duration: Full-Time employment

Language: English (Written and Spoken)


About and Responsibilities:

The Billing Models Catalog Business Analyst should possess critical thinking and strong numerical analysis skills to evaluate data from multiple sources (Qlik, Excel, PowerBI, SAP).


Their main responsibility is to assist in creating the billing models catalog by:

  • Reviewing and analyzing revenue files for billing calculations
  • Translating file details into inputs suitable for automation
  • Identifying rules and patterns within billing calculations
  • Collaborating with the Center of Excellence (CoE) to draft and implement rule automation solutions (e.g., creating Change Requests, developing macros in Excel, or utilizing Microsoft Power Platform)


Additional Information:

A business analyst working with a billing model catalog focuses on understanding, documenting, and improving how a company charges its customers for services. This involves analyzing existing billing systems, identifying areas for improvement, and potentially designing or implementing new billing models or features. They work with various billing models, including subscription, usage-based, tiered, and hybrid models.

The Revenue Data Analyst will interpret data from multiple systems to provide actionable insights for businesses working with the Revenue Operation Management team. They will collect, process, and analyze large datasets to identify trends, patterns, and anomalies, helping organizations make informed decisions.

RevOps and Rev Management are responsible for billing governance from Order-to-Cash process - invoicing, product pricing, payments, data reporting, forecasting etc.


Activities to Perform:

  • Collaborating with multiple departments from legal, contract, commercial, financial teams including potential vendors to understand payment invoicing, contracting data and contracts
  • Conducting root cause analysis and contributing to simplifying the management for contracts and payment invoicing documentation etc.
  • Making recommendations on supporting the team to standardize billing models and automate
  • Collaborating with multiple geographies in aligning, managing, and controlling financial requirements and working with multiple financial platforms and Excels
  • Conducting in-depth analysis of data, errors, and identifying possible savings within invoices and financial control analysis
  • Managing various billing and finance projects focused on Accounts Payable Automation and Invoice Automation. This includes coordinating and controlling the timely and accurate workflow of invoices
  • Collaborating with Region and Vendor Managers to set monthly, quarterly, and yearly forecasts, ensuring the invoicing approval aligns with the monthly results reported
  • Overseeing the accurate workflow of invoices, budget control, and budget closing for international vendors. Creating and tracking the annual budget, collaborating closely with the vendor management team.


Skills Required:

  • Proficiency with databases (Excel, Power BI, Qlik, SAP)
  • Experience in data extraction, interpretation, management, and modeling
  • Data Analysis: Analyzing billing data to identify trends, patterns, and areas for improvement.
  • Billing Process Knowledge: Understanding the intricacies of billing models, including pricing, invoicing, and payment processing.
  • SQL: Querying and manipulating data in databases to extract necessary information for analysis. SQL and technical database background (e.g., Qlik, SAP)
  • Excel: Creating spreadsheets, performing calculations, and visualizing data for reporting and analysis.
  • Understanding of Billing Systems: Familiarity with the software and platforms used for billing and invoicing – Preferred Excel, Qlik, SAP, PowerBI
  • Requirements Gathering: Eliciting and documenting detailed billing requirements from stakeholders.
  • Testing and Validation: Ensuring the accuracy and functionality of billing systems and processes
  • Communication: Clearly explaining complex billing information to both technical and non-technical audiences.
  • Problem-Solving: Identifying and resolving billing discrepancies and issues.
  • Analytical Thinking: Interpreting financial data and identifying trends in payment behavior.
  • Attention to Detail: Essential for accurate invoice processing and payment application.
  • Time Management: Meeting strict billing deadlines and managing multiple billing cycles.
  • Collaboration: Working effectively with sales, operations, and finance teams.
  • Customer Service Orientation: Addressing customer billing inquiries and maintaining positive relationships.
  • Adaptability: Adjusting to changes in billing systems, policies, or regulations.

No et perdis res!

Uneix-te a la comunitat de wijobs i rep per email les millors ofertes d'ocupació


Mai no compartirem el teu email amb ningú i no t'enviarem correu brossa

Subscriu-te ara

Darreres ofertes d'ocupació de Analista de Negoci a Madrid

IRIUM

Madrid, ES

🚀 En IRIUM nos preocupamos porque no dejes de perseguir tus sueños. Prepárate para conquistar tus metas, y ten siempre...

AGNIA

Leganés, ES

Acerca de Agnia AgrocapitalEmpresa líder en la distribución de maquinaria agrícola con facturación superior a €60...

Business Analyst

29 de jul.

Orbis Group

Madrid, ES

Job Title: Murex Market Risk Business Analyst Location: Madrid - 2-3 dyas/week onsite Contract Type: Initial 6 month...

Kimberly-Clark

Madrid, ES

Job Description Your Job You’re not the person who will settle for just any role. Neither are we. Because we’re out to...

Page Executive

Madrid, ES

Holding empresarial diversificado Rol liderazgo financiero About Our Client Holding empresarial de orígen familiar. Job...

IRIUM

Madrid, ES

🚀 En IRIUM nos preocupamos porque no dejes de perseguir tus sueños. Prepárate para conquistar tus metas, y ten siempre...

Business Analyst

29 de jul.

Capgemini

Madrid, ES

Elegir Capgemini es elegir la posibilidad de dar forma a tu carrera profesional como desees. Recibirás el apoyo y la...

CONFIDENCIAL

Madrid, ES

¿Te motiva trabajar en una posición financiera con impacto real en decisiones estratégicas y contacto directo con...

Sopra Steria

Madrid, ES

Descripción de la empresa Porque trabajar en Sopra Steria, también es sentir Sopra Steria. Somos un reconocido líder...

Alliance Automotive Group Iberia

Torrejón de Ardoz, ES

¿Te apasiona el análisis de datos y quieres tener un impacto directo en la estrategia comercial de una compañía líder en...