The Pampered Chef, Ltd. seeks a Lead BI Engineer at its facility located in Addison, IL. The Lead BI Engineer will develop and support technologies for the Oracle 11i/R12 OBIEE implementation. S/he will work using Oracle Reporting Solution OBIEE+, and will develop reports using Answers, pre-packaged Oracle BI Apps (such as Supply Chain Analytics, Order Management Analytics, Financial Analytics, Procurement and Spent Analytics), Reports and Dash Boards, BI publisher Reports. S/he will also develop technologies for Oracle ERP modules such as Financials, WMS, ASCP, Demantra, and Order Management.  S/he will interpret requirements data, maps current and future state business processes to the packaged application(s) being implemented, and will develop plans to address functional gaps between the packaged application and the redesigned processes by building custom schema, ETL mappings, answer analysis reports and dash boards in OBIEE+.  S/he will build ETL maps, custom schema, security setups, custom reports and custom dash boards on OBIEE platform using ETL tools (Informatica) and Oracle pre-built BI Apps. S/he will leverage strong analytical and problem solving skills to identify and deliver actionable insights. S/he will provide guidance to other BI team members in Oracle OBIEE applications and standards for interfaces and bolt-on components.  Dimensional modelling to design star and snowflake schema as per the business requirements.

REQUIREMENTS Bachelor’s degree in Computer Science, Electronic Engineering, Computer Engineering, Software Engineering, Technology or related and 8 years of professional experience in Informatica, Data Integration, Data Governance and Data Quality. Additionally, the applicant must have 8 years of professional experience with: (1) SQL and Oracle PL/SQL; (2) Oracle Business Intelligence Application (OBIA) environment, utilizing Informatica/Oracle Data Integrator (ODI) for Oracle database target; (3) Informatica or Business Intelligence / Data Warehousing methodology; (4) Data Extraction, Transformation and Loading data from sources like Oracle, SQL Server and Flat files using Informatica; and (5) SDLC methodology.  Applicants who are interested in this position may apply online with resume and cover letter.