Share Email Opening

Financial Data Analyst 

EOE StatementWe are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law.

Scope of Services:

Financial and Data analysis and operational deliverables:

• Budgetary tracking is required to determine the viability to meet the budgetary commitments.  The deliverables will include the monthly tracking and reconciliation of the financials between operating plan (targets), commitments (whether paid or pending to be paid), and actual figures as extracted into Excel from the ledger.  Along with reconciliations, a scorecard summary will need to be created and maintained on a monthly basis to communicate our status.

• Assist in creation of forecasts for budgets and evaluation of areas to pull back budget under-runs as well as over-runs using MS Excel.

• Schedule tracking via our systems also needs attention to ensure that our communicated status is posted in a timely manner, and accurately for department metrics. The effort will also assist to close the gaps of data inaccuracies working with the project managers to address issues. Audits of projects will be part of the on-going deliverables

• Advise of reporting discrepancies, data issues, under-runs, over runs, etc.

• Serve as project auditor and help remediate, as needed, the project deliverables as listed in the auditable tasks for each business.  This role will require interfacing with the IT process owners of the audits that include the IT Controller for auditable tasks and his contractors as well as the onshore and offshore project teams.



Position Requirements Technical deliverables:
• Deliver improvements and automations of the reports, scorecards, charts, metrics reconciliations and related processes will be required to keep the accuracy and timeliness of the data fresh. In addition, the resource will be required to conduct improved Excel automations to improve efficiency in order to generate additional reporting and chart requirements, and audits.
• Deliver the upgrade of Excel files, pivots and macros into MS Excel.

- Financial and budgetary management expertise
- MS Excel 2010, Ability to use Excel VBA, create macros and work with sophisticated pivot tables, and long data sets
- Business Analysis, Ability to summarize, segment and stratify data as part of financial analysis and figure out root causes
- Experience and knowledge of project management to be able to self-pace on the one-time and re-occurring deliverables
- Ability to document procedures
- Critical and analytical thinking
Location Cincinnati, OH  
Category Information Technology  
About the Organization Providing IT solutions nationally since 1987, PCM, Inc. is an industry recognized, publicly traded, value-added direct marketer of technology products, services and solutions to businesses, government, education, and individual consumers. Fully accredited and authorized by major manufacturers including HP, Apple, Cisco, Microsoft, Dell, and 1500 others, PCM offers product and service solutions through field sales, call center, and eCommerce venues. With annual sales of $1.5B+, 3000 employees and over 400,000 products available, PCM delights in serving small, medium and enterprise level businesses.

PCM has a national presence with branch and satellite offices from California to New Jersey.

In addition to selling products, PCM has the capabilities and resources to consult, configure, install, implement and support what we sell. Service offerings include:

• Networking and infrastructure solutions
• Enterprise systems and storage solutions including data migration, replication, disk/tape storage management, SAN, NAS and virtualization
• Integration and configuration solutions
• Monitoring and operations solutions
• Advanced printing solutions
• 24/7 Help Desk
• System refresh and installation solutions
• Staff Augmentation resources
• Recycling & disposal solutions

PCM has received certifications and authorizations from all major manufacturers. From A+ to CCIEs, business analysts to architects, we have the expert staff to advise clients in making best-fit technology decisions.

PCM is an Equal Opportunity / Affirmative Action Employer ' Minority / Female / Disability / Veteran  
Req Number INF-13-00208  
Internal Approved REQ#  

This position is currently not accepting applications.

To search for an open position, please go to


Other Jobs Within Same Category
Data Center Pre-Sales Engineer (Dell,HP, EMC) in El Segundo, CA
Posted on: 9/15/2015
[Apply Now]

Other Jobs Within 60 Miles
-- None found --


AppOne.comTM   copyrightŠ1999-2015 HR Services, Inc.
Click here for technical assistance.