Business Intelligence Developer
Zodiac Solutions, Inc
OBIEE Developer
Toronto, ON
skilled OBIEE Developer responsible for designing, developing, and maintaining business intelligence solutions using Oracle BI tools.
The role involves building dashboards, reports, and data models that support data-driven decision-making across the organization.
• Strong experience in: o OBIEE 11g/12co RPD modeling (Physical, BMM, Presentation layers)
- Expertise in Answers, Dashboards, and BI Publisher
- Strong SQL and database knowledge
• Design and develop OBIEE dashboards, reports, and scorecards
• Create interactive visualizations for business users
• Customize reports with filters, prompts, and drill-down capabilities RPD Development (Repository Design)
• Develop and maintain OBIEE Repository (RPD) including: Physical layero Business Model & Mapping (BMM) layero Presentation layer
• Implement logical schemas, joins, hierarchies, and aggregates Data Analysis & Modeling
• Translate business requirements into technical specifications
• Build and optimize data models for reporting and analytics
• Work closely with data warehouse and ETL teams Performance Tuning
• Optimize report performance and query execution
• Troubleshoot issues related to slow reports or data inconsistencies
• Implement caching and aggregate navigation Integration
• Integrate OBIEE with data sources (Oracle DB, SQL Server, flat files, etc.)
• Work with ETL tools (Informatica, DataStage, Talend) for data pipelines
• Support integration with other Oracle tools (e.g., ODI, OAC) Security & Governance
• Implement user authentication and authorization
• Manage data-level security (row-level, object-level)
• Ensure data governance and compliance policies are followed Testing & Deployment
• Perform unit testing, integration testing, and UAT support
• Handle deployments across environments (Dev, QA, Prod)
• Maintain version control of RPD and reports
Warm Regards,
Pooja Sehrawat
Assistant Manager Recruitment
Email: ***email_hidden***
