We are seeking a Billing System Analyst for a contract position based in Atlanta, Georgia, with a duration of 6+ months. In this role, you will support the billing operations of a global telecommunications technology leader, working with production data to ensure billing accuracy, resolve discrepancies, and automate key analytical processes.
Responsibilities
Develop, optimize, and troubleshoot complex Oracle SQL queries, including joins, subqueries, CTEs, analytical functions, views, stored procedures, and PL/SQL.
Analyze large volumes of customer, billing, payment, usage, and transactional data to support billing accuracy and business insights.
Perform data reconciliation across multiple systems and identify discrepancies.
Conduct root-cause analysis for data and billing-related issues and support production investigations.
Optimize SQL queries for performance when working with large datasets.
Use Python for data extraction, cleansing, transformation, and validation.
Develop reusable Python scripts to automate recurring analytical and reconciliation activities, including operational reports and data-quality checks.
Work with Python libraries such as Pandas, NumPy, openpyxl, and Oracle database connectivity libraries.
Process large datasets from databases, CSV files, Excel files, and other structured sources.
Build utilities to compare datasets across different systems and identify mismatches.
Show the full description
Analyze customer accounts, billing transactions, charges, adjustments, payments, and billing events within the Ensemble Billing platform.
Investigate billing discrepancies and support reconciliation and validation after system or configuration changes.
Work closely with billing, operations, application, and business teams to resolve billing-related issues.
Support customer-impact analysis and understand end-to-end billing flows and dependencies between upstream and downstream systems.
Qualifications
Required
Advanced expertise in Oracle SQL, including complex queries, joins, subqueries, CTEs, analytical functions, views, stored procedures, and PL/SQL.
Query optimization and performance tuning expertise.
Python scripting proficiency with experience in Pandas, NumPy, and openpyxl.
Experience with data extraction, cleansing, transformation, and validation.
Process automation and large-scale data analysis capabilities.
Billing and transaction analysis experience.
Data mapping, reconciliation, discrepancy identification, and data integrity verification skills.
Root-cause analysis experience.
Experience with the Ensemble Billing platform.