Senior Systems Analyst - Support

•Work with business users and analysts to gather and understand reporting and analytical requirements.
•Translate business needs into technical specifications for OBIEE reports and dashboards.
•Develop and maintain the three-layer OBIEE repository 
•Design and optimize star/snowflake schema data models.
•Work closely with the ETL team to ensure the correct data is available for reporting.
•Perform data validation to maintain data accuracy and integrity.
•Design and develop interactive dashboards and ad-hoc reports in OBIEE.
•Implement KPI metrics, drill-downs, prompts, and filters for user-friendly reports.
•Optimize report performance by tuning queries and caching strategies.
•Implement row-level and object-level security for OBIEE users.
•Configure authentication and authorization using LDAP, Active Directory, or database authentication.
•Optimize OBIEE queries, reports, and dashboards for better performance.
•Troubleshoot reporting issues, RPD errors, and SQL performance bottlenecks.
•Monitor and tune the OBIEE environment for optimal efficiency.
•Work with the OBIEE Administrator for installations, upgrades, and patching.
•Deploy and migrate RPD files, reports, and dashboards across different environments (Dev, QA, Prod).
•Perform backup and recovery for OBIEE components.
•Maintain detailed documentation for RPD development, security models, and dashboard designs.
•Provide user training on self-service BI capabilities and dashboard navigation.
•Support end-users in troubleshooting and resolving report-related queries.

Career Level - IC3