Aon Service Corporation has an open position for a Lead Data Warehouse Analyst supporting Aon Risk Services.

? Eight to Ten plus years of experience in IT with relational database management systems (RDBMs), with a minimum of seven years in data warehouse design of logical physical models; DBA experience with Oracle is helpful.
? Three or more years of experience with data warehouse architecture required
? In-depth experience designing/implementing relational database solutions
? Experience in Insurance and/or Client Profitability Initiatives helpful
? Experience in managing Outsourcing teams a plus
? Experience in at least one of the following areas is essential:
? data modeling techniques
? data cleansing software
? data replication products and technology
? data access software optimization
? mainframe data migration
? Oracle designer/ETL process and procedures
Special Skills Required:
? Knowledge of data warehouse, data mining, and database/business intelligence architecture
? Comprehensive knowledge of problem analysis, and design and programming techniques
? Working knowledge of one or more multi-user, multitasking operating systems
? Expert in tuning VLDBs to perform optimally with DSS front-end packages
? Ability to source data from legacy systems and load it into the warehouse
? Ability to effectively adapt to rapidly changing technology and apply it to business needs
? Experience in entity relationship data modeling, with experience using data warehousing and data modeling tools such as:
? Oracle Designer & PL/SQL
? Oracle Data Warehouse & ETL
? Business Objects/Micro equivalent to Cognos Decision Stream
? Business Objects/Micro equivalent to Cognos PowerPlay, ReportNet, Impromptu & Visualizer

? Strong analytical and conceptual skills; ability to create original concepts/theories for various projects
? In-depth knowledge of at least one industry-leading database product
Description of Duties and Responsibilities:

? Primary responsibility is for the data warehouse (management information, client profitability & benchmarking and all natters pertaining to steady-state activities and prioritization of enhancements, bug fixes etc.
? Secondary responsibility is the maintaining of the business sponsors and outsourcing relationships. The incumbent will have a dotted line responsibility of looking after the onshore/offshore teams.
? Design relational databases and operational data stores to perform well logically and physically for decision support
? Coordinate new data development and ensure that it is consistent and well integrated with existing warehouse structure
? Design key and indexing schemes
? Design partitioning and summarization strategies
? Be proficient in business analysis, event modeling, data modeling, logical and physical database design, data acquisition analysis and design, data access analysis and design, DBMS optimization, archive and recovery strategy, load strategy design and implementation, security, and change management
? Properly design warehouse to enable easy, natural end-user access
? Balance design for optimized data access with the factors of batch data warehouse loading and maintenance resource utilization
? Establish auditing procedures to ensure continued data integrity
? Assist is post-implementation continuous improvement efforts in enhancing performance and providing increased functionality
? Provide departmental data marts as required
? Coordinate enhancements and maintenance of data warehouse, as well as structural changes when necessary
? Review business requests for data and data usage; research corporate data sources for new business data and better sources of data feeds

To Apply to this job go to http://www.GadBall.com or click here