Monday, June 02, 2008

Oppenheimer Funds - Lead Data Warehouse Analyst

Title:Lead Data Warehouse AnalystSkills:Data Warehouse Lead--Informatica ETL developer on an Oracle RDBMS/Unix platform
Date:6-2-2008
Location:Centennial, CO
Area code:303
Tax term:FULLTIME
Pay rate:DOE
Length:
Position ID:DW5
Dice ID:oppenhei
Job description:*The Lead Data Warehouse Analyst is responsible for leading the design, development, maintenance and support of the corporate data warehouse.
*All phases of data warehousing, including requirements gathering, data warehouse design, logical modeling, data acquisition design, development, testing, and deployment, as well as documentation.
*Partner with business users to gather requirements, translating those requirements into a technical solution.

Competencies For Success:

*Minimum five years of experience working in a production Data Warehousing environment as an Informatica ETL developer on an Oracle RDBMS/Unix platform
*Minimum five years experience designing and implementing dimensional data models and ETL design utilizing Informatica and PL/SQL programs for production data warehouses in a Unix.
*Minimum three years working as a technical lead.
*College degree in Computer Science; or equivalent experience.
*Strong proficiency analyzing source data and creating staging designs and dimensional data models.
*Demonstrated understanding of the concepts, functions and practices of a data warehouse in the corporate environment including dimensional data modeling and data acquisition methodologies, data staging, cleansing, and transformation.
*Strong experience with advanced features in the Oracle RDBMS (such as partition management and Materialized Views) and expertise in SQL and PL/SQL programming and SQL performance tuning in a Unix environment.
*Experience creating Unix shell scripts.
*Must have ability to work with business users gathering requirements, translating those requirements into a technical solution, creating a dimensional data model design and ETL design, and implementing in a production data warehouse environment for business reporting and analysis.
*Possess a project oriented approach to data warehouse design and development work
*Requires excellent written and oral communication skills.
*Ability to manage a heavy workload, achieve results while meeting project deadlines with minimal supervision in a team-oriented environment.
Preferred Skills
*Experience with First Logic Software for data cleansing
*Experience with XML
*Experience with PowerDesigner
*Experience in Mutual Fund industry
*Experience with BI tools (Cognos)

OppenheimerFunds offers an excellent benefits package, an outstanding time-off program and a range of opportunities for personal and professional growth.

OppenheimerFunds is an Equal Opportunity Employer. Any offer of employment is contingent upon successful completion of a background investigation.
Travel required:none
Telecommute:no

Oppenheimer Funds Inc
6803 S Tucson Way
Centennial, CO 80112