Cognos TM1 & CDM Developer — DW/ETL & Forecasting

SmartRecruiters, Inc.; Lone Tree (CO); On-site; USD 90,000 - 130,000; Full time

Job summary

Sonsoft, Inc. in the USA seeks a DW ETL specialist with 4+ years in DW ETL and IBM Cognos TM1. You will develop TM1 planning/forecasting apps, implement TI processes to load data, and optimize cube performance.

Strong SQL/PLSQL, data modelling, and experience with Cognos CDM reporting are highly valued. Certification in IBM Cognos TM1 is a plus and TM1 security management is required.

Qualifications

• At least 4 years of experience in DW and IBM Cognos TM1.
• Experience with Financial Planning, Budgeting and Forecasting solutions preferred.
• Certification in IBM Cognos TM1 is a plus.
• Strong analytical and communication skills.

Responsibilities

• Develop and maintain Cognos TM1 Planning/Forecasting/Budgeting applications.
• Create and tune TI processes to load data into cubes and manage dimensions.
• Design active forms and enhance form performance.
• Maintain TM1 security, roles and user management.
• Load and transfer currency data to currency cubes and manage data transfers between cubes.
• Perform data modelling, design and implementation to standards.

Skills

IBM Cognos TM1

IBM Cognos Disclosure Management

Turbo Integrator (TI) Processes

SQL and PL/SQL

Data modelling

Performance tuning

TM1 security management

Cognos CDM development

Cognos TM1 reporting

Education

Bachelor’s degree or foreign equivalent

3 years of relevant work experience in lieu of education

Tools

TM1 Planning/Forecasting

Active Forms

Cognos TM1 security

Job description

Sonsoft, Inc. in the USA seeks a DW ETL specialist with 4+ years in DW ETL and IBM Cognos TM1. You will develop TM1 planning/forecasting apps, implement TI processes to load data, and optimize cube performance.

Strong SQL/PLSQL, data modelling, and experience with Cognos CDM reporting are highly valued. Certification in IBM Cognos TM1 is a plus and TM1 security management is required.