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 Project Manager Expert - 65419 Create date: 04-Mar-2026 Start date : 03/23/2026 End Date : 03/31/2027 Submission deadline : 03/11/2026 Client Info : NeDHHS Note: * Position Location : On Site * Candidate Must Be Local Description : The Senior Project Manager leads the planning, execution, and delivery of complex he.... (This job is for - Stakeholders Jobs in NE Lincoln Consultant - (in Lincoln, NE)) NC Fast Child Welfare Readiness Liaison (796832) Create date: 02-Mar-2026 Start date : 03/09/2026 End Date : 03/08/2027 Submission deadline : 03/09/2026 Client Info : NCDHHS-NCFAST Note: * Agency Interview Type : Either Webcam Interview or In Person * Hybrid * IMPORTANT NOTE: Extensive statewide travel up to 90% of the time is required in the p.... (This job is for - Stakeholders Jobs in NC Durham Consultant - (in Durham, NC)) Application Power BI Developer Intermediate - 65374 Create date: 12-Feb-2026 Start date :3/9/2026 End Date :09/30/2026 Submission deadline :02/20/2026 Client Info : NeDHHS Note: * Position Location: Remote Description: Data Visualization Developer SUMMARY: As a Data Visualization Developer, you can contribute your skills as we ha.... (This job is for - job Jobs in NE Lincoln Developer - (in Lincoln, NE)) IT Business Systems Analyst Advanced - 65361 Create date: 10-Feb-2026 Start date : 03/09/2026 End Date : 05/21/2027 Submission deadline : 02/20/2026 Client Info : NeDHHS Note: * position : Remote * Would prefer a candidate that could be hybrid and available to be in the office. * Candidate must be local or willing to commute or relocate..... (This job is for - Analytical Skills Jobs in NE Lincoln Analyst - (in Lincoln, NE)) VITA - Cybersecurity Engineer 3 - TWO ROLES (795168) Create date: 05-Feb-2026 Start date :3/1/2026 End Date :04/30/2026 Submission deadline :2/11/2026 Client Info : VITA Note: * Role is 100% remote however if selected candidates will be required to attend monthly meetings onsite in Richmond. For this reason, the preference is for local Richmond candidates. * Agen.... (This job is for - job Jobs in VA Richmond Engineer - (in Richmond, VA))    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 SQL Developer (Jobs in Columbia, South Carolina) Kronos HCM Accounting Consultant (Jobs in Columbia, South Carolina) Excel Specialist (Jobs in Nashville, Tennessee) Communication Developer (Jobs in Nashville, Tennessee) Angular React Java Developer (Jobs in Richmond, Virginia) REST JMeter Analyst (Jobs in Lansing, Michigan) SQL Analyst (Jobs in Lansing, Michigan) - Developer (Jobs in Columbia, South Carolina) ALM Tracking Analyst (Jobs in Columbus, Ohio) Stakeholders Data Manager (Jobs in Madison, Wisconsin)