Senior/Principal Analytics Engineer – CSS Delivery

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.

Career Level – IC5

What You Will Do:

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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.

What You Will Bring:

• Bachelor’s degree in Computer Science, Information Technology, or a related field. Master’s degree is a plus.
• Extensive experience (5+ years) working with Oracle OCI, OBIEE, ODI, BIApps, OAC, OAS, and Fusion Analytics Warehouse.
• Strong expertise in building, optimizing, and supporting analytics solutions in OCI.
• 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.
• Proficiency in Oracle SQL, PL/SQL, and data modelling concepts. 
• Have experience and in-depth understanding of Data Model and Business process functionality and its data flow in Oracle Business Intelligence Applications
• 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
• Have development experience in extending the out of the box OBIA code using Type-1, Type-2 customizations.
• Have experience of RPD modelling (All 3 layers) using the OBIEE Administration Tool
• Have experience in Report/Dashboard development using OBIEE
• Design & Development of ETLs using Informatica, Oracle Data Integrator either within the OBIA or standalone
• Design & Development of RPD/Reports/Dashboards using OBIEE
• Monitor the ODI or Informatica ETL Jobs and address any failures in a quick manner to ensure the Analytics data is current
• Monitor the OBIEE Agents and Report jobs and address any failures
• Develop and execute complex SQL queries to analyze data issues end to end
• Perform data validations from the OBIEE Reports to the respective Source systems and consolidate the data
• Knowledge of cloud-based analytics architectures, services, and best practices.
• Familiarity with data governance, security, and compliance requirements.
• Excellent problem-solving skills and ability to troubleshoot complex technical issues.
• Strong communication and interpersonal skills with the ability to collaborate effectively with cross-functional teams.
• Proven ability to work in a fast-paced environment, manage multiple priorities, and meet project deadlines.

Why work at Oracle

• A competitive salary with exciting benefits
• Flexible and remote working 
• Learning and development opportunities to advance your career
• An Employee Assistance Program to support your mental health
• Employee resource groups that champion our diverse communities
• Core benefits such as medical, life insurance, and access to retirement planning
• An inclusive culture that celebrates what makes you unique

Join our team and contribute to the success of our organization’s analytics initiatives through your expertise in building, optimizing, and supporting OCI-based analytics solutions using OBIEE, ODI, BIApps, OAC, OAS, Fusion Analytics Warehouse, and OCI services.

As a world leader in cloud solutions, Oracle uses tomorrow’s technology to tackle today’s problems. True innovation starts with diverse perspectives and various abilities and backgrounds.

When everyone’s voice is heard, we’re inspired to go beyond what’s been done before. It’s why we’re committed to expanding our inclusive workforce that promotes diverse insights and perspectives.

We’ve partnered with industry-leaders in almost every sector—and continue to thrive after 40+ years of change by operating with integrity.

Oracle careers open the door to global opportunities where work-life balance flourishes. We offer a highly competitive suite of employee benefits designed on the principles of parity and consistency. We put our people first with flexible medical, life insurance and retirement options. We also encourage employees to give back to their communities through our volunteer programs.

We’re committed to including people with disabilities at all stages of the employment process. If you require accessibility assistance or accommodation for a disability at any point, let us know by calling +1 888 404 2494, option one.

Disclaimer:

Oracle is an Equal Employment Opportunity Employer*. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability and protected veterans’ status, or any other characteristic protected by law. Oracle will consider for employment qualified applicants with arrest and conviction records pursuant to applicable law.

* Which includes being a United States Affirmative Action Employer