Relational Database Experience SQL Server Integration Services TSQL Queries ETL Pr   Requirement id 45529 Job title Architect Job location in Columbia, SC Skills required Written And Verbal Communication Skills, ETL Tools, MS SQL Server 2012, Relational Database Experience SQL Serve Open Date 04-May-2015 Close Date Job type Not specified Duration 7 Months Compensation DOE Status requirement --- Job interview type --- Apply    Email Recruiter: coolsoft Job Description Architect: Written And Verbal Communication Skills, ETL Tools, MS SQL Server 2012, Relational Database Experience SQL Serve Description: The client has implemented a Data Warehouse and related software components for purposes of tax and revenue compliance and analysis. The Data Warehouse also serves as a primary data source for other business intelligence activities. This work involves proprietary software from Revenue Solutions Inc. (RSI), particularly their Portfolio Warehouse (PW) product. Historically, the Data Warehouse application team has used the proprietary Embarcadero DT/Studio tool, along with custom transform code from RSI, to load data from federal and state data sources into the Data Warehouse. The team is now charged with converting all of the data load processes to use Microsoft SQL Server Integration Services (SSIS) At this time an experienced ETL (Extract, Translate, and Load) specialist with expertise in SSIS is needed to assist in this process. Specific Duties and Responsibilities: The following application tasks are expected to be executed by the Data Warehouse systems software developer ETL specialist. All tasks will involve some degree of up front analysis prior to development or execution, as well as several phases of system and user acceptance testing. These tasks/skills do not include database administration support or technical infrastructure support tasks, as these responsibilities fall under a different support area within the SCDOR IRM organization. • Responsible for building ETLs using SSIS packages to load data from various data sources including files from internal and external data sources. • Setting up and running the proprietary Portfolio Warehouse Associate and Grow (A&G) offline process for data cleansing and matching of these files. This includes configuring the A&G match keys with consultation from the business users and SCDOR Data Warehouse team. • Conduct quality assurance for loaded data. • Creating and executing “views” as required by business users. • Performing database utility functions, such as SQL Server Analytical Services for OLAP, development of stored procedure, SSIS, etc. as needed for loading and analysis of data. Required Skills: * Verbal Communication Skills * Written Communication Skills * Extract * Load (ETL) tools * MS SQL Server 2012 * Relational Database Experience * SQL Server Integration Services (SSIS) * Transform * T/SQL Queries * ETL Process and Development * Requirements Gathering * Teamwork * Windows 7 * Windows Server 2012 * deployment methodology concepts including design, build, testing, and deployment * PLC - Project Life Cycle Methodology * C# * Java * Testing skills * Data Warehousing * Datamart Desired Skills: * Team Foundation Server (TFS) 2012 * SSIS EXPERTISE REQUIRED Background Checks: * Employment Verification - 7 year history * Criminal Record - 7 Year History * Professional Reference * E-Verify * Education Verification * Credit Report - 7 Year History * South Carolina Law Enforcement Division (SLED) Check via website   Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 45529 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), Written And Verbal Communication Skills job openings in Columbia, SC Jobs List Data/Information Architect - Project Lead - 8408 - Rebid Create date: 17-Oct-2025 Start date :11/17/2025 End Date :11/16/2026 Submission deadline :10/23/2025 5:00 PM EST. Client Info : ADMIN Note: * Interview Process: One round of virtual interviews. * Work Location: Columbia SC. 25% HYBRID schedule to be determined by the manager. * Candidate Location.... (This job is for - ITIL NIST Jobs in SC Columbia Architect - (in Columbia, SC)) SYSTEMS SOFTWARE PROGRAMMER -11679-1 Create date: 13-May-2025 Start date : 7/1/2025 Submission deadline : 5/21/2025 Client Info : Department of Revenue Note: Q) INTERVIEW PROCESS (phone, video, or in-person, how many rounds of i/vs, etc.)? A) 1, 2, possibly 3 interviews via phone and/or video. Local candidates can be in-person Description : <.... (This job is for - PMP Jobs in SC Columbia Consultant - (in Columbia, SC)) SAP FUNCTIONAL TEAM LEAD CONSULTANT - 11655-1 Create date: 05-May-2025 Start Date :6/6/2025 End Date :Duration 12 months from start date Submission Deadline :5/12/2025 Client Info: Department of Administration Note: * INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? * In person or telephone interview with hiring.... (This job is for - job Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) Systems Administrator - Advanced-11619-1 Create date: 24-Mar-2025 Start date : 4/17/2025 Submission deadline : 4/1/2025 Client Info : Department of Revenue Note: Q) INTERVIEW PROCESS (phone, video, or in-person, how many rounds of i/vs, etc)? A) One to two rounds of in-person interviews (video or phone options available as needed, but not preferred) Teamwork Jobs in SC Columbia Administrator - (in Columbia, SC)) BUSINESS ANALYST-ADVANCED-11575-1 Create date: 21-Feb-2025 No of Submissions : 2 Start date : 03/05/2025 Submission deadline : 2/28/2025 Client Info : SC Department of Public Health (DPH) Note: Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? A) An interview panel will conduct one initial round of in.... (This job is for - job Jobs in SC COLUMBIA Analyst - (in Columbia, SC))    Written And Verbal Communication Skills job openings in other states Jobs List NCDHHS - APD Writer (790018) Create date: 30-Dec-2025 Start date : 01/14/2026 End Date : 09/15/2026 Submission deadline :01/06/2026 Client Info : NCDHHS-PH Note: * Agency Interview Type: Webcam Interview Only * Work Arrangement : Remote Description: This position develops Advanced Planning Documents (APD),and other do.... (This job is for - APD Jobs in NC Raleigh Consultant - (in Raleigh, NC)) Product Specialist - Digital Accessibility Trainer Create date: 01-Dec-2025 Start date :1/19/2026 End Date : 01/15/2027 Submission deadline : 12/08/2025 Client Info : CT DAS Note: * Position Location: Remote Description: This Digital Accessibility Trainer role is critical to training agency teams, testers, developers, and content owners on accessib.... (This job is for - UX Jobs in CT Hartford Specialist - (in Hartford, CT)) DCY- IT Consultant 2-ITC2 (779681) Create date: 13-Nov-2025 Start date : 12/01/2025 End Date : 06/30/2026 Submission deadline : 11/18/2025 Client Info : DCY Note: * In person interviews ONLY * On site 5x week downtown Columbus * Candidates local to Columbus, Ohio preferred. Description : This position serves.... (This job is for - job Jobs in OH Columbus Consultant - (in Columbus, OH)) Program Manager - Prog Manager Create date: 23-Oct-2025 Start date :11/10/2025 End Date :06/30/2026 Submission deadline:10/31/2025 Client Info : CT OHS Note: * Candidate Must Be Local * Hybrid Position Description: Role Overview The contracted individual will support the Connecticut Office of Health Strate.... (This job is for - job Jobs in CT Hartford Manager - (in Hartford, CT)) Technician III - 149927 Create date: 17-Oct-2025 Start date :11/10/2025 End Date :02/27/2026 Submission deadline : 10/24/2025 4:00:00 PM Client Info : UW - System Administration Note: * Interview Process: Microsoft Teams interviews - 30 minutes (20 minutes with 10 minutes for candidate questions) * Duration of the Contract: Until.... (This job is for - VMWare Jobs in WI Madison Consultant - (in Madison, WI))    Written And Verbal Communication Skills job openings in SC Jobs List WEB/INTERNET ENGINEER-PROJECT LEAD - 11697-1 Create date: 13-Jun-2025 Start date : 6/25/2025 Submission deadline : 6/23/2025 Client Info : SC Department of Public Health (DPH) Note: Q) INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? A) An interview panel will conduct one initial round of in person, video, or phone conference.... (This job is for - job Jobs in SC CAYCE Engineer - (in CAYCE, SC)) BUSINESS ANALYST ADVANCED - 11570-1 Create date: 17-Feb-2025 No of Submissions : 2 Start date : 3/7/2025 Submission deadline : 2/25/2025 Client Info : Department of Administration Note: Q) INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? A) Initial round of phone interviews with in-person interview preferred before .... (This job is for - job Jobs in SC COLA Analyst - (in COLA, SC)) INFORMATION SECURITY ANALYST - ENTRY - 11185-1 Create date: 10-Apr-2024 Start date : 5/1/2024 Submission deadline : 4/17/2024 Client info : Clemson University Note : * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? Frank Monteleone will perform phone interviews. An in person follow up interview will include Frank Monteleone, Ben Spark.... (This job is for - Cybersecurity Jobs in SC Seneca Analyst - (in SENECA, SC)) TECHNICAL PROJECT MANAGER - 10491-1 Create date: 12-Aug-2022 start date:9/8/2022 End date:12 MONTHS FROM START DATE. submission deadline:8/16/2022 client info: Department of Transportation Description: TAKE DIRECTION FROM SCDOT OFFICE OF PUBLIC TRANSIT AND SCDOT IT SERVICES SOFTWARE DEVELOPMENT GROUP, PROVIDE EN.... (This job is for - job Jobs in SC Colombia Manager - (in Colombia, SC)) IT HEALTHCARE DEVELOPMENT TOOLS ADMINISTRATOR - 10399-1 Create date: 03-Jun-2022 start date:6/23/2022 submission deadline:6/8/2022 client info : Clemson University Note: * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? * Phone interviews will be conducted. Anticipate one round of interviews. .... (This job is for - job Jobs in SC Colombia Administrator - (in Colombia, SC)) (Architect: Written And Verbal Communication Skills, ETL Tools, MS SQL Server 2012, Relational Database Experience SQL Serve in Columbia, SC)

Featured Jobs Business Analyst - Analyst (Jobs in Tallahassee, Florida) Business Analyst - Analyst (Jobs in Tallahassee, Florida) Business Analyst - Analyst (Jobs in Austin, Texas) ServiceNow Specialist (Jobs in Raleigh, North Carolina) Quality Assurance MS Consultant (Jobs in Durham, North Carolina) Infrastructure Developer (Jobs in Raleigh, North Carolina) ETL Analyst (Jobs in Richmond, Virginia) APD Consultant (Jobs in Raleigh, North Carolina) Business Analyst LMS Consultant (Jobs in Durham, North Carolina) Warehouse Developer (Jobs in Lincoln, Nebraska)