Senior TM1 & CDM Analytics Engineer | DW/ETL & Planning

SmartRecruiters, Inc.; Denver (CO); On-site; USD 90,000 - 120,000; Full time

Job summary

Sonsoft, Inc. is seeking a DW/ETL professional with 4+ years of experience and a strong background in IBM Cognos TM1. Responsibilities include building TM1 planning, forecasting and budgeting applications, TI processes, and performance‑tuned reporting. SQL/PLSQL and data modelling are essential. Certification in TM1 is a plus.

Must have a financial analytics mindset, solid data loads, and ability to work with cross‑functional teams in a US-based environment.

Qualifications

• Bachelor’s degree or foreign equivalent required.
• 4+ years of experience in DW and IBM Cognos TM1.
• 3 years of relevant work experience may offset education.

Responsibilities

• Develop and maintain Cognos TM1 planning/forecasting/budgeting applications.
• Create TI processes to load and retrieve data, build dimensions and cubes.
• Maintain TM1 users, roles and security; monitor data loads.
• Enhance Active Forms and improve reporting performance.
• Strong SQL/PLSQL and data modelling to support BI solutions.

Skills

IBM Cognos TM1

IBM Cognos Disclosure Management

Turbo Integrator (TI)

SQL

PL/SQL

Data modelling

Performance tuning

Data loads

Active Forms

Cognos CDM

Education

Bachelor’s degree or foreign equivalent

Tools

IBM Cognos TM1

IBM Cognos Disclosure Management

Turbo Integrator (TI)

SQL Tools

Job description

Sonsoft, Inc. is seeking a DW/ETL professional with 4+ years of experience and a strong background in IBM Cognos TM1. Responsibilities include building TM1 planning, forecasting and budgeting applications, TI processes, and performance‑tuned reporting. SQL/PLSQL and data modelling are essential. Certification in TM1 is a plus.

Must have a financial analytics mindset, solid data loads, and ability to work with cross‑functional teams in a US-based environment.