Oracle BI ERP Specialist

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

Job summary

A leading technology firm in Miami is seeking a Senior ERP Specialist proficient in Oracle Business Intelligence. The role involves designing and implementing ERP solutions, optimizing data models, and ensuring accuracy within data systems. Ideal candidates will possess in-depth knowledge of Oracle BI, along with experience in collaboration across teams. The position also seeks strong analytical capabilities and problem-solving skills to address data challenges effectively. Certification in Oracle BI is preferred, adding further value to your application.

Qualifications

• In-depth knowledge of Oracle Business Intelligence tools and technologies.
• Experience in designing and optimizing data models for BI reporting.
• Strong analytical and problem-solving skills.

Responsibilities

• Designing and implementing Oracle BI solutions within the ERP system.
• Developing and maintaining data models to support BI reporting.
• Collaborating with cross-functional teams to gather requirements.

Skills

Oracle Business Intelligence tools

Oracle ERP systems

Data warehousing concepts

Data model design

Stakeholder collaboration

Analytical mindset

Communication skills

SQL queries

PLSQL queries

Tools

OBIEE

ETL tools

OAS

S4HANA

Job description

The Senior ERP Specialist with expertise in Oracle BI will be responsible for designing, developing, implementing, and maintaining ERP solutions, particularly focusing on Oracle Business Intelligence. The role involves optimizing data models, enhancing reporting capabilities, and ensuring the ERP system meets the organization's business requirements efficiently.

Key Responsibilities

• Designing and implementing oracle bi solutions within the erp system.
• Developing and maintaining data models to support bi reporting.
• Optimizing bi dashboards and reports for performance and usability.
• Collaborating with cross functional teams to gather requirements for bi solutions.
• Providing technical support and troubleshooting for bi tools and applications.
• Ensuring data accuracy and integrity within the ERP system.
• Keeping abreast of industry trends and best practices in oracle bi to recommend improvements.

Skill Requirements

• In-depth knowledge of oracle business intelligence tools and technologies.
• Proficiency in Oracle ERP systems and modules.
• Strong understanding of data warehousing concepts and methodologies.
• Experience in designing and optimizing data models for bi reporting.
• Ability to collaborate effectively with different teams and stakeholders.
• Analytical mindset with problem-solving skills.
• Excellent communication and presentation abilities.

Certifications: Oracle BI certification is preferred but not mandatory.

Primary Skill OBIEE senior profile with exposure to SAP

• In depth understanding of SAP modules SD, MM, FICOPS.
• Good understanding of end to end business process in O2C, P2P, PL2PRC2R including S4HANA tables reports in these process.
• Should be able to understand customization in S4 system including custom tables, CDS views reports.
• Should have good understanding of data structures, data analysis data reconciliation methods in S4 system
• Requirements Gathering and Analysis of working with business stakeholders to understand reporting needs and translate them into technical specifications.
• Experience on OAS with DV Data Visualization skills and able to handle complex business logics.
• Experience in Data Warehouse Integration with ETL knowledge 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 to OBIEE deployments with data reconciliation and validation skills.
• Designing, developing, and maintaining Business Intelligence solutions using Oracle Business Intelligence Enterprise Edition OBIEE).
• Proficiency in writing SQL queries for data extraction and manipulation.
• Strong analytical and problem solving skills to identify and resolve data related issues.
• 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 PLSQL 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 Snowflake 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.