Senior Director of Business Intelligence and AI Analytics (Nashville, TN)

Oracle•Nashville, TN

1d•$169,800 - $355,400

About The Position

Oracle’s Global Program Controls organization provides governance, reporting, controls processes, cost management support, and portfolio visibility for global data center programs. The Senior Director of Business Intelligence and AI Analytics will build and deploy dashboards, reports, and AI-enabled analytics that help senior leaders understand operational performance, identify risks, and make informed decisions. Building on an established database foundation and data governance processes, this hands-on technical leader will turn trusted data into reliable reporting products. The role integrates information from Oracle Primavera Cloud (OPC), Oracle Primavera Unifier, Oracle APEX applications, and their underlying data sources. The successful candidate will personally write queries, develop reporting models, build dashboards, connect systems, and deploy solutions into production, while establishing reporting priorities and technical standards in partnership with business leaders, system owners, and technical teams. The position carries substantial technical ownership and may operate as a senior individual contributor leading cross-functional delivery. The role combines technical execution with analytical judgment and clear communication. The candidate will investigate discrepancies in underlying data, explain their business significance, and deliver accurate, concise insights for executives. They will own reporting products through requirements, development, testing, deployment, adoption, and maintenance; ensure data integrity and reliability; apply AI models to practical reporting needs; and help users and leaders make decisions based on dependable information. Within the first year, the successful candidate is expected to deliver prioritized production dashboards and reports using OPC, Unifier, and APEX-related data; establish reporting that executives and operational teams use regularly; reduce manual reporting effort and recurring reconciliation issues; demonstrate measurable value from selected AI workflows; and ensure solutions are documented, maintainable, supported, and accompanied by user training.

Requirements

Approximately 8–12 or more years of relevant experience in business intelligence, analytics engineering, data engineering, technical analytics, or a related discipline, with demonstrated ownership of complex reporting solutions.
Advanced SQL skills and hands-on experience with relational databases, data modeling, data transformation, and query optimization.
Demonstrated ability to independently build, publish, and maintain production dashboards using an enterprise platform such as Oracle Analytics, Power BI, Tableau, or an equivalent tool.
Proficiency in Python or a comparable programming language for data preparation, API integration, analytical automation, and troubleshooting.
Practical experience working with AI models and integrating them into analytical or business workflows, including evaluating outputs against source data.
Experience extracting and combining enterprise application data through APIs, database connections, or automated integration processes.
Strong understanding of metric definitions, reporting granularity, reconciliation, data quality, and access controls.
Ability to translate ambiguous business needs into working technical solutions and explain findings clearly to senior executives.
Proven ability to lead cross-functional delivery with limited oversight, sound judgment, and persistent follow-through.

Nice To Haves

Direct experience with Oracle Primavera Cloud, Oracle Primavera Unifier, or Oracle APEX, including their data structures, reporting, or integration capabilities.
Experience with Oracle Database, PL/SQL, Oracle Analytics, or developing reporting functionality within APEX.
Experience with project controls, schedule and milestone reporting, capital projects, or portfolio analytics.
Experience deploying AI workflows that retrieve approved enterprise information and provide traceable answers or summaries.
Familiarity with data center operations, construction, infrastructure deployment, hardware validation, or commissioning.
Experience setting technical standards, mentoring developers or analysts, or directing vendor delivery.

Responsibilities

Design, build, and deploy executive and operational dashboards showing schedules, milestones, delivery progress, dependencies, and emerging risks.
Translate business questions into metrics, data requirements, reporting logic, and intuitive visualizations with useful filters and drill-down capabilities.
Develop reusable datasets, SQL queries, and reporting models that support multiple dashboards and reduce manual report preparation.
Own reporting solutions through requirements gathering, development, testing, deployment, user adoption, and ongoing maintenance.
Connect OPC, Unifier, and APEX-related data through supported APIs, database views, approved extracts, or existing integration pipelines, coordinating with system owners on the appropriate approach.
Reconcile project identifiers, reporting periods, status definitions, and data granularity across systems to maintain accurate and meaningful combined reports.
Build or extend automated data transformations and refresh workflows; investigate failed loads, stale data, and integration issues with appropriate technical teams.
Apply AI models, including large language models where appropriate, to reporting needs such as summarizing operational updates, explaining variances, and helping users explore approved data.
Use Python, model APIs, and other appropriate tools to prototype, evaluate, and deploy repeatable analytical workflows.
Ground AI-generated insights in verifiable source data, test output quality against representative examples, and establish human review where needed.
Assess AI model accuracy, reliability, cost, and business usefulness before expanding solutions; protect confidential information using approved tools and access controls.
Use AI-assisted development effectively while independently reviewing and testing generated code, queries, calculations, and conclusions.
Maintain documented metric definitions, calculation rules, source mappings, ownership, and data lineage, building on existing governance processes.
Validate dashboard results against source systems and approved business definitions before release, and make refresh timing and data limitations visible to users.
Implement appropriate access controls, version control, release documentation, and monitoring so reporting products remain secure and supportable.
Optimize query and dashboard performance, resolve defects, and work with data owners to address recurring data-quality issues at their source.
Work with executives and operational leaders to identify decisions reporting must support and prioritize a practical delivery roadmap.
Present the most important insights, risks, and actions with sufficient supporting detail to answer follow-up questions.
Develop working fluency in data center operations, infrastructure deployment, hardware testing, commissioning, and server turn-up to interpret operational information accurately.
Lead cross-functional delivery with clear owners, milestones, and follow-through; provide technical direction to internal partners or vendors as needed.
Train users, gather feedback, and improve reporting products based on actual use and changing business needs.