Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
Executive Order 11246, Section 503 & VEVRAA EOE, including disability/vets
SQL SSAS OLAP Data Models ETL Tools Data Warehouse Specialist
(Jobs in Columbia,
 
Requirement id 16826
Job title Specialist
Job location in Columbia, SC
Skills required SQL Server, SSRS And SSIS, SSAS, OLAP Data Models ETL Tools Data Warehous
Open Date 22-Dec-2013
Close Date
Job type Not specified
Duration 24 Months
Compensation DOE
Status requirement ---
Job interview type Phone Screening
Apply
   Email Recruiter: coolsoft
Job Description Specialist: SQL Server, SSRS And SSIS, SSAS, OLAP Data Models ETL Tools Data Warehous

[Note : Deadline 26th Dec 2013, Skype video interviews]

Scope of the project:
On-going project to deliver an end to end business intelligence solutions containing dashboards and reports.

Candidate will be responsible for creating, designing and developing logical and systematic layers used for end user dashboards, reports, KPIs and analytics. Utilizing the Microsoft stack of BI tools (SQL Server, SSIS, SSAS, SSRS), the candidate will be responsible to:
Participate and at times lead in the gathering and documenting of data and analytical requirements.

Design a logical blueprint for data design, extraction process, transformation methods, and presentation layout.
Provide time and effort estimates for components of the BI solution.
Develop logical and physical data model for data marts.
Design data warehouses and create data cubes.
Develop and promote data management methodologies and standards.

Required skills (rank in order of importance):

Technical Skills
• SQL Server, SSIS, SSAS, SSRS
• Best practice and standards for Business Intelligence (BI) On Line Analytical Processing (OLAP). (Multidimensional - MOLAP, Relational - ROLAP, and Hybrid - HOLAP)
• OLAP data models
o Tabular Data Models
o Dimensional Data Models (star and snowflake)
• Data Warehouse Skills
o Data Cleansing
• ETL Process
o Slowly Changing Dimensions (SDC) Types 1,2, and 3. i.e. data that changes over time.
SDC Type 1 - Over write data changes
SDC Type 2 - Add a row for data changes
SDC Type 3 - Add a column for data changes
o Staging and Aggregating Data
o Error and Data anomaly handling
• Multidimensional Expressions (MDX) queries
• Key Risk Indicators (KRIs)
• Key Performance Indicators (KPIs)
Tool-Set Skills
• SSAS
• SSIS
• SSRS
• Power Pivot
• Performance Point
• TSQL
• SQL Server (Performance Tuning)

Preferred Skills (rank in order of Importance):

Intimate knowledge of CAPSS and LCMS database design.
Strong Project skills
Self Starter
Minimal Management required
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 16826 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),
SQL Server job openings in Columbia, SC
Jobs List

Senior Application Developer - 10662
Create date: 10-Apr-2026
Start date :5/11/2026
End Date :12 Months from projected start date

Submission deadline :4/17 at 5:00 PM EST.

Client Info : SCCOURTS

Note:

* Interview Process: 1 round, virtual

* Work Location: Role is 100% remote

* Candidate location: No SC residency required. Candidate mu.... (This job is for - SQL Debugging Jobs in SC Columbia Developer - (in Columbia, SC))

Senior Application Developer - 10331
Create date: 23-Mar-2026
Start date : 04/20/2026

End Date : 12 Months from projected start date

Submission deadline : 3/30/2026 5:00:00 PM

Client Info : SCCOURTS

Note:

* Interview Process: 1 round, virtual

* Duration of the Contract: 12 months

* Possibility for Extension: Yes

* .... (This job is for - SQL Jobs in SC Columbia Developer - (in Columbia, SC))

Database Administrator - Advanced - 10356
Create date: 23-Mar-2026
Start date : 04/20/2026

End Date : 12 Months from projected start date

Submission deadline : 3/30/2026 5:00:00 PM

Client Info : DES

Note:

* Interview Process: 1 round, Virtual/Online

* Duration of the Contract: 12 months

* Possibility for Extension: Yes

* .... (This job is for - SQLEncryption Jobs in SC Columbia Administrator - (in Columbia, SC))

IT Healthcare Consultant - 8307
Create date: 03-Oct-2025
Start Date : 10/22/2025
End Date : 12 Months from projected start date

Submission Deadline : 10/10/2025 5:00:00 PM

Client Info : Clemson University

Note:

* Interview Process: 1 round, virtual

* Duration of the Contract: 12 months

*Possibility for Extension.... (This job is for - SQL Jobs in SC Columbia Consultant - (in Columbia, SC))

SYSTEMS ENGINEER - PROJECT LEAD-10761-1
Create date: 20-Mar-2023
Start date :4/17/2023
End Date :12+MONTHS from the start date

Submission deadline :3/27/2023

Client Info :Department of Health and Human Services

Note:
* INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY
ROUNDS OF I/VS)?

* WEBEX FOR INITIAL INTERVIEW. IN-PERSON OR VIDE.... (This job is for - SQL Jobs in SC COLUMBIA Engineer - (in Columbia, SC))
 
 SQL Server job openings in other states
Jobs List

Integration Data Engineer
Create date: 21-Apr-2026
Integration Data Engineer
Middleton, WI

• Implement the layer of data APIs that loads data into the data lake in real time to support streaming pipelines using REST APIs and Mulesoft
• Develop and maintain several interfaces that allow patient ingestion into our application
• Maintain the customer data and to make configur.... (This job is for - Python SQL Jira Jobs in WI Middleton Engineer - (in Middleton, WI))

Programmer/Developer - RFS 65518
Create date: 27-Mar-2026
Start date : 05/01/2026

End Date : 06/30/2027

Submission deadline : Due to SCS 04/07/2026by 8:00 A.M. CST

Client Info : Tennessee Department of Health (TN-DOH)

Note:

* Integrated Data System Position – Snowflake (Data Engineer)

* This posting is for TN residents only, with a requi.... (This job is for - SQL AWS Jobs in TN Nashville Developer - (in Nashville, TN))

GDOT - Power BI Sr. Developer (796126)
Create date: 13-Mar-2026
Start date :4/6/2026
End Date :06/30/2026

Submission deadline :03/18/2026

Client Info : GDOT - IT App

Note:

* Work Arrangement: Hybrid

Description:

Seeking an experienced Power BI Developer with a strong background in semantic data modeling, advanced DAX programming, data v.... (This job is for - SQL Jobs in GA Atlanta Developer - (in Atlanta, GA))

Database Administrator 3 - 156362
Create date: 13-Mar-2026
Start date : 03/30/2026

End Date : 1 Years from projected start date

Submission deadline : 3/18/2026 10:00:00 AM

Client Info : DHHS

Note:

* - Interview Process: Virtual Interview via MS Teams video. May have a second round interview onsite if needed.

* Duration: 1 year with po.... (This job is for - SQL Jobs in MI Lansing Administrator - (in Lansing, MI))

Data Conversion Lead - Mid Level (791876)
Create date: 22-Jan-2026
Start date : 02/23/2026

End Date : 02/22/2027

Submission deadline : 01/28/2026

Client Info : NCDOR

Note:

* Agency Interview Type : In Person Only

* This is a hybrid position. The candidate will be working up to four days a week in the Raleigh office.

Description :
.... (This job is for - Strategies SQL Jobs in NC Raleigh Consultant - (in Raleigh, NC))
 
 SQL Server job openings in SC
Jobs List

SQL Developer - 64726
Create date: 07-Jul-2020
Candidate must be our W2 Employee.

Candidate must be local : Yes

We should submit only GC,GC - EAD, L2-EAD,H4-EAD and Citizens.

Job Description : Top requirements::

7+ years

SQL development/reporting

SSIS exp (be able to read it, ideally some creation exp as well)

SSRS ex.... (This job is for - SQL SSIS SSRS Jobs in SC FortMill Developer - (in Fort Mill, SC))
(Specialist: SQL Server, SSRS And SSIS, SSAS, OLAP Data Models ETL Tools Data Warehous in Columbia, SC)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us