Job Order #3167

Email this Job to a Friend
Posted Date: 8/27/2020
Job Category:
Position Title: Snr Cognos Planning & Analytics (TM1) Developer
Salary Range:
Location: Mississauga, Ontario, Canada
Desired Skills:


• Conceptualize, design, and implement a Cognos Planning & Analytics (TM1) solution from existing data warehouse, and other enterprise data sources.

• Provide industry and/or technology expertise to TM1 development team and customers

• Participate in TM1 implementation and customization projects.

• Develop and maintain TM1 assets for budgeting, forecasting, general ledger, corporate accounting, and other projects.

• Interact with various levels of client personnel, including both financial analysts and IT

• Contribute to the development of methodologies, approaches, and models relevant to TM1

• Monitoring the daily routine tasks and solve business problems with hands-on coding

• Handle and prioritize multiple tasks

• Play a key role developing project artifacts; business requirements document, detailed design document, and report specifications

• Assist in complex sizing, resource estimates, scope and requirements for a variety of projects.

• Develop and execute test cases to carry out various levels of testing. (Unit, SIT, UAT)

• Assist in developing project plans for the Cognos Planning & Analytics related tasks of a project

• Assist in designing logical and physical dimensional data mart models

• Provide end-user support for Cognos Planning & Analytics related requirements and issues

• Install and configure the Cognos Planning & Analytics suite of products.

• Performance tune cubes, reports and dashboards based on PA cubes

• Define and implement administration and housekeeping functions such as automation, backup and recovery, security, deployment, user audit & usage, and license tracking processes.

• Work with business analysts and team members to translate business requirements into a proposed solution, reviewing the design and requirements and build value added solutions

• Research issues and identify the root causes to ultimately work with Business Analysts to test solutions, ensuring that all solutions perform to expectations and meet all requirements for accuracy, clarity and ease of use

• Partner with IT to manage, build and develop reporting artifacts. Hands on collaborative development of analytical systems, strategies and best practices

• Research issues and identify root cause of information issues and design a solution that will prevent the problem from re-occurring

• Analyze, design, and introduce new opportunities and make appropriate recommendations to drive process improvements and productivity initiatives within the analytics function

• Contribute to the development predictive analytics and frameworks in response to evolving business requirements

• Travel to field offices intermittently to work with key stakeholders.

• Collaborate with other internal IT staff as needed to maintain high service standards.

• Document all analytics operations, processes, and objects.  

• Ensure leading practices and standards are followed.

• Project work as required.

• Adherence to company policies and procedures.

• Assist in regulatory and compliance activities and reports.

• Availability for occasional off-hours or weekend tasks.




• College or University degree in Computer Science or Business (Financial)

• Strong financial background/experience required (formal financial background preferred)

• Experience with complex Cognos implementations

• Expert knowledge of TM1 with a continuous recent development experience.

• Minimum of 10 years of relevant industry experience with increasing levels of responsibility

• Minimum of 7 years of experience working with IBM Planning Analytics / TM1 technology in both a design and development capacity

• Expert in developing successful technical solutions that involve TM1 cubes, dimensions, TI processes, rules, chores, MDX queries and executing the completion of the TM1 architecture per project.

• Experience creating ETL extraction, transformation loading processes in TM1 TI, performing business rule mappings of relational data into dimensional model.

• Development of reports based on Perspectives, TM1 Web, planning Analytics for Excel, Planning Analytics Workspace

• Worked on replicating the cubes between servers, and sharing data between cubes

• Maintenance of TM1 users, roles, and security. Worked on Authentication and authorization by creating the TM1 Users and User groups.

• Strong interpersonal communications with the ability to work in a team environment

• Expert understanding of SQL concepts and ability to write complex queries is required.

• Strong knowledge of general warehousing concepts and theory

• Knowledge of Ralph Kimball and Bill Inmon design theories

• Knowledge of dimensional data modeling techniques and theories

• Ability to understand and read data models

• Knowledge of RDBMS concepts and technologies

• Experience with MSSQL; establishing connectivity and knowledge of the MSSQL database engine and features/functions

• Experience providing training, knowledge transfer and mentoring

• Ability to work with minimal direction and supervision

• Excellent interpersonal, facilitation, presentation, and communication skills

• The ability to communicate complex information and issues to all levels of the organization

• Experience with enterprise application architecture and enterprise integration patterns

• Perform complex applications programming activities. Code, test, debug, document, maintain, and modify complex applications program

• Demonstrate good understanding of the Software Development Life Cycle (Agile and Waterfall)

• Excellent interpersonal, verbal, and written communication skills are required

? Must have: English

? Nice to have:  French

• Ability to analyze and document business and system processes is required

• Ability to multitask and handle ambiguity is required

• Ability to take charge and lead tasks to completion is required

• Ability to work in a cross-functional organization and Ability to work in a team environment is required

• Excellent decision making and problem-solving skills is required



• Experience developing Java/JavaScript/JSON applications using REST API for TM1

• Experience configuring parallel data loads for TM1 on multiple CPUs

• Administering IBM Cognos environments and developing Reports Studio reports

• Experience with an ETL tool (ideally Talend) an asset

• Knowledge of ETL architecture and design an asset

• Experience using ERWin or another data modeling tool an asset

Share this job: