Senior/Principal Analytics Engineer - CSS Delivery

<p><span>We are seeking a highly skilled Oracle OCI OBl Analytics Engineer with expertise in building, optimizing, and supporting Analytics solutions in Oracle Cloud Infrastructure (OCI). As a key member of our team, you will be responsible for designing, implementing, and maintaining robust OCI-based analytics solutions. Your extensive experience with OBIEE, ODI, BIApps, OAC, OAS, Fusion Analytics Warehouse, and OCI in general will be instrumental in driving the success of our analytics initiatives and enabling data-driven decision-making.</span></p><p>Career Level - IC5</p> <p><span><strong>What You Will Do:</strong></span></p> <ul> <li><span>Solution Design and Development: Collaborate with cross-functional teams to understand business requirements and design end-to-end analytics solutions in OCI. Leverage your expertise in OBIEE, ODI, BIApps, OAC, OAS, Fusion Analytics Warehouse, and OCI services to architect scalable, performant, and reliable analytics solutions.</span></li> <li><span>Implementation and Optimization: Build and configure OCI-based analytics solutions, ensuring alignment with best practices and industry standards. Optimize performance by fine-tuning queries, implementing caching strategies, and designing efficient data models.</span></li> <li><span>Data Integration and Transformation: Work closely with data engineering teams to define and implement data integration workflows using ODI and other relevant tools. Ensure seamless extraction, transformation, and loading of data from various sources into the analytics environment.</span></li> <li><span>Production Support: Provide ongoing support for deployed analytics solutions, including troubleshooting and resolving issues related to data accuracy, system performance, and user access. Monitor system health, proactively identify, and resolve potential bottlenecks, and ensure high availability and reliability of the analytics environment.</span></li> <li><span>Security and Governance: Implement and enforce data security controls, ensuring compliance with regulatory requirements and industry standards. Develop and maintain data governance frameworks and policies to ensure data quality, integrity, and privacy within the analytics ecosystem.</span></li> <li><span>Collaboration and Knowledge Sharing: Collaborate effectively with stakeholders, including business users, data analysts, and IT teams, to understand requirements, gather feedback, and deliver high-quality solutions. Share knowledge and provide guidance to team members on OCI OBl Analytics best practices and emerging trends.</span></li> <li><span>Continuous Improvement: Stay up-to-date with the latest advancements in OCI services, analytics tools, and technologies. Evaluate new features and functionalities to identify opportunities for enhancing existing solutions and driving innovation.</span></li> </ul> <p> </p> <p><span><strong>What You Will Bring:</strong></span></p> <ul> <li><span>Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree is a plus.</span></li> <li><span>Extensive experience (5+ years) working with Oracle OCI, OBIEE, ODI, BIApps, OAC, OAS, and Fusion Analytics Warehouse.</span></li> <li><span>Strong expertise in building, optimizing, and supporting analytics solutions in OCI.</span></li> <li><span>Have hands-on experience in implementing/supporting Oracle Business Intelligence Applications for heterogeneous sources like EBS/Siebel/Taleo/Fusion Cloud. The functional modules should cover Financials, Manufacturing, Supply Chain, Procurement and Spend, Sales, etc.</span></li> <li><span>Proficiency in Oracle SQL, PL/SQL, and data modelling concepts. </span></li> <li><span>Have experience and in-depth understanding of Data Model and Business process functionality and its data flow in Oracle Business Intelligence Applications</span></li> <li><span>Solid understanding of data integration, ETL processes, and data warehousing principles. Experience in writing efficient and optimizing code and understanding of performance tuning techniques in the ETL tools used in OBIA such as Informatica and ODI</span></li> <li><span>Have development experience in extending the out of the box OBIA code using Type-1, Type-2 customizations.</span></li> <li><span>Have experience of RPD modelling (All 3 layers) using the OBIEE Administration Tool</span></li> <li><span>Have experience in Report/Dashboard development using OBIEE</span></li> <li><span>Design &amp; Development of ETLs using Informatica, Oracle Data Integrator either within the OBIA or standalone</span></li> <li><span>Design &amp; Development of RPD/Reports/Dashboards using OBIEE</span></li> <li><span>Monitor the ODI or Informatica ETL Jobs and address any failures in a quick manner to ensure the Analytics data is current</span></li> <li><span>Monitor the OBIEE Agents and Report jobs and address any failures</span></li> <li><span>Develop and execute complex SQL queries to analyze data issues end