Cognos Administrator Needed for Atlanta''s Top Healthcare Company!

POSITION SUMMARY

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 ArcPlan +EDM, Terminal Server, Finance share drive and SQL Server. The position requires strong analytical and financial modeling skills, an advanced OLAP and Business Intelligence skills and a good understanding of financial and accounting fundamentals.

RESPONSIBILITIES

1. Technical

Act as the primary system administrator and developer to support and enhance the Business Intelligence and Reporting systems for the Finance department. These systems include: IBM Cognos TM1 (OLAP reporting database), ArcPlan (web-reporting and interface tool) and +EDM (master data management tool)

Provide client support for over 150 US , Canadian and European based TM1 users. Work with users to troubleshoot system and model issues

Support and assist in the administration of the European office s TM1 Implementation

Source, manipulate and upload data from several source systems using the BI and database ETL tools. The source systems include PeopleSoft, SAP, Hewitt (HR Benefits outsourcing company) and several other financial and accounting systems

Write TM1 processes to transfer data between various categories (versions)

Create extracts from TM1 to upload into HFM, PeopleSoft, EDM, PhaseGate and SAP

Build Back End SQL queries to source data from SQL Server databases to upload into SAP and BI tools

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

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

Write complex business rules to provide additional reporting capabilities.

Create feeder rules to optimize business rules and improve performance.

Enhance and maintain system and financials models, including allocations, cross company initiatives and other

Work closely with IT to coordinate server upgrades, patching, backups and maintenance

Optimize business models and business rules to minimize memory usage and reduce response times

Research and test new technologies

Provide training on new functionality and business models to the FP&A and accounting departments

Write detailed system documentation to explain business models, processes and data flow

Manage master data for hierarchies and elements within cubes and dimensions

Develop and maintain ArcPlan reporting screens

Administer and upgrade existing Servers and software for TM1, EDM, ArcPlan and development environments

Design, build and optimize forecasting, planning and budgeting financial models

Administer finance share drive

Administer Clinicals Service and Maintenance SQL Server databases

Assist in BPR project to help create new center hierarchy, define activity rates, define interfaces between SAP and TM1 and assessment and allocation models

MINIMUM JOB Qualifications

Education/Training:

Bachelor of Science in Information Technology or Computer Science

MBA/MS a plus

Business Experience:

5 to 7 years in the Business Intelligence industry (preferably with TM1). Working knowledge of financial and accounting processes and principals

Specialized Knowledge/Skills:

Assertiveness & Influence Promotes ideas and proposals persuasively while building and maintaining positive working relationships.

Decisiveness & Judgment Develops and selects well-reasoned actions to address business issues in a timely manner.

Mature Confidence Demonstrates self-awareness, staying focused on goals and managing emotions, even in the face of controversy.

Results Orientation & Energy Demonstrated personal commitment and drive to set and meet or exceed high standards and objectives.

Communication Skills Communicates effectively through oral and written means. Is able to write, speak, and present effectively to various types of audiences. Communicates matters of importance in a timely manner, and effectively communicates one s position in sensitive consultative situations.

Finance Systems & Processes Demonstrated knowledge of financial systems and processes throughout the organization. Leverages that knowledge to fulfill business responsibilities.

Technical and System Skills IBM Cognos TM1, ArcPlan, +EDM, Microsoft SQL Server 2000, SQL, VBA and SAP

Financial Modeling Demonstrated ability to accurately model the financial aspects and outcomes of business issues using spreadsheets and/or other applicable tools.

Financial Statement Analysis Demonstrated knowledge of financial statement analysis, income statement, balance sheet and cash flow.

Functions as a Business Partner Understands the internal and external issues facing business unit clients and uses that understanding to forge partnerships and achieve goals.

Planning & Organizational Skills Effectively uses the time available to complete work tasks and activities that lead to the achievement of expected work objectives (as results or outputs).