Oracle BI Repository Architect

As an employee of PNC Financial Services Group, you become part of an organization committed to customers, employees, investors, and the communities in which we do business. PNC is an established, growing and successful financial services company, with businesses organized around retail and commercial banking, asset management, and funds processing. Our branches are concentrated in thirteen states and the District of Columbia; additional offices are located nationwide and internationally. We are growing in size and through recent acquisitions have become the fifth largest bank by deposits in the US. We are also growing in reputation, as a leader in areas such as work/life family culture, "green" building design, frontier technology, and strong corporate social responsibility.

As an OBI Repository Architect you are a member of PNC's Information Technology/Enterprise Information Management (EIM)/Business Information Delivery organization. You will be based in Brook Park, Ohio, Strongsville, Ohio or Pittsburgh, Pennsylvania. You will report to the VP/Manager of BI Standards & Architecture.

In your role, you will work directly with individual project teams in designing and delivering projects to the line of business. You will monitor upcoming OBIEE versions and the implications of new functionality on PNC current and future requirements. You define training curriculum and coding standards based on PNC BI goals and strategies. You maintain enterprise knowledge across all subject areas of the repositories (RPDs) deployed in production. You collaborate with the BI Best Practices Lead and individual BI Developers to implement solid RPD designs following stated best practices across physical, business and presentation models.

The successful candidate will have the following qualifications:

* Ten (10) or more years experience in enterprise-level business intelligence and data warehousing

* Three (3) years experience in Oracle Business Intelligence Enterprise Edition (OBIEE)

* Proven ability to architect multiple projects simultaneously and leverage knowledge across each one

* Strong knowledge and proven experience in metadata (RPD) design and development

* Experience in database design methodologies and dimensional modeling

* Basic understanding of the core concepts for data governance and metadata management

* Exposure/experience with ETL processes (Informatica is a plus)

* Demonstrated proficiency with SQL (Oracle and SQL Server databases a plus)

* Understanding of enterprise authentication/authorization controls and processes (LDAP, SSO, Windows security, etc)

* Demonstrated competency of the Linux Redhat and Windows Server operating systems

* Basic understanding of networking concepts

* Basic understanding of J2EE hosting / Web Hosting technologies (Apache/IBM Websphere a plus)

* Basic understanding of change control and multi-user development environment concepts (Harvest, Clearcase a plus)

PNC is committed to offering you a comprehensive and competitive benefits package. We design our full time and part time benefits programs based on PNC's benefits philosophy to provide quality levels of coverage at affordable costs over the long term for both employees and PNC. We strive to balance the cost of providing competitive benefits with the need to cover employees with a wide range of protection during and after employment.

Options you may be able to consider include:

* Medical and Dental Coverage

* Life Insurance

* Part Time Benefits

* Education Assistance

* Paid Training

* Paid Vacation

* Competitive Pay

* Shift Differential

* 401(k)

* Flexible Schedules

* Growth Opportunity

* Work/Life Balance

PNC is an Equal Employment Opportunity/Affirmative Action Employer -- M/F/D/V/SO