Telco Billing Data Analyst (Oracle SQL & Python)
Location: Atlanta, GA - On-site
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.
About Us:
AgreeYa is a global systems integrator delivering competitive advantage for its customers through software, solutions, and services. Established in 1999, AgreeYa is headquartered in Folsom, California, with a global footprint and a team of more than 1,850 staff across offices. AgreeYa works with 500+ organizations ranging from Fortune 100 firms to small and large businesses across industries such as Telecom, Banking, Financial Services & Insurance, Healthcare, Utility & Energy, Technology, Public sector, Pharma & Biotech, and others. Please visit us at Agreeya for more information.
AgreeYa is an equal opportunity employer. We evaluate qualified applicants without regard to race, color, religion, gender identity, sexual orientation, national origin, disability, veteran status or other protected characteristics. Visit our website to learn about our Career & Culture.