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 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 Business Analyst - 64266 Create date: 15-Apr-2025 Start date : 05/05/2025 End Date : 12/26/2025 Submission deadline : 04/18/2025 Client Info : CT OEC Note: * Position Location : Hybrid * Its a Part Time at office position. 25 hours per week , 2 days at office. Max $65. Feel free to send up-to 3 profiles Description :.... (This job is for - Jira Jobs in CT Hartford Analyst - (in Hartford, CT)) Mainframe Developer Intermediate - 63961 Create date: 18-Feb-2025 No of Submissions : 3 Start date : 03/03/2025 End Date : 03/31/2026 Submission deadline : 02/25/2025 Client Info : NeTRANS Note: * Candidate Must Be Local * Local candidates preferred for hybrid. Must be local or willing to relocate. * Position Location : Hybr.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) DMAS - EDWS System Analyst 4 (755876) Create date: 17-Jan-2025 No of Submissions : 2 Start date : 02/03/2025 End Date : 06/30/2025 Submission deadline : 1/22/2025 Client Info : DMAS Note: * Agency Interview Type : Web Cam Interview Only * Hybrid Description : Funding code: FAS-O, PRSS-O PCM-FY25-0033 .... (This job is for - job Jobs in VA Richmond Analyst - (in Richmond, VA)) Business Intelligence Developer-Data Analytics Strategy Lead Create date: 18-Dec-2024 No of Submissions: 2 Start date : 1/27/2025 End date : 01/23/2026 Submission deadline : 01/03/2025 Client info: CT DAS Note: * Position Location: Remote * Max Rate for this Position is USD 102.50 Per Hour Description: About the Role T.... (This job is for - job Jobs in CT Hartford Developer - (in Hartford, CT)) Technical Specialist IV - B36991W112 Create date: 28-Aug-2024 No of Submissions : 1 Start date : 09/23/2024 End Date : 09/23/2025 Submission deadline : 09/02/2024 Client Info : Bill Rate : USD 95.00 Per Hour Max Rate : USD 103.00 Per Hour Note: * Position Location : Remote * Candidate must be local or willin.... (This job is for - job Jobs in OR Salem Specialist - (in Salem, OR))     (Architect: Data Analysis, SQL, T-SQL, SQL Server 2008 SQL Server 2012 XML Data in Columbia, SC)

Featured Jobs PEOPLESOFT Developer (Jobs in Sacramento, California) Windows Analyst (Jobs in Culpeper, Virginia) ASP.Net Visual Developer (Jobs in Pontiac, Michigan) Testing Presentation Specialist (Jobs in Raleigh, North Carolina) Oracle Administrator (Jobs in Richmond, Virginia) JIRA Analyst (Jobs in Columbia, South Carolina) Writing Consultant (Jobs in Atlanta, Georgia) Bachelors Consultant (Jobs in Columbia, South Carolina) SQL Analyst (Jobs in Richmond, Virginia) EPIC EHR - Specialist (Jobs in Raleigh, North Carolina)