Cognos BI Architect & Data Warehouse Strategist

TecTammina; Hartford (CT); On-site; USD 120,000 - 150,000; Full time

Job summary

A global data solutions company is seeking an experienced BI/OLAP architect to play a key role in large engagements utilizing IBM Cognos and other ETL tools. Candidates must have extensive knowledge in dimensional modeling and at least 5 years of experience in DW/BI projects, with a focus on Ab Initio. This full-time position requires individuals to have strong analytical and communication skills, and the ability to work in a global delivery environment.

Qualifications

• 5+ years of experience with DW/BI and ETL tools.
• 2+ years of hands-on experience in Design, Development & Build activities in Ab Initio Projects.
• 7+ years of experience in Project life cycle activities on DW/BI development and maintenance projects.

Responsibilities

• Played BI / OLAP architect role for at least two end-to-end large engagements.
• Build reporting and metadata models in IBM Cognos.
• Good understanding of ROLAP/MOLAP functionalities.

Skills

BI / OLAP architecture

IBM Cognos Framework Manager

Dimension Modeling

IBM IM stack

ETL tools (Informatica, SSIS, Data Stage)

Analytical skills

Communication skills

Education

Bachelor’s degree or foreign equivalent

3 years of progressive experience in the specialty

Tools

IBM Netezza

Data Modeling tools

Job description

A global data solutions company is seeking an experienced BI/OLAP architect to play a key role in large engagements utilizing IBM Cognos and other ETL tools. Candidates must have extensive knowledge in dimensional modeling and at least 5 years of experience in DW/BI projects, with a focus on Ab Initio. This full-time position requires individuals to have strong analytical and communication skills, and the ability to work in a global delivery environment.