Oracle BI Lead Technical Consultant

TechDigital Group; Miami (FL); On-site; USD 90,000 - 130,000; Full time

Job summary

A leading company is seeking a Lead Consultant in Oracle BI to design, develop, and implement business intelligence solutions for clients. The role involves collaborating with stakeholders, developing reports and dashboards, and providing technical leadership to project teams, ensuring quality and scalability of delivered solutions.

Qualifications

• 6-10 years of relevant experience in Oracle BI.
• Experience in developing reports and dashboards.
• Ability to work independently or as part of a team.

Responsibilities

• Design, develop and implement Oracle BI solutions.
• Collaborate with stakeholders to gather requirements.
• Conduct performance tuning and optimization of BI applications.

Skills

Oracle BI technologies

Data modeling

ETL processes

Data visualization techniques

Performance tuning

Complex PL/SQL queries

Communication skills

Education

Bachelor's Degree in Computer Science

Tools

Oracle DB tools (TOAD, SQL Plus)

Job description

Job Summary
The Lead Consultant (Oracle BI) plays a crucial role in providing expertise and guidance in Oracle BI technologies to support business intelligence solutions for clients. The primary responsibility is to design, develop, and implement Oracle BI solutions that drive data driven decision-making and enhance overall business performance.
Key Responsibilities
1. Collaborate with stakeholders to gather requirements and understand business needs for oracle bi solutions.
2. Design and develop oracle bi solutions, including data modeling, etl processes, and creating reports and dashboards.
3. Provide technical leadership and guidance to project teams in the implementation and maintenance of oracle bi solutions.
4. Conduct performance tuning, troubleshooting, and optimization of oracle bi applications.
5. Stay updated on oracle bi best practices, new features, and technologies to propose innovative solutions.
6. Ensure the quality, security, and scalability of oracle bi solutions delivered to clients.

Skill Requirements

• Proficiency in Oracle BI technologies such as oracle business intelligence enterprise edition (OBIEE), Oracle BI publisher, and oracle analytics cloud.
• Strong knowledge of data modeling, ETL processes, and data visualization techniques.
• Experience in designing and developing reports, dashboards, and analytics using oracle bi tools.
• Ability to troubleshoot and optimize oracle bi applications for performance enhancements.
• Excellent communication and interpersonal skills to collaborate with stakeholders and project teams effectively.
• Experience in OBIEE RPD modeling, designing start/snowflake schemas
• OBIEE Expert with a thorough understanding of OBIEEarchitecture and the role of different OBIEE components like Analytic Server, Web Server, RPD, Web Catalog, Security, Dashboards, Reports, iBots and Scheduler
• Experience in writing and profiling complex PL/SQL queries and fetch appropriate data from huge data sets efficiently (Oracle)
• Experience in OBIEE Features (i.e. Cache, Usage tracking, Dimensional hierarchy, Variables/Initialization Blocks configuration etc.), converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, and Physical & Logical Data Modeling.
• Possess good communication, interpersonal skills, an ability to quickly grasp new concepts- both technical and business related. Flexible and experienced to work independently or in a team environment.
  

Education/Experience: Bachelor's Degree or equivalent in Computer Science, Information Systems or relatedfield and 6-10 years of relevant experience.
Specialization Domains: Supply Chain, Warehouse Management Distribution
Technologies: Oracle BI - OBIEE, Oracle Database tools like TOAD, SQL Plus and Oracle tools
Certifications: Oracle Business Intelligence certification is preferred but not mandatory.