2,918 Oracle Bi jobs in the United States

• 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.
• bility 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 OBIEE architecture 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.

Collaborate with stakeholders to gather requirements and understand business needs for Oracle BI solutions.

Design and develop Oracle BI solutions, including data modeling, ETL processes, and creating reports and dashboards.

Provide technical leadership and guidance to project teams in the implementation and maintenance of Oracle.

• Collaborate with stakeholders to gather requirements and understand business needs for oracle bi solutions.
• Design and develop oracle bi solutions, including data modeling, etl processes, and creating reports and dashboards.
• Provide technical leadership and guidance to project teams in the implementation and maintenance of oracle bi solutions.
• Conduct performance tuning, troubleshooting, and optimization of oracle bi applications.
• Stay updated on oracle bi best practices, new features, and technologies to propose innovative solutions.
• Ensure the quality, security, and scalability of oracle bi solutions delivered to clients.

• 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 OBIEE architecture 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.
• Relevant OBIEE with ETL experience should be 6 to 12 years.
• Designing, developing, and maintaining Business Intelligence solutions using Oracle Business Intelligence Enterprise Edition (OBIEE).
• Requirements Gathering and Analysis of working with business stakeholders to understand reporting needs and translate them into technical specifications.
• Hands-on experience on OAS with Data Visualization (DV) for reporting solutions
• Experience in Data Warehouse Integration in managing the ETL pipelines that feed data into the OBIEE environment and should be able to resolve data discrepancy issues while tracing back thru ETL and source systems.
• Experience in end-to-end process from source system analysis via ETL to OBIEE deployments with data reconciliation and validation skills.

Good experience in Implementation of BI analytics using Oracle Analytics Cloud (OAC), Fusion Data Intelligence (FDI) and BI/DW Technologies

Job Requirements:

• 14+ years of experience in handling implementations of Oracle BI Apps or development of Custom Data Warehouse projects

• Experience in working with FDI, ODI MP, OAC

• Hands on experience in development and customizations for FDI, OAC, OBIA ODI and OBIEE

• Experience in working with Cloud HCM, Cloud ERP and PVO analysis for designing DWH

• Knowledge in integrating multiple data sources to load into Enterprise DWH

• OAC, OBIA, OBIEE, ODI Certifications are plus

• Have very good functional understanding of Oracle HCM, Financials, SCM, Procurement etc

• Worked in at least 6 to 10 full life-cycles of OAC implementations. OBIA implementation for modules like HR, Financial Analytics

Minimum Qualifications:

Fusion Analytics Warehouse (FAW), Oracle Analytics Cloud (OAC), Oracle Data Integrator(ODI), Oracle BI Applications (OBIA), Oracle BI, OAS, BIP, BIAPPS, PL/SQL,

• Consult with cross-functional teams to identify data and analytical needs.
• Gather necessary data from various sources, ensuring accuracy and completeness.
• Conduct detailed analyses using statistical methods and tools such as Oracle BI, Prophix Software , SQL Server, SAP Crystal Reports, and others as needed.
• Provide user-friendly avenues for sharing actionable data, including creating reports, dashboards, and visualizations.
• Review insights and findings with leadership to assist in decision-making processes.
• Facilitate related process and data improvement efforts based on analysis findings.
• Prepare regular monthly, quarterly, and annual statistical reports, as well as ad hoc reports as needed.
• Utilize written communication skills to draft persuasive requests, define problem areas, and prepare project evaluation reports.
• Identify and evaluate both concrete and abstract variables relevant to data analysis.
• Plan, coordinate, and initiate action necessary to implement recommendations derived from data analysis.
• Interact with personnel at all organizational levels, effectively communicating complex analytical findings.
• Manage multiple tasks simultaneously, prioritizing effectively to meet deadlines.
• Organize and oversee work, ensuring alignment with project objectives and timelines.

• 3+ years experience as a Data Analyst or similar role
• 2+ years experience with each of the following: Oracle Database, Oracle BI, SQL, Crystal Reports
• Experience with Prophix Software is highly desired (but not required)
• Bachelor's degree is preferred
• Proficiency in statistical analysis, data mining, building cubes, creating/writing reports, and data visualization techniques.
• Excellent written and verbal communication skills, with the ability to convey complex technical concepts to non-technical stakeholders.
• Strong interpersonal skills and the ability to interact effectively with individuals at all organizational levels.

• Competitive Compensation (base in the $110-145k range, dependent on experience)
• Fully Remote
• Paid Vacation Time
• Medical/Health/Dental Coverage
• 401K with company match
• Ongoing Training & Development
• Career Growth and Advancement Opportunities

*MUST be local to the Los Angeles area to work onsite Day One!
WILL consider a local hybrid schedule.

Duration: 12 months
Authorization: Any ( No h1b, cpt , opt)

* Must Have education domain experience *

Oracle BI Developer
Minimum of seven (7) years of demonstrated experience
REQUIREMENTS
a. Experience as a BI Developer for a school district, with a specialty in Oracle BI applications
b. Knowledge of RPD metadata i.e. customized analytics repository, designing physical layer, developing BMM and presentation layers, setting up LDAP Authentication and developing dynamic and interactive dashboards.
c. Experience managing ETL, and writing and deploying code for the LAUSD applications MyData, MyTeam, Central Office, CASE, Unified Enrollment Project, SchoolMint, or Student Survey.
d. Experience with the Oracle products OBIEE, OBIA, or Oracle BI Publisher.
e. Experience and knowledge in developing dimensional hierarchies, design data model to support multiple Enterprise Data Management reports.

C. DELIVERABLES
The proposed resource shall perform the following duties, including but not limited to: shall be provided at the request of the District. Specific duties will include the following:
a. Develop Oracle SQL queries and PL/SQL packages for the Unified Enrollment School Mint tool.
b. Analyze, troubleshoots, and identifies Oracle SQL and PL/SQL code bugs on Oracle database 12c or higher for the Unified Enrollment project
c. Analyze, troubleshoots, and identifies OBIEE report bugs for for MyData, MyTeam, Central Office, CASE
d. Develop new reports and dashboards for MyData, MyTeam, Central Office, CASE projects using OBIEE 12c
e. Enhance existing reports and dashboards using OBIEE 12c or higher for MyData, MyTeam, Central Office, CASE
f. Manage the OBIEE Web Catalog for MyData, MyTeam, Central Office, CASE
g. Training and/or knowledge transfer
h. Other duties as assigned

As a contractor on
this project, you will play a critical role in supporting the delivery of
reporting and analytics initiatives within a large-scale ERP transformation
program. Your primary responsibilities will include:

Collaborate daily
with both technical and functional teams to deliver reporting and analytics
epics and user stories.

Participate in daily
stand-ups and ongoing planning sessions with client business teams, both
virtually and during on-site visits (travel required).

Provide hands-onsupport in designing, developing, and validating reports, dashboards, and data
visualizations using tools such as:

o
Oracle Autonomous
Data Warehouse (ADW)

o
Oracle Analytics
Cloud (OAC)

o
Fusion Data
Intelligence (FDI)

o
Microsoft Excel
& PowerPoint

o
Jira for agile work tracking
•
Translate business
requirements into technical specifications and ensure successful implementation
of reporting solutions.
• Troubleshoot and resolve data or system issues related to reporting tools and platforms.

Document technical
and functional aspects of reporting solutions to support knowledge transfer and
continuity.

Qualifications: (necessities for background experience)

Preferred Qualifications:

1.
Proven experience
working in Oracle-based analytics environments.

2.
Familiarity with cloud-based
data warehouses and BI platforms.

3.
Strong communication
skills for engaging with client stakeholders in both remote and in-person
settings.

4.
Prior consulting or
contractor experience is a plus.

5.
Experience with
agile delivery methodologies and Jira is highly desirable.

• Oracle Analytics Cloud Service Developer and Python/PERL
• Manage client solution delivery, including defining project approach, leading and motivating project teams, monitoring and managing project risks, managing client and key stakeholders, and successfully delivering client solutions.
• 6+ Year experience