Your Recently Viewed Jobs

Sr Analyst - Roaming Analyst (SQL Exp)

Sr Analyst - Roaming Analyst (SQL Exp)| Finance-and-accounting | Alpharetta, GA, USA

Send to a Friend Print


Responsibilities

Responsible for being the key reporting lead for all VZW global and domestic roaming analysis, roaming business cases and/or disputes, managing global rate plan violators, roaming PRL/PLMN trending, validation and analysis, and providing ad-hoc reporting to all levels of management.

Project Analysis:

Write advanced queries and manipulate large amounts of data to create end to end comprehensive financial analysis on inbound and outbound roaming traffic.

 

  1. Gather specific requirements and research criteria
  2. Identify the proper data fields and sources
  3. Write complex queries, using SQL, with the proper criteria, raw data, and applying conditions
  4. Rationalize results, compare to previous trends, draw conclusions, make recommendations based upon analysis
  5. Create comprehensive and level appropriate write-up of analysis
  6. Troubleshoot queries of other team members or departments
  7. Technical lead for Analytics & Monitoring team within Roaming Operations

Project Management:

Prepares daily, weekly or monthly trending of various roaming activities including (but not limited to) international financial roaming analysis by global roaming partner & device, unique roamer analysis and dashboard executive reports

 

  1. Identify domestic and global roaming activities
  2. Analyze demographics of customers (i.e. price plans and features, countries, etc) used to create roaming charges or OCC’s
  3. Create unique reports of wholesale roaming partner information
  4. Identify roaming volume/charge anomalies and send to appropriate departments for resolution
  5. Automate various reports needed on daily, weekly or monthly basis

Performance Management:

Functions as a Roaming Operations subject matter expert on cross-functional teams with projects of any degree of scope, and provides ad hoc analytical, operational or technical Revenue Assurance support to others.

 

  1. Lead meetings with cross functional key players to address issues
  2. Participate in resolution and the communication of action plans to cross-functional teams
  3. Involve Roaming Operations Project Manager and assist to gather requirements


Qualifications

Qualification

  • 4+ years with Verizon Wireless or the wireless industry required
  • 3+ years Advanced SQL coding (Teradata preferred) required
  • 3-5 years experience with reporting and analysis required
  • Proficiency in the Microsoft Office Suite required
  • Strong knowledge of the Data Warehouse required
  • Strong knowledge of VZW billing systems and related data systems such as MARS and REVO, along with Syniverse Analyzer, Roam Monitor and Visibility tools preferred
  • Excellent written and oral communication skills
  • Strong analytical and problem-solving skills
  • Strong time management skills
  • Proven project management skills
  • Ability to work cross-functionally with various departments within VZW including: Customer Service, national and area Marketing and Operations support organizations, Area Finance, and Network
  • Ability to work under pressure with strong attention to detail


Equal Employment Opportunity


We are an equal opportunity employer m/f/d/v.




We are an equal opportunity employer m/f/d/v.





Job ID: 341153

Like this career? Try these similar openings!