TM1 Systems Administrator

Change Healthcare   •  

Alpharetta, GA

Industry: Healthcare IT


5 - 7 years

Posted 291 days ago

This job is no longer available.

Current Need

This position is responsible for supporting the business intelligence systems used by the FP&A and accounting departments. The main responsibility of the role is to administer, develop and optimize the IBM Cognos TM1 OLAP database server. In addition to the TM1 system there are several other ancillary systems that require development and support, namely, Citrix, Excel, SharePoint, SQL Server (Database, Queries, SSIS, MDS) and Financial share drives. The position requires strong analytical and financial modeling skills, advanced OLAP and Business Intelligence skills and a good understanding of financial and accounting fundamentals.

Position Description


? Act as the primary system administrator to support and enhance the Business Intelligence and Reporting systems for the Finance department. These systems include: IBM Cognos TM1 (OLAP reporting database), SQL Server 2012, and MDS (master data management tool)

? Provide level 2 client support for 250+ US, Canada, and European based TM1 users. Work with users to troubleshoot system, model, and report issues 

? Source, manipulate, and upload data from several source systems using the BI and database ETL tools. The source systems include SAP ECC, SAP BW, PeopleSoft HR, PeopleSoft Financials, SharePoint, HFM, SQL Server, SalesForce, Essbase, Adaptive, Oracle, and several otherfinancial and accounting systems

? Write and maintain TM1 processes to archive data within existing cubes, transfer data to and from cubes, and import and export data to and from other source systems

? Create, update, and publish standardized Excel reports using TM1 ActiveForms, TM1 Action Buttons, and complex VBA code

? Automate and streamline existing processes

? Write and maintain SQL queries, views, and stored procedures to source and consolidate relational data 

? Create and maintain SSIS packages and scheduled jobs to load data into SQL Server databases and provide routine system backups and maintenance

? Implement and maintain TM1security models using server, cube, dimension, element and cell-level security for financial and HR-related data

? Maintain approval workflow for Capital Asset Requests in SharePoint

? Coordinate and manage annual software license and user access reviews for TM1 and other ancillary systems

? Write and maintain complex TM1 business rules to provide additional reporting and analysis capabilities

? Write and maintain TM1 feeder rules to optimize system performance

? Provide in person and remote training on new functionality and business models to the finance and accounting departments

? Write and maintain detailed system documentation to explain business models, processes, and data flows

? Manage master data for hierarchies and elements within TM1 cubes and dimensions and within the Master Data Services (MDS) system

? Administer/upgrade servers and software for TM1 and ancillary system for both production and development environments

? Act as the administrator for the TM1SharePoint portal

Financial Planning & Analysis

? Have a solid understanding of profit and loss statements, balance sheets, cash flow statements, etc

? Create financial models, metrics, and business rules 

? Reconciliation of Actuals, Forecasts, and Plans across various systems including SAP, Hyperion, and TM1.


Minimum Requirements

6+ years experience in designing, building, and implementing business solutions using information technology. Significant experience in business analysis, requirements definition and deployment of business requirements to information systems.

Critical Skills

? Business Intelligence experience with TM1required

?Database or SQL experiencerequired

? Familiar with reconciliation of Actuals, Forecasts, and Plans against various source systems 

? TM1 development/administrative experiencerequired

Additional Knowledge & Skills

? Cognos BI, Essbase, Analysis Services, or Hyperionexperience

? Multidimensional databaseexperience 

? Demonstrated knowledge of financial statement analysis, income statement, balance sheet and cash flow

? Application experience with: Microsoft SQL Server, SSIS, Master Data Services (MDS), SharePoint, SAP ECC, SAP BW (Business Analyzer), Excel 

? Programming language experience with: SQL, VBA, MDX

? Strong problem solving abilities

? Project/Process Management ? Demonstrated ability to lead projects or handle large, complex processes. Also, must have a mindset that is oriented to constantly drive process improvement

? Communication Skills ? Communicates effectively through oral and written means. Able to write, speak, and present effectively to various types and sizes of audiences. 


?Bachelor of Science in Information Technology or Computer Science

? MBA/MS a plus

Physical Requirements

General Office Demands

$100K - $110K