Oracle Developer- OBIEE

Job Role: Oracle Analytics Developer (OBIEE Developer) Location: Charlotte, NC(Need Local for Onsite) Job Type: Longterm Contract Job Description: We are seeking a highly skilled Oracle Analytics Developer (OBIEE Developer) to design, develop, and optimize analytical and data warehousing solutions. The ideal candidate will have strong hands-on experience in Oracle PL/SQL, data modeling, ETL frameworks, and BI dashboard development using Oracle Analytics Cloud (OAC) or OBIEE. This role requires a deep understanding of data performance tuning, large-scale data integration, and Agile development methodologies. Key Responsibilities: • Data Design & Modeling: • Design conceptual, logical, and physical data models to support enterprise data warehousing and reporting needs. • Ensure models align with business requirements and scalability standards. • Oracle PL/SQL & Performance Tuning: • Develop complex PL/SQL scripts, procedures, and packages. • Analyze Oracle AWR reports and optimize queries, indexes, and partitions for performance improvements. • ETL Development: • Build robust and scalable ETL data frameworks with advanced error handling and automation capabilities. • Integrate data from multiple sources to support analytics and reporting. • Analytics Development: • Design and develop dashboards, reports, and visualizations using OBIEE, Oracle Analytics Cloud (OAC), and BI Publisher. • Work closely with business users to translate requirements into actionable insights. • Integration & Testing: • Ensure seamless integration of developed solutions into existing systems. • Contribute to unit, integration, and regression testing. • Agile & CI/CD Collaboration: • Participate in Agile ceremonies (sprint planning, story refinement, retrospectives). • Support CI/CD pipelines and version-controlled deployments. • Problem Solving & Communication: • Troubleshoot and resolve complex technical issues. • Communicate technical concepts clearly to stakeholders and cross-functional teams. Required Skills & Experience: • 7+ years of experience in Oracle Analytics, BI, or Data Engineering. • Strong expertise in Oracle SQL and PL/SQL development. • Hands-on experience with OBIEE / Oracle Analytics Cloud (OAC) and BI Publisher. • Solid understanding of data warehousing concepts, including CDC, indexing, partitioning, and data virtualization. • Experience with ETL design and development. • Proficiency in Unix/KSH shell scripting and familiarity with Python for data automation. • Experience working in Agile/Scrum environments. • Strong analytical, problem-solving, and communication skills. Preferred Qualifications: • Experience with performance tuning using AWR reports. • Exposure to CI/CD tools and automated testing frameworks. • Prior experience in large-scale enterprise data environments.