Oracle Analytics Architect (OAC)
Job Type: Full Time Employee Key Responsibilities
- Solution Architecture & Design: Lead the architectural design and implementation of enterprise-scale analytics solutions using Oracle Analytics Cloud (OAC) and Oracle Analytics Server (OAS) . Develop and maintain a strategic roadmap for the Oracle Analytics platform.
- ETL/ELT Development: Architect, design, and optimize complex data integration processes using Oracle Data Integrator (ODI) to support data warehousing and analytics requirements. Ensure data quality and integrity across all systems.
- BI Development & Modernization: Oversee the development and administration of the BI metadata layer (RPD), dashboards, and reports in OAC/OAS. Lead migration efforts from legacy platforms like Oracle Business Intelligence (OBIEE) to modern cloud-based solutions.
- Technical Leadership & Mentoring: Act as a subject matter expert for sales and delivery staff in the area of Oracle Analytics. Provide technical guidance, mentorship, and best practices to a team of developers, admins, and clients.
- Performance & Governance: Establish and enforce standards for development, performance tuning, and security across the analytics platform. Proactively identify and resolve complex technical issues.
- Stakeholder Collaboration: Work closely with business stakeholders, data scientists, and IT teams to translate business requirements into technical specifications and solution designs.
- Presales Support: Collaborate with the sales team and act as a technical specialist and expert in preparing project estimates and presales deliverables.
- Minimum of 10 years of progressive experience in designing, developing, and implementing Oracle Business Intelligence and Data Integration solutions.
- Expert-level knowledge and hands-on experience with Oracle Analytics Cloud (OAC) , including data visualization, machine learning, and administrative components.
- Extensive experience with Oracle Analytics Server (OAS) and Oracle Business Intelligence (OBIEE 11g/12c) , including RPD modeling, dashboard creation, and security implementation.
- Proven expertise in designing and developing complex ETL/ELT mappings, packages, and load plans using Oracle Data Integrator (ODI 11g/12c) .
- Strong understanding of data warehousing concepts, dimensional modeling (star/snowflake schemas), and BI architecture principles.
- Proficiency in SQL and PL/SQL with a deep understanding of Oracle Database performance tuning.
- Experience with migrating OBIEE environments to OAC or OAS.
- Knowledge of Oracle E-Business Suite (EBS) or other Oracle ERP systems and their underlying data structures.
- Experience with Fusion Data Intelligence (FAW)
- Experience with scripting languages such as Python or shell scripting for automation.
- Familiarity with cloud platforms (OCI, AWS, Azure, GCP) and their data services.
- Experience working with OCI Data Integration Cloud Service
- Excellent communication and leadership skills, with the ability to articulate complex technical concepts to non-technical audiences.
Bachelor's degree in computer science, Information Systems, Computer Information Systems or related field.
Recommended Jobs
Treatment Coordinator
Job Description Job Description Dearborn West Dental is looking for a highly motivated Treatment Coordinator with the right personality! The ideal candidate must be willing to work hard to gain…
Director of Social Services -$68,000+ per year!
Join the Wellbridge of Grand Blanc team! The Social Services Director oversees and directs the daily operations of the social services department. This position is responsible for leading effor…
Team Coordinator
Job Description Job Description Overview LANSING MALL LOVE TO TALK SPORTS? Dunham’s Sports, one of the largest full-line sporting goods chains in the U.S., was founded in 1937 as Dunh…
Founding Principal
Job Description Job Description Founding Principal (K-5) ABOUT US Founders Grove Classical Academy is a tuition-free public school that educates students through a virtues-based tradition …
Office Assistant
Job Description Job Description Position Description: Administrative AssistantJob DescriptionWe are a growing, fast-paced property management office seeking an office assistant at one of our prop…
Janitorial Cleaning
Job Description Job Description Salary: salaried Janitorial Cleaners needed. Part time Cleaning company looking for a reliable janitorial cleaner in Pontiac, MI part time. We are offering…
Entry Level Sales Representative ($20/hr or Commission)
Job Level: Entry Level Location: Novi, MI Shift: Flexible, minimum of 25hrs a week Division: Blue Raven Solar Sales Applicants must have access to a personal vehicle to be considered …
Showroom Manager
Job Description Job Description Showroom Manager Duties: Create and maintain a professional, welcoming experience for showroom customers Properly maintain showroom displays Maintain show…
Masking Associate-Afternoons
Looking for a Light Labor role in the Auto industry? We have the role for you! Nesco Resource is currently sourcing for General Labor Associates for an Automotive Finishing Facility in Dearbo…
Caregiver- 2nd Shift
We are looking for a compassionate Caregiver/CNA to join our growing team! The right candidate has a can-do attitude, a friendly demeanor, and the ability to provide many levels of support to our resi…