Description
Responsibilities:
- Assists in OBIEE administration, system maintenance, and upgrades
- Assists in the administration and implementation of BI system/system security
- Building geospatial reports/dashboards
- Builds OBIEE reports and dashboards using BI Publisher, Answers and Dashboards
- Close engagement with Enterprise Architects, Data Warehousing, Database, and Server Administration teams in collaborative design
- Configures Ad Hoc query and Reporting environments
- Deliver solid, scalable, robust BI reporting/analytic solutions
- Design, develop, and document OBIEE repository/metadata
- Develop, implement, and maintain data cubes, loading data, dimensions, calculating data and aggregation techniques
- Developing MS Office based content using Oracle Office tools
- Manage capacity and performance requirements
- Models, configures and optimizes the RPD/Universes from Data Warehouse (OLAP) and databases (OLTP)
- Perform unit, system and integration testing
- Prepare estimates of time for design and development
- Provide design and development mentorship/cross-training with fellow team members
- Troubleshooting and resolving technical issues with minimal user disruption
- Working in a team environment to develop reports and/or dashboards while working as a team member on an assigned project
- Works with business users to gather reporting/analytics requirements
Required Skills:
- 2+ years of experience with OBIEE Answers, Dashboards, and BI Publisher
- 2+ years of experience with star-schema, snowflake, FACT, and dimensional data modelling
- 4 year Bachelor's degree with preferred concentration in IT, data science, or business
- 5+ years of experience as an Oracle BI development using OBIEE with deep expertise in RDP design/development
- 5+ years of experience in writing PL/SQL, SQL*Plus, etc.
- 8+ years of IT development experience
- Ability to design reports in a logical, user friendly, and easy to understand format
- Ability to extrapolate business requirements, practices, and procedures
- Ability to meet deadlines and deliver high quality work products
- Ability to meet deadlines, results oriented
- Able to use complex expressions to calculate, group, filter, parameterize, optimize and format contents of reports/analytics
- Accountable for actions within OBIEE production environment
- Committed to ensuring data accuracy and quality within reports
- Complete working knowledge of OBIEE user, object and data security and caching capabilities.
- Demonstrated experience in designing, building, implementing, and deploying data universes/data models against Oracle and SQL Server databases
- Excellent communication skills
- Experience in data analysis, data profiling and validation
- Experience in producing test cases/scenarios
- Experience with Business Objects, Crystal Reports, and Reporting Services
- Experience with creating dashboards and performance metric based reporting
- Experience with deploying/upgrading BI systems
- High level of customer service
- Highly organized with the ability to multi-task
- Must be able to write technical documentation
- Must be skilled and experienced with graphical elements and filtered/layered reporting with drill down capabilities
- Understand how to use XML, and XSL for advanced report features and formatting
- Demonstrated experience in designing, building, implementing, and deploying enterprise reports, analytics, and dashboards
- Strong knowledge of RDBMS - MS SQL Server , Oracle 11g/12c
Desired Skills:
- Experience customizing BI reports using JSP, ASP, SDK
- Experience in BI security and server administration
- Experience with Crystal Reports and sub-reports
- Experience with Microsoft SharePoint
- Experience with Microsoft SSRS
- Knowledge of Oracle Financials (PeopleSoft), and Primavera/P6 Analytics, Human Resources (Time and Labor), and Learning Management