TC
Oracle BI ERP Specialist
TechDigital Corporation
- 🇺🇸 United States
- On-site
- Senior
- 9 months ago
- ERP
- Oracle
- Oracle ERP
- SAP
- S/4HANA
- Data Visualization
- ETL
- SQL
- Snowflake
- PL/SQL
- Data Modeling
9 months ago
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.
Additional requirement:
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.
Oracle BI ERP Specialist · TechDigital Corporation