Cognos Architect

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.
• Apply IBM BI Reference Architecture and DIM modeling concepts.
• Lead data warehouse methodologies and full SDLC.
• Collaborate with multiple project teams in a technical consultation role.
• Demonstrate strong analytical, problem solving and communication skills.

Skills

BI / OLAP architecture

IBM Cognos Framework Manager

Dimension Modeling

IBM IM stack

ETL tools (Informatica, SSIS, Data Stage)

Analytical skills

Communication skills

Microsoft SSIS

Informatica

Education

Bachelor’s degree or foreign equivalent

3 years of progressive experience in the specialty

Tools

IBM Netezza

Data Modeling tools

Job description

• Played BI / OLAP architect Role for at least two end to end large engagements
• Build reporting and meta-data models in IBM Cognos Framework Manager to support strategic data initiatives
• Good understanding of ROLAP / MOLAP functionalities
• Knowledge of IBM BI Reference Architecture BI Methodology
• Strong knowledge of Dimension Modeling
• Extensive knowledge of the IBM IM stack
• Full software development lifecycle
• Data (logical & physical) Modeling tools and methodologies in data design
• Data Warehouse methodologies
• Relational and Dimensional Design concepts
• OLTP, OLAP and DSS implementations
• IBM Netezza design and optimization for Cognos BI
• ETL tool knowledge (Informatica, SSIS, Data Stage)
• Willingness to work with multiple project teams in tandem in a technical consultation role.
• Excellent analytical and problem solving skills.
• Should have excellent communication and customer presentation skills.
• Experience and desire to work in a Global delivery environment

Qualifications

Bachelor’s degree or foreign equivalent required from an accredited institution. Will also consider three years of progressive experience in the specialty in lieu of every year of education.

At least 5 years of experience with DW/BI and ETL tools.

At least 2 years of hands on experience in Design, Development & Build activities in Ab Initio Projects - MUST.

At least 7 years of experience in Project life cycle activities on DW/BI development and maintenance projects and IT

Additional Information

Job Status: Full Time

Eligibility: EAD GC or GC or US Citizens

Share the Profiles to mkonni(at)1stitsolutions.com

Contact: 703-349-1214

Keep the subject line with Job Title and Location