Job Description
Project Overview
The Client is seeking an experienced Business Intelligence Developer to support enterprise data warehousing and analytics initiatives. This role focuses on designing, developing, and maintaining data warehouse and BI solutions primarily using Oracle and OBIEE technologies, along with other related IT systems. The developer will work closely with stakeholders to deliver reliable, well-structured analytical solutions that support business reporting and decision-making.
Key Responsibilities
- Design, develop, and maintain data warehouse and analytical solutions using Oracle and related BI tools.
- Perform data modeling and database design for data warehouse and business intelligence applications.
- Develop complex SQL queries and ETL (Extract, Transform, Load) processes.
- Build and maintain OBIEE RPD physical and business model layers, including joins and object mappings.
- Develop and enhance OBIEE presentation layer components such as dashboards, scorecards, and analyses.
- Create and maintain BI/XML Publisher reports.
- Submit weekly timesheets and status reports.
- Work a standard 40-hour week, with occasional extended hours as mutually agreed.
Required Qualifications
- Five or more years of hands-on experience in data warehouse development, including data modeling, complex SQL, and ETL development.
- Five or more years of experience in database design and modeling for BI applications, including relational structures, normal forms, and star schema models.
- Five or more years of experience developing OBIEE RPD physical and business model layers.
- Five or more years of experience building OBIEE dashboards, scorecards, analyses, and modifying presentation layer layouts and styles.
- Five or more years of experience developing OBIEE reports using BI/XML Publisher.
- U.S. Citizenship or Green Card required.
Technical & Soft Skills
Technical Skills:
- Oracle data warehousing and BI technologies
- OBIEE (RPD, Presentation Layer, BI/XML Publisher)
- Data modeling and database design
- Complex SQL development
- ETL design and development
Soft Skills:
- Strong analytical and problem-solving abilities
- Clear written and verbal communication skills
- Ability to work independently and meet deadlines
- Collaboration with technical and business stakeholders
Job Tags