Latest Jobs  
Advance your technical career… Find a tech school and start an IT career!
Start your career in the fast-growing technical field – Get more info here »
Advance your technology career with the latest technology skills - Get more info here »
 
This job has expired.
 
Job Information
Job title

IT Reporting, Analysis,

Company Ajilon
Wage between $0.00 - $0.00 Hourly
Location United States, California, San Ramon
Employment type 6-9 Month Contract
Education Bachelor
Year Experience 3 - 4 Years of Practical Experience
Travel None
Published on 4/18/2008
Description

Execute SAP/BW reports, MS Access queries, and Excel Macros in order to gather data, process data, and create Excel reports. This is a heavily manual process, requiring many steps and extensive cutting and pasting between MS Access and Excel. This processing must be executed manually on scheduled days throughout each month.

Modify and maintain existing MS Access/Excel reports to meet business user needs.
Work with business analyst to develop new MS Access and Excel reports, and SQL reports to meet business needs.

Key Job Responsibilities (essential position functions):

Manage automated processes to gather data from multiple sources to feed the scorecard metrics calculations.
Work with planners to develop yearly budgets by gathering previous year's costs and interpreting the actual costs.
Data collection, validation and adjusting for cost benchmarking.
Develop queries in SQL Navigator for monthly and ad hoc reporting.
Work with database administrators to direct routine and ad hoc data loads & extracts.
Troubleshoot data loading problems.

Technical Skills
MS Access
Excel/VBA
SAP-BI for data extraction
Writing queries in SQL Navigator


Required Technical Skills:

In depth knowledge of Excel, including understanding file links, formulas, VB Code and macro concepts.
Basic knowledge of MS Access
Basic knowledge of database structures
Intermediate SQL skills (Advanced would be even better)

Nice to Have Technical Skills:
VBA
Basic knowledge of SAB/BWdf-tc

Experience/Skills
---------------------------------------------------------------------------------
Please send resumes directly to bitan.biswas@ajilon.com.
Please be ready to provide 2 professional references. Resumes without hourly salary expectation will not be considered. Locals only please, no sponsorship or CTC available at this time.
----------------------------------------------------------------------------------

Other desired skills:
IT Reporting, Analysis,
This job has expired.