Job Description :
Position:- Financial System Analyst
Location:- Columbus OH
Duration:-6+ months Contract to Hire

Description:-
The Financial Systems Analyst is responsible to design, test, validate and support IBM Cognos TM1 multidimensional models focusing on complex business requirements and develop reporting through TM1 and Business Intelligence reporting tools (Business Objects or other) with strong programming skills, experience with an Enterprise Planning solution, and the ability to document both functional and technical requirements for new projects, enhancements and changes.

DUTIES AND RESPONSIBILITIES
Software functional and technical designer of IBM Cognos TM1 financial models for store operations, supply chain, and company financials; with overall design awareness of merchandising models and future development. Design, build, maintain and configure ETL code from SAP and Netezza for new multidimensional TM1 models and to convert Cognos Enterprise Planning models. Design, code and maintain security for models: including server, cube, dimensional and cell level security. Test and manage TM1 metrics, processes and business rules in User templates (50%)
Responsible for technical problem resolution and on call support and for model adjustments as business needs evolve. Responsible for migration between separate Development and Quality Assurance environments, following stringent testing protocols and providing documentation for approval of migration to Production. (30%)
Support end-user analysis through intuitive design, communication and a full understanding of their business cases, working as a mentor for software capabilities; may include conducting training sessions. Produce and maintain related model documentation and be responsible for technical problem resolution and communication to support effective model building (20%)
May perform other duties as assigned *

JOB REQUIREMENTS
Minimum Qualifications (Education and Experience)
Bachelor’s degree in IT, Finance or Business, with 5-8 years of experience in Cognos TM1 or other financial modeling software, ETL and coding; any suitable combination education and experience will be considered.
Required project management experience, financial acumen and analytic ability, to be responsible for building, delivering and maintaining TM1 Financial models.
Experience in designing multidimensional models from Business Owners specifications and proven technical knowledge or related experience in Budgeting and Forecasting, preferably on IBM Cognos TM1 or Cognos Enterprise Planning.
Solid understanding of Profit and Loss statements, balance sheets, cash flow, etc. and the ability to execute complex tasks with a high attention to detail, a high level of accuracy and timeliness, and enjoys working in a fast paced environment.

Knowledge/Skills/Abilities/Training/Systems
Aptitude for complex problem solving and experience building multidimensional models, ideally in IBM Cognos TM1, Cognos Enterprise Planning or other Budgeting and Forecast solutions.
Programming code / ETL design and coding for Data Integration. Data Warehousing and Business Intelligence report development skills, SAP Business Objects preferred.
Strong Microsoft Office skills, particularly Excel, Pivot tables, and Access.
Required excellent verbal and written communication skills; the ability to successfully work in a high energy environment, display a detail-oriented approach to work, especially coding and validation.
Capable of documenting and testing controls over financial reporting and analysis and interacting professionally with a diverse group of Executives, Managers, Subject Matter Experts, End Users and IT.

WORKING CONDITIONS
Occasional evening and weekend work to meet deadlines.
Sitting for extended periods of time.
Dexterity of hands and fingers to operate a computer keyboard, mouse, and to handle other computer components.
Normal office conditions.