Back to Jobs
Recently postedTechnology

Telco Billing Data Analyst

Zenith System Solutions IncAtlanta, GA🇺🇸United States

Quick overview

SeniorityMid Senior
Work modeHybrid
LocationAtlanta, GA, United States
OraclePL/SQLSQLMicrosoft ExcelNumPyPandasPythonData Analysis

Job description

Oracle SQL & Data Analysis

· Develop, optimize, and troubleshoot complex Oracle SQL queries.

· Analyze large volumes of customer, billing, payment, usage, and transactional data.

· Work with joins, subqueries, CTEs, analytical functions, views, stored procedures, and PL/SQL where required.

· Perform data reconciliation across multiple systems and identify discrepancies.

· Conduct root-cause analysis for data and billing-related issues.

· Support production investigations and customer-impact analysis.

· Optimize SQL queries for performance when working with large datasets.

·

Python & Automation

· Use Python for data extraction, cleansing, transformation, validation, and analysis.

· Develop reusable scripts to automate recurring analytical and reconciliation activities.

· Work with libraries such as Pandas, NumPy, openpyxl, and Oracle database connectivity libraries.

· Process large datasets from databases, CSV files, Excel files, and other structured sources.

· Automate operational reports and data-quality checks.

· Build utilities to compare datasets across different systems and identify mismatches.

·

Ensemble Billing

· Strong understanding of Ensemble Billing and associated billing processes.

· Analyze customer accounts, billing transactions, charges, adjustments, payments, and billing events.

· Investigate billing discrepancies and support root-cause analysis.

· Understand end-to-end billing flows and dependencies between upstream/downstream systems.

· Support billing reconciliation and validation after system or configuration changes.

· Work closely with billing, operations, application, and business teams to resolve billing-related issues

Will your resume get past this employer's screening? Check your resume against this job, free

Similar jobs