Technical Consultant (Oracle Orbit Analytics and Data Modelling)

Syntricate Technologies

Cleveland, OH

Apply

JOB DETAILS

JOB TYPE

Full-time

SKILLS

Acceptance Testing, Analysis Skills, Best Practices, Business Intelligence, Cloud Computing, Communication Skills, Data Analysis, Data Modeling, Data Processing, Data Quality, Data Visualization, Data Visualization Tools, Data Warehousing, Database Administration, Database Extract Transform and Load (ETL), Documentation, ERP (Enterprise Resource Planning), Help Desk, Interpersonal Skills, Multitasking, Oracle, Oracle Discoverer, Oracle ERP, Oracle Fusion Middleware, Oracle PL-SQL, Oracle Reports, Performance Tuning/Optimization, Project/Program Management, Quality Assurance, Reporting Dashboards, SQL (Structured Query Language), SQL Databases, Securities, System Migration, Technical Consulting, Technical Leadership, Test Plan/Schedule, Testing, Training/Teaching, Unit Test, Willing to Travel

LOCATION

Cleveland, OH

POSTED

30+ days ago

Position: Technical Consultant (Oracle Orbit Analytics and Data Modelling) Location: Cleveland, OH (REMOTE Occasional Onsite Travel Required ) Duration: 12+ Months Contract (potential for extension) JOB DESCRIPTION: Our Client seeks an Oracle Orbit Analytics and Data Modelling Technical Consultant. Must Have: BI / Data Warehousing / Analytics (5+ years) Oracle Technical Consultant Oracle Orbit Analytics Data Modelling Oracle Discoverer Oracle R12 ERP Oracle Fusion Cloud ETL Processes Data Visualization TOP THREE SKILLS: Proven experience with Oracle Discoverer and Orbit Analytics. Extensive experience with Oracle R12 ERP and Oracle Fusion Cloud. At least 5 years of experience in business intelligence and data analytics. Demonstrated success in leading migration projects. FULL SKILL LIST: Strong proficiency in SQL, PL/SQL, and database management. Expertise in Orbit Analytics, Oracle Discoverer, Oracle R12 ERP, and Oracle Fusion Cloud. Familiarity with ETL processes and data warehousing concepts. Experience with data visualization tools and techniques. RESPONSIBILITIES: Develop a comprehensive migration plan from Oracle Discoverer to Orbit Analytics. Analyze current Oracle Discoverer reports and dashboards to identify migration requirements. Design and implement solutions to migrate reports, dashboards, and data models to Orbit Analytics. Handle all aspects of development: Understand requirements. Use or collaborate on existing data models. Build reports. Conduct technical unit testing and quality assurance testing before UAT deployment. Provide technical leadership throughout the migration process. Ensure data integrity, accuracy, and consistency during migration. Optimize performance in the new Orbit Analytics environment. Leverage knowledge of Oracle R12 ERP and Oracle Fusion Cloud table structures. Ensure seamless integration of Oracle R12 ERP and Oracle Fusion Cloud data into Orbit Analytics. Collaborate with ERP and cloud teams to address data requirements and challenges. Work with business users to meet their reporting needs post-migration. Conduct training sessions and create supporting documentation for end-users. Communicate progress, challenges, and solutions to stakeholders. Develop and execute test plans to validate migrated reports and dashboards. Resolve any migration-related issues and conduct post-migration reviews. Stay informed on new Orbit Analytics features and best practices. Identify opportunities for further optimization and enhancement. Provide ongoing support and maintenance post-migration. OTHER POINTS: Requirements: Expertise in building complex physical and logical data models. Deep understanding of data modeling concepts and joins (normal, complex, circular). Strong knowledge of object- and data-level securities, roles, and responsibilities. Proficiency in building complex Orbit Analytics reports with calculation measures and report insights. Soft Skills: Strong problem-solving and analytical skills. Excellent communication and interpersonal abilities. Ability to work independently and within a team. Project management skills for handling multiple priorities.

About the Company

Syntricate Technologies

Resume Resources

Free Resume Templates Free Resume Builder