Ldanlyst, Fin Plan&analy Job in The Bank Of New York Mellon Corporation

The Lead Analyst will be responsiblefor extracting revenue data from various transactional systems and LOBs(Manual Files) , validate the extracted data, cleanse/standardize and load theminto respective staging tables through batch (ETL Informatica/SQL Loader)processing and make sure they are available for various Business Day wisereporting requirements. S/he is also expected to work on Analysis and Reportingon Revenue, cost/Volume Data.

KeyResponsibilities

Tocollect, input quality and scheduling all revenue, cost/Volume and clienthierarchy data pertains to CPP

Tointerface with rest of CPP operations team, shared services technology group anddifferent data owners

Tomanage the data input schedule for manual and automated feeds that encompassrevenue, volume run/cost, product mappings, cost center, and client hierarchies

Toperform data quality checks on various source data to make sure they meet thedata requirements

Tomanage associated responsibilities assigned with CPP Production time line

Supportother initiatives to meet common objective of CPP

Qualifications

Bachelor Degree in a financialdiscipline such as accounting, finance, statistics, or economics, Science/Engineering

Skills & Experience

5-8 years of overall experience (Financeexperience will be a plus)

Intermediateknowledge on SQL (ability to write medium complex queries)

Understandingabout Dimensional Modeling

Knowledgeon Cost Model, Activity Based Costing will be a plus

Knowledgeon BI reporting tool like Microsoft Power BI, Tableau, Qlikview, etc will be aplus

Superbcommunication skills - Strong written and oralcommunications skills

Self-starter Should drive change on their own with minimal direction needed

Analytical Ability to easily dive into very arcane details on allocations and bring itup to the appropriate level of audience they are communicating with

Excellentinterpersonal and relationship management skills

Confidentand calm demeanor with ability to perform under pressure and handle difficultsituations

AdvancedProficiency in MS Office (Excel, PowerPoint and Word)