| Job Information |
BI Developer-OBIEE
Job Description
The role of the Business Intelligence Developer is to develop and maintain Client’s Business Intelligence Applications by providing technical solutions in support of business objectives and ongoing operations. Must be able to utilize and effectively communicate technical components of an initiative to applicable parties.
Responsibilities:
The Business Intelligence Developer will be responsible for development and maintenance activities of the business intelligence applications for CLIENT’s enterprise data warehouse. Other responsibilities include, but are not limited to:
- Collaborate with business users to capture & define business requirements and then contribute to defining the appropriate data warehouse BI solution
- Design, develop and implement OBIEE metadata/logical data models
- Design, develop and implement complex OBIEE user interface objects (e.g. reports, analytics, ad-hoc queries, dashboards, etc.)
- Determine whether measure calculations and processing should be done in ETL or metadata
- Determine requirements for aggregate tables
- Design and support OBIEE security model
- Develop technical design documents and BI specifications that incorporate OBIEE development standards & best practices
- Provide day to day production support of data warehouse BI environment
- Troubleshoot performance issues of OBIEE environment and evaluate existing logic for tuning possibilities
- Provide production support for existing BI systems and work on new BI development initiatives simultaneously
Responsibilities may change and additional responsibilities may be required as deemed necessary by CLIENT management.
Qualifications
Required Skills/ Experience:
- 5+ years’ experience developing Business Intelligence solutions using Oracle’s OBIEE product suite
- Familiarity with implementing Oracle Business Intelligence (OBIEE) custom data warehouse solutions and pre-built BI analytics
- Strong technical knowledge of OBIEE admin/metadata tools, security, user interface designs, development and deployment of dashboards, analytics and performance management reports
- Ability to design logical and multi-dimensional data models
- Ability to design and develop BI Metadata Repository and identify areas of optimization
- Ability to design, build, deploy and support end to end BI solutions
- Advanced knowledge of data warehouse development and maintenance lifecycle and methodology
- Strong PL/SQL and SQL development and performance tuning skills
- Experience with Oracle DBMS preferably Oracle 10g/11g, and OLAP
- Experience working in a Unix/Linux environment
- Solid oral, written communication and problem solving skills
Additional Skills Preferred:
- Experience with CA Erwin data modeling tool
- Food Service or Retail Industry experience a plus
- Experience with SAS and Data Mining tools a plus
|
OBIEE DEVELOPER