Ofertes d'ocupació a G&L Consulting

• Nivell d'experiència---
• Tipus de contracteA temps complert
• PublicadaNova

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: 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.