T-SQL SQL Server 2008 SQL Server 2012 XML Data Xpath Xquery Windows 2012 Server Env   Requirement id 48761 Job title Architect Job location in Columbia, SC Skills required Data Analysis, SQL, T-SQL, SQL Server 2008 SQL Server 2012 XML Data Open Date 24-Sep-2015 Close Date Job type Not specified Duration 8 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Architect: Data Analysis, SQL, T-SQL, SQL Server 2008 SQL Server 2012 XML Data Description: 1. Works with consultants, application developers and end users to develop the logical data model and data architecture of assigned application. Designs relational databases within the architectural framework to meet application needs. Serves as lead database designer for Business Intelligence systems. Develops and implements standards for database design in a denormalized environment. 2. Analyzes anticipated data volumes and patterns of use; gains knowledge of agency data usage to improve performance and efficiency of database access and manipulation. 3. Writes and maintains stored procedures as needed; develops standards for the use of stored procedures, object relational mappers, and other means of database access. Develops standards for application handling of databases, including error handling. Builds database utilities as needed for application use, such as SQL Server Integration Services (SSIS) packages and database scripts. 4. Supports application developers. Assists application developers in resolving database related application problems, both in development and in production. Works with Database Administration to resolve database performance problems. Required to respond to emergency system issues on a 24/7 basis. 5. Contributes to the Business Intelligence data dictionary for application and business user development. Develops and implements standards for naming of database objects. 6. Performing database development and utility functions, such as SQL Server Analytical Services for OLAP, T-SQL, stored procedure, SSIS, etc. as needed for loading and analysis of data. Required Skills: • Experience and expertise in developing data analysis and requirements from business user requirements. • Experience and expertise in SQL, including development of T/SQL queries, stored procedures and data manipulation. Expert knowledge of databases and relational database concepts. Experience with SQL Server 2008 is desirable; experience with SQL Server 2012-14 is required. • Experience with use of XML data, and XML tools such as XPath and XQuery. • Experience with Windows 7 operating system and the Windows 2012 server environment. • Experience with Business Intelligence concepts, including the use of Extract, Transform, and Load (ETL) tools and creation of data marts. Expertise in SSIS is required. • Ability to communicate clearly and concisely, both orally and in writing. • Ability to establish and maintain good working relationships with business users, management, vendors, and peers. • Strong organizational, multi-tasking, and time-management skills. Ability to complete assignments on time. • Understanding of deployment methodology concepts including design, build, testing, and deployment. Desired Skills: • MS SQL Server 2008 R2 • Experience in financial systems (AR, AP, payment reductions, general ledger postings and reporting, etc.); • Ability to analyze and document, business and system processes using various methods and tools. • ABILITY TO DEVELOP, COMMUNICATE AND PRESENT PROJECT DOCUMENTATION AND REPORTS • Analytical Skills • Business Intelligence (BI) • Business Objects • CREATION OF TEST SCENARIOS • Experienced Data Architect with extensive Experience performing Data Modeling, data mapping, data cleansing, and building data dictionaries.   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 48761 while calling.   Other jobs in SC: Beaufort (1), Blythewod (2), Blythewood (3), Charleston (17), Columbia (37), Greenville (4), Hartsville (2), North Charleston (2), Overland Park (1), San Francisco (1), SENECA (4), South Carolina (1), Spartanburg (3), Unknown (2), Data Analysis job openings in Columbia, SC Jobs List CONSULTING DIRECTOR-11649-1 Create date: 30-Apr-2025 Start date : 5/12/2025 End Date : 10/21/2025 Submission deadline : 5/5/2025 Client Info : Blind Commission Note: Q) INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)? A) VIRTUAL – MICROSOFTTEAMS INTERVIEW UP TO 2 ROUNDS OF INTERVIEWS Tableau Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) Data/Information Architect - Advanced-11534-1 Create date: 30-Jan-2025 No of Submissions : 2 Start date : 2/25/2025 Submission deadline : 2/6/2025 Client Info : Department of Health and Human Services Note: Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/v)? A) The interviews will be conducted via Microsoft Teams. V.... (This job is for - job Jobs in SC Columbia Architect - (in Columbia, SC))    Data Analysis job openings in other states Jobs List VSP - Help Desk Analyst 4 - (774531) Create date: 08-Aug-2025 Start Date :9/1/2025 End Date :06/30/2026 Submission Deadline :08/13/2025 Client Info : VSP Note: * Please Submit your Best two candidates * Candidates must be able to work on site. * Local Candidates Strongly Preferred. * Please submit your top .... (This job is for - job Jobs in VA NorthChesterfield Analyst - (in North Chesterfield, VA)) Business Analyst/Consultant IV - 143210 Create date: 30-May-2025 Start date : 07/28/2025 End Date : 06/30/2026 Submission deadline : 6/6/2025 4:00:00 PM Client Info : ETF Note: * Interview Process: remote via MS Teams * Duration: 6/30/2026, likely to extend * Onsite or Remote? Must be a current WI resident. This position can work .... (This job is for - Stakeholders Jobs in WI Madison Analyst - (in Madison, WI)) Mainframe Developer Intermediate - 64454 Create date: 30-May-2025 Start Date :6/23/2025 End Date :07/01/2026 Submission Deadline : 06/06/2025 Client Info : NeTRANS Note: * Candidate Must Be Local * Local candidates preferred for hybrid. Must be local or willing to relocate Description: Requiremen.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) Systems Analyst - RFS 64394 Create date: 28-May-2025 Start Date :6/23/2025 End Date :06/30/2026 Submission Deadline :05/30/2025 by 8:00 A.M. CST Client Info: TN- Tennessee Department of Health (DOH) Note: * Position Location: * On-Site. In-person, with the potential for remote work upon completion of training a.... (This job is for - SQL Jobs in TN Nashville Analyst - (in Nashville, TN)) Elect - Business Analyst 3 (764331) Create date: 21-May-2025 Start date : 06/02/2025 End Date : 12/31/2025 Submission deadline : 05/28/2025 Client Info : ELECT Note: * Agency Interview Type : Web Cam Interview Only * Remote Description : ELECT is seeking a Business Analyst who is proficient in gathering and documenting b.... (This job is for - Business Analyst Jobs in VA Richmond Analyst - (in Richmond, VA))     (Architect: Data Analysis, SQL, T-SQL, SQL Server 2008 SQL Server 2012 XML Data in Columbia, SC)

Featured Jobs Problem Manager (Jobs in Lansing, Michigan) outlook MS Office SLAs Analyst (Jobs in Conyers, Georgia) Customer Analyst (Jobs in North Chesterfield, Virginia) Word Analyst (Jobs in Richmond, Virginia) SharePoint Microsoft Specialist (Jobs in Raleigh, North Carolina) Power Consultant (Jobs in Raleigh, North Carolina) DNS IIS DHCP Administrator (Jobs in Pontiac, Michigan) ASP.net Consultant (Jobs in Columbus, Ohio) COTS LANS VLANs Specialist (Jobs in Raleigh, North Carolina) JavaScript MS Consultant (Jobs in Columbus, Ohio)