Analyst (Jobs in CAPITOL, VA)   Requirement id 10184 Job title Analyst Job location in CAPITOL, VA Skills required SQL Server 2000 DTS, SQL Server Analysis Services, Microsoft Excel Pivot Tables, Open Date 07-Jun-2012 Close Date Job type Contract Duration 1 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Analyst: SQL Server 2000 DTS, SQL Server Analysis Services, Microsoft Excel Pivot Tables, [**Note : Dead Line : 6/12/2012**] [Note : Start Date : 06-18-2012 End Date : 07-27-2012] Description : SQL System Analyst 1 month contract Richmond, VA Experis IT, formerly Comsys, is seeking a SQL Systems Analyst for a 1 month contract with a great client. This role will support the IT and Planning and Finance departments by analyzing and reconciling a backlog of data warehousing errors. The financial system is a custom built, tightly integrated suite of applications based on Microsoft technologies. A successful candidate will have experience in Microsoft decision support systems, specifically SQL Server 2005 and SQL Analysis Services 2000, and be comfortable working in a casual environment with IT developers and financial business users. Requirements: 4 years of experience with SQL Server Analysis Services 4 years of experience with SQL Server 2000 DTS 4 years of experience with Microsoft Excel Pivot tables Excellent communication orally and in writing Job Description: Identify solutions for drop errors/dimension failures and communicate with data owners. All data changes must be documented with a data change request, detailing the change and indicating the authority by which the change was made. Data changes may document themselves by including a printout of the TSQL code used to commit the change. List overloads by dimension join error and identify the codes that cause the error to the data owner. Research to determine the attributes causing the overload. Determine from data owner the intentions of the code change and perform repair/deletion as required. Both the production data and warehouse data changes are to be documented and the search and change TSQL needs to be included. Reconciliation of source and system data: The data owner will identify the summary as precisely as possible (using as many code discriminators as possible). Using the expected total and the warehouse total, compare summary sources to transactional source data. Adjust the fact table contents to reflect the reconciled content. Reprocess cubes and verify the analysis matches the operational summaries. Document all data changes.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 10184 while calling.   Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14),         (Analyst: SQL Server 2000 DTS, SQL Server Analysis Services, Microsoft Excel Pivot Tables, in CAPITOL, VA)

Featured Jobs JavaScript Html/Xhtml CSS Specialist (Jobs in Raleigh, North Carolina) Cybersecurity Splunk SIEM EDR Engineer (Jobs in Richmond, Virginia) Analyst (Jobs in Columbia, South Carolina) Azure Oracle Engineer (Jobs in Saint Paul, Minnesota) Engineer (Jobs in Lansing, Michigan) Oracle Engineer (Jobs in St Paul, Minnesota) Cisco Routers VLAN Network Administrator (Jobs in Fairfax, Virginia) Analyzing - Analyst (Jobs in Raleigh, North Carolina) SAS EHR SME Specialist (Jobs in Raleigh, North Carolina) SharePoint Finance Medicaid Expert (Jobs in Raleigh, North Carolina)