Oracle Analytics Consultant

Position Name: Oracle Analytics Consultant
Location: india (Remote)
Experience: 8+years

About BinQle
BinQle is a global delivery and execution partner supporting enterprises across the US, India, Singapore and Australia. We specialize in structured hiring, managed teams, and long-term delivery support.

Role Summary:
Lead the end-to-end migration of legacy Microsoft Access and Oracle reporting solutions into modern platforms, including Oracle Analytics Server (OAS), BI Publisher, and Python automation. Responsible for assessing current state, designing target architecture, executing migration, and supporting post-implementation activities.

What Youll Do:

• Inventory and assess existing Microsoft Access databases, queries, macros, and reports
• Document current reporting processes, dependencies, and data lineage
• Map and migrate Access components to Oracle Analytics Server, BI Publisher, or Python solutions
• Develop and tune Oracle SQL, PL/SQL, views, and procedures for reporting workloads
• Convert business logic from Access/VBA to Oracle SQL, PL/SQL, or Python
• Build OAS dashboards, analyses, and BI Publisher reports with interactive and parameterized features
• Design and implement Python-based reporting and automation using relevant libraries
• Ensure secure database connectivity and adherence to access controls
• Conduct comprehensive testing, prepare deployment plans, and support production rollout
• Provide knowledge transfer and documentation for support and business teams
• Support post-implementation stabilization and performance tuning

What We re Looking For (Must-Haves):

• Experience with Microsoft Access databases, linked Oracle tables, macros, VBA, forms, and reports
• Proficiency in Oracle SQL, PL/SQL, views, materialized views, and performance tuning
• Hands-on experience with Oracle Analytics Server (OAS) dashboards, analyses, and security models
• Experience developing BI Publisher data models, templates, and scheduling outputs
• Strong Python skills, including use of pandas, oracledb/cx_Oracle, SQLAlchemy, openpyxl, XlsxWriter, and logging frameworks
• Familiarity with DevOps tools such as Git, Azure DevOps/GitHub, and CI/CD concepts
• Ability to work independently with business, DBA, infrastructure, security, and reporting teams

Good to Have (Optional - only if mentioned):

• Experience in financial services or other controlled enterprise environments

Qualifications:
As per requirement

Disclaimer: This job posting and Location has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.