Looking for a technical architect responsible for designing and developing solutions with technical expertise in data warehouse design, ETL (ODI), reporting, and analytics. The incumbent designs and develops enterprise data warehouse (EDW), ETL, and business intelligence systems on OBIEE and Tableau. This position will provide guidance and technical oversight on an offshore BI development team to support the ongoing operation and enhancements of EDW, ETL, and OBIEE systems.
Roles and Responsibilities
Responsible for gathering requirements and specifications from business stakeholders.
Provide expertise in performing application development, configuration, and unit testing of data integration (using ODI, PL/SQL, SQL), and Oracle Business Intelligence (OBIEE) applications.
Collaborate with the development team to design and implement data extraction programs that integrate seamlessly into BI solutions to meet the needs of the end-users
Proficient with data modeling tools to create Entity Relationship Diagrams (ERD) for new and existing models
Experience with transforming logical business requirements into appropriate schemas and models
Create both logical and physical data models, with emphasis on data preparation, data profiling, data cleansing, and data auditing
Responsible for working with the offshore BI team members and business stakeholders to deliver reporting and analytics solutions within the data warehouse and OBIEE.
Responsible for analysis, design, development, customizations, validations, deployment and post-implementation support for OBIEE components including Oracle BI Admin, interactive dashboards, BI Publisher, scheduler, and interactive reporting using OBIEE 12c
Work closely with business stakeholders, developers(offshore) and database administrators to plan, design, develop and implement applications, scripts, procedures, and metadata for relational databases.
Responsible to create, maintain, and enhance Business Intelligence components (metadata, reports, metrics, dashboards) and manage the overall BI ecosystem by resolving defects on time.
Responsible for troubleshooting, debugging, optimizing and performance tuning of Oracle BI reports.
Responsible for developing re-usable OBIEE frameworks such as logical layers and metadata mappings
Lead BI application change control management by performing impact analysis to drive changes
Responsible for performing analysis, design, development, testing and performance improvements of complex queries based upon the specific needs of the Client
Coordinate work efforts with the DBA team for application changes and system performance issues
Collaborate on testing OBIEE functionality for the deployment of upgrades to keep application release level current
Pursue innovative ways to improve the process of delivering solutions to OBIEE users
Proactively work through service requests with Oracle support as needed.
Nurture and enforce best practices for development activities within the assigned staff
Perform other related duties as assigned
Basic Qualifications Developer III
Bachelor s degree in computer science or relevant field
Minimum 6 years of experience in data warehouse and OBIEE, with focus on ETL/ODI) and BI tools like OBIEE
Minimum 2 years of experience in end-to-end deployments of OBIEE
Professional Skills Requirements:
Demonstrated involvement in end-to-end deployments of two (2) of the following: OBIEE Administration, OBIEE repositories, Oracle BI applications, data warehousing in an Oracle environment
SQL proficiency with experience in constructing/deconstructing complex reports and queries
Data modeling experience using dimensional data modeling, star/snowflake schema, fact and dimension tables, physical and logical data modeling
Knowledge in building metadata repository, designing business and presentation layers, creating interactive dashboards and reports using OBIEE
Ability to solve complex issues using methodical troubleshooting based on expert knowledge of Oracle OBIEE application functionality and technology
Ability to coordinate, lead, and support offshore development activities beyond the regular working hours.
Launch your career - Create your profile now!Create your Profile
Loading some great jobs for you...