At Bi3 Solutions we are always looking to expand our team and capabilities with senior people that come from diverse backgrounds and can demonstrate broad industry experience.

If you are interested in joining our dynamic team send us an e-mail with your resume at jobs@bi3solutions.com

ETL Architect / Data Integration Specialist

Job Summary:

We are seeking an experienced ETL Architect / Data Integration Specialist to join our consulting team. The ETL Architect / Data Integration Specialist will take a lead role in defining the logical and physical data models, and the ETL (extract, transformation and load) architecture and standards, within the context of Business Intelligence and Corporate Performance Management solutions.

Responsibilities:

The ETL Architect / Data Integration Specialist will be responsible for:

• Design of the logical and physical data warehouse schema
• Developing data naming standards
• Analyzing source systems and creating a mapping to the target database schema
• Defining and implementing the required business transformation rules and logic (ETL development)
• Designing and developing exception handling and data cleansing / standardization procedures
• Optimizing ETL performance
• Identifying and managing data quality issues
• Assessment and recommendation of ETL tools
• Defining a suitable architecture for data integration from multiple, disparate data sources (including legacy systems, relational databases, flat files, message queues, spreadsheets, etc.

Required Skills and Experience:

• Experience with data analysis, modeling and design specific to a data warehouse / Business Intelligence environment (dimensional modeling)
• Experience with the design of large scale ETL solutions integrating multiple source systems
• Good understanding of overall data warehouse design principles and best practices
• Experience with ETL tools such as DataStage (Ascential), Informatica, Cognos DecisionStream, Oracle Warehouse Builder
• Extensive experience with SQL and SQL scripting for relational databases such as Oracle, Microsoft SQL Server, IBM DB2, MySQL
• Experience with one or more “best of breed” BI tools is a plus e.g. Cognos, Hyperion
• Ability to communicate design solutions to both technical and non-technical audiences
• Must be able to work independently and provide direction to junior staff

Qualifications:

Candidates must have a Bachelor's degree in Information Systems, related field, or equivalent experience to include a minimum five years experience in the design and development of Enterprise Data Warehouse / Business Intelligence systems.

Other Requirements:

• Some travel may be required.
  

posted by Bi3 Solutions on Wednesday, July 19, 2006