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 Oracles 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.

Bachelors degree in Engineering/Technology ( 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