Williams Lea Reporting Analyst Stamford Connecticut

Reporting Analyst - Finance & Operations

Overview:
The Reporting Analyst - Finance & Operations, is a member of the Williams Lea finance team and is accountable for building savings reports compiled from internal and external sources that will be used for client invoicing, the preparation of cost savings analysis, working with client counterpart to verify reporting. Identify and build additional reporting as required.
Job Responsibilities:
Compile internal and external reports into a single master file
Prepare detailed cost savings analysis
Track and report price discrepancies
Assist in administration of Master Pricing System
Understand entire process from baseline price to current price to savings realization to financial impact
Proactively highlight issues and concerns and work to resolve them
Challenge the status quo where appropriate to improve client relations, efficiencies, and accuracy.
Build ad hoc reporting as needed.
Job Requirements:
· Financial analysis in a purchasing environment
· Experience working with multiple systems; financial, inventory management, purchasing
· Advanced Microsoft Excel skills required including pivot tables, lookups, if statements
· Microsoft Access experience strongly preferred
· Understanding of procurement processes and reporting
· Strong interpersonal skills, must enjoy working collaboratively with cross-functional departments, both internal and client facing
http://jobview.monster.com/Reporting-Analyst-Finance-Operations-Job-Stamford-CT-US-86644922.aspx

http://office.microsoft.com/en-us/excel/default.aspx?ofcresset=1
http://office.microsoft.com/training/training.aspx?AssetID=RC102058721033&pid=CR100479681033
PivotTables are an interactive table that allow the user to group and summarize large amounts of data in a concise, tabular format for easier reporting and analysis. They can sort, count, and total the data, and are available in a variety of spreadsheet programs. The reason they're called "pivot tables" is because you can drag and drop fields to "rotate" a summary field and create cross tabs. One advantage of this feature in Excel is that it allows you to rearrange, hide, and display different category fields within the PivotTable to provide alternate views of the data.