Senior Oracle Analytics Consultant (Financial Domain)

Datamatics Technologies

Key Responsibilities

• Design, develop, and maintain dashboards, reports, and analytical solutions using Oracle Analytics tools.
• Gather business requirements from finance and business stakeholders and translate them into technical solutions.
• Develop and maintain semantic models, datasets, KPIs, scorecards, and data visualizations.
• Build financial dashboards related to:
  • P&L Reporting
  • Budgeting & Forecasting
  • Revenue Analysis
  • Expense Tracking
  • Cash Flow Reporting
  • Financial Performance Metrics
  • Regulatory & Compliance Reporting
• Perform data extraction, transformation, and integration from ERP and financial systems.
• Optimize report performance, query tuning, and dashboard usability.
• Support UAT, troubleshooting, and production issue resolution.
• Collaborate with data engineers, ETL developers, finance teams, and project managers.
• Ensure data accuracy, governance, and reporting standards are maintained.
• Prepare technical documentation, solution designs, and user guides.
• Mentor junior consultants and provide technical guidance where required.

Required Skills & Expertise

Oracle Analytics & BI

• Oracle Analytics Cloud Must Have
• Oracle BI Publisher
• Oracle Data Visualization
• Oracle Analytics Server (OAS)

Database & Technical Skills

• SQL / PL-SQL
• Oracle Database
• Data Modeling
• ETL Concepts
• Performance Optimization
• Data Warehousing Concepts

Financial Domain Experience

Strong understanding of:

• Financial Reporting
• General Ledger (GL)
• Accounts Payable (AP)
• Accounts Receivable (AR)
• Fixed Assets
• Budgeting & Forecasting
• Financial Planning & Analysis (FP&A)
• Banking / Insurance / Financial Services Reporting