Sr. Reporting Developer (OAC Developer)

The Contact Center Reporting Developer will transform raw contact center data into meaningful insights by designing, developing, and optimizing real-time, historical, and operational reports. The role combines strong technical expertise, deep understanding of contact center metrics, and advanced reporting tool proficiency to enable data-driven decision-making across Oracle's global support ecosystem. You will architect reporting solutions, enhance ETL pipelines, and collaborate with stakeholders to build accurate, scalable, and highly reliable reporting systems.

Develop real-time dashboards and widgets focused on agent and queue performance for contact center operations.

Configure alerting and notification mechanisms based on real-time thresholds and operational triggers.

Build historical reporting solutions covering agent performance, queue activity, interaction journeys, and DNIS analysis.

Enhance datasets using call-attached data, KVPs, and custom statistical formulas to generate new performance metrics.

Implement data aggregation, drill-down capabilities, and multi-level time interval reporting (15-min, hourly, weekly, monthly).

Develop operational reports including inbound/outbound volumes, callback analysis, BU/LOB reporting, and agent-level insights.

Design and maintain ETL processes integrating vendor APIs with the enterprise data warehouse optimize SQL and data scripts.

Ensure accuracy, consistency, and quality of all reporting solutions through detailed testing and validation.

Provide technical leadership in evaluating reporting enhancements, recommending improvements, and troubleshooting data issues.

Bachelor's degree in Engineering/Technology (B.Tech/B.E.) or equivalent experience.

5+ years of hands-on experience in contact center reporting development.

Strong SQL skills and proficiency in scripting/programming for data manipulation and ETL workflows.

Expertise in building Real-time, Historical, and Operational reports within contact center environments.

Deep understanding of contact center metrics (ASA, AHT, Service Levels, queue performance, call flows).

Hands-on experience with Oracle Analytics Cloud (OAC) and Oracle Data Warehousing technologies (CDP, ODI).

Practical experience integrating vendor APIs into enterprise data warehouses and writing ETL scripts.

Strong analytical, debugging, and problem-solving skills for resolving data/reporting issues.

Excellent written and verbal communication skills for stakeholder interaction.

Experience with cloud platforms such as OCI, AWS, or Azure.

Familiarity with cloud-native data services and modern data pipelines.

Exposure to distributed systems, large-scale data platforms, or multi-tenant architectures.

Experience leading cross-functional efforts or delivering high-impact analytics projects.

Can I independently design and develop real-time, historical, and operational contact center reports with high accuracy

Do I have strong SQL and ETL development experience, including integrating APIs and manipulating large datasets

Am I familiar with contact center metrics, call flows, and the operational behavior of agent/queue performance

Have I worked hands-on with Oracle Analytics Cloud (OAC), Oracle Data Integrator (ODI), or similar reporting platforms

Can I troubleshoot data discrepancies and reporting issues effectively and communicate findings to business stakeholders

.

Career Level - IC4