Data Warehouse Architect in Chicago, IL
Our client currently seeks a Data Warehouse Architect for a DIRECT-HIRE opportunity. (WE ARE UNABLE TO SPONSER OR TRANSFER H1B-VISA'S). The sucessful candidate should have the following:
Education/Experience/Skill Requirements:
· BA in Computer Science/Mathematics/Electrical Engineering or equivalent experience
· Minimum 4 years demonstrated experience performing data analysis and full life-cycle development within an Oracle/Unix data warehousing environment
· Minimum 3 years experience developing ETL processes in Oracle Warehouse Builder (version 10G experience desired)
· Strong database design and relational and dimensional data modeling skills (ERWIN proficiency desired)
· Strong SQL and PL/SQL coding and tuning skills (TOAD proficiency desired)
· Familiarity with end-user reporting toolsets such as Cognos and/or Discoverer
· Experience with Microsoft Office suite
· Experience with Oracle ERP Applications a plus
· Minimum 3 years hands-on experience in collecting and documenting reporting and business intelligence requirements
· Excellent conceptual, analytical, problem solving and testing skills
· Ability to plan, organize, coordinate, schedule, evaluate, and make decisions
· Ability to translate business needs into technical solutions
· Strong verbal and written communication skills with all levels of personnel
· Ability to think, work, and contribute beyond defined responsibilities
· Ability to work independently with a minimal amount of supervision
· Flexibility to handle constantly changing priorities
· Positive, upbeat, outgoing personality, dynamic and action oriented
· High level of interest, commitment, involvement and responsibility
Essential Job Functions:
· Lead and participate with business user and technical groups to identify, analyze and document business intelligence opportunities and business requirements
· Develop Data Warehouse data matrices, index plans and implementation plans
· Create logical, physical and dimensional data models and design complex ETL plan logic, mapping matrices and specifications
· Manage the detailed design, development, testing and deployment of data architectures in an Oracle/Unix environment
· Develop, maintain and execute test scripts and plans, and play an active roll in project rollouts
· Coordinate with business applications team in identifying, analyzing and documenting information sources and resolving issues
· Participate in ongoing maintenance and performance tuning
· Ensure the availability and accuracy of data warehouse data
· Provide production support in the identification and resolution of data or technical issues
· Provide off-hours support as needed for production issues
· Coordinate with Infrastructure, Technical Services and DBA groups for the implementation and support of the physical data warehouse environment
· Manage and execute data retention strategies
· Support technology improvement, reviewing and recommending new technology
· Fulfill complex adhoc query/analysis/reporting requests and assist department members in using and supporting end users with various reporting tools
· Prepare and provide statistics on data warehouse ETL performance and usage
· Develop automated methods to proactively identify data quality or technical issues
· Participate in developing and maintaining standards and best practices
· Train coworkers in analytical and technical skills and techniques, including development of training materials and documentation as needed
· Create and manage project plans as needed
· Travel to off-site locations to participate in work sessions with business users or in off-site seminars and training
· Provide support in event of disaster
· Other special projects as assigned
=========================================================================== Experience:
REPLY TO: mcgstb @ netscape .n e t
(INCLUDE SALARY HISTORY FOR CONSIDERATION)
(PLEASE INCLUDE JOB TITLE IN SUBJECT HEADING)
(WE ARE UNABLE TO SPONSER OR TRANSFER H1B-VISA'S)
=========================================================================== To Apply to this job go to http://www.GadBall.com or click here