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    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 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)) DATA/INFORMATION ARCHITECT - 10648-1 Create date: 23-Nov-2022 start date : 12/1/2022 End date : 12 MONTHS from the start date submission deadline : 11/30/2022 client info : Department of Employment and Workforce Note : * INTERVIEW PROCESS (WHO WILL CONDUCT I/V, PHONE OR IN-PERSON, HOW MANY ROUNDS OF I/VS)? - PHONE OR IN-PERSON, 1 ROUND, CONDU.... (This job is for - SQL Jobs in SC COLUMBIA Architect - (in Columbia, SC)) GIS ANALYST-PROJECT LEAD-10595-1 Create date: 18-Oct-2022 start date: 11/7/2022 End date: 12 MONTHS from the start date. submission deadline: 10/25/2022 client info : Health & Environmental Control Department (DHEC) Note: * WORK LOCATION: FULLY REMOTE * INTERVIEW PROCESS: An interview panel will conduct one initial round of in.... (This job is for - PHI PII SQL Jobs in SC Columbia Analyst - (in Columbia, SC)) Systems Software Programmer Consultant - 10582-1 Create date: 28-Sep-2022 start date:10/26/2022 End date:12+ Months from start date submission deadline: 10/5/2022 client info : Department of Social Services Note: * INTERVIEW PROCESS (who will conduct i/v, phone or in-person, how many rounds of i/vs)? * Interview will be by video or in person and will be conduct.... (This job is for - IIS SQL Jobs in SC COLUMBIA Consultant - (in Columbia, SC)) Systems Software Programmer Project Lead - 10531-1 Create date: 25-Aug-2022 start date:9/19/2022 End date:1 YEAR submission deadline:8/31/2022 client info : Department of Social Services Note: * INTERVIEW PROCESS (phone, video or in-person, how many rounds of i/vs, etc)? * In-Person, or Video Conference. D.... (This job is for - IIS SQL TFS Jobs in SC COLUMBIA Consultant - (in Columbia, SC))    SQL Server job openings in other states Jobs List Database Administrator 5 -134957 Create date: 11-Sep-2024 No of Submissions : 1 start date : 10/14/2024 End date : 09/30/2025 submission deadline : 9/18/2024 at 10am EST client info : DOC Note: * Duration: 1 year with extension likely * Hybrid: Will need to be onsite from day 1, two days a week. Wednesdays are required to be .... (This job is for - SQL Troubleshooting Unix Linux Jobs in MI Lansing Administrator - (in Lansing, MI)) NC - Meck County - Sr IT QA Analyst (744246) Create date: 09-Aug-2024 No of Submissions : 2 Start date : 08/16/2024 End Date : 04/30/2025 Submission deadline : 08/12/2024 Client Info : Mecklenburg County - Information Technology Services - Quality Services Note: * Agency Interview Type : Either Webcam Interview or In Person * This is a remot.... (This job is for - SQL DevOps Jobs in NC Charlotte Analyst - (in Charlotte, NC)) SCB -C Developer/ Programmer Analyst (741580) Create date: 01-Jul-2024 Hybrid No of Submissions : 2 start date :08/05/2024 End date :06/30/2025 submission deadline : 7/4/2024 client info : SCB Note: * Agency Interview Type: Web Cam Interview Only Description : The Compensati.... (This job is for - SQLT SQL Jobs in VA Richmond Analyst - (in Richmond, VA)) .NET Web Developer III - 129487 Create date: 17-Apr-2024 No of Submissions : 2 Start date : 05/20/2024 End date : 06/30/2024 Submission deadline : 4/19/2024 at 4:00PM CST. Client info : DCF Note : * Interviews will be scheduled April 24-26th INTERVIEW NOTES: PLEASE NOTE: A real-time screenshot photo of the candidate MUST be uplo.... (This job is for - DB2 SQL Jobs in WI Madison Developer - (in Madison, WI)) VDOT Programmer Analyst .NET Core (728389) Create date: 07-Feb-2024 Hybrid Start date :02/20/2024 End Date :06/30/2024 Submission deadline : 2/12/2024 Client Info :VDOT Description : ------------------------------------------------------ **Mgr requests vendors ONLY submit candidates who already live in Richmond, VA **ALL interviews ONSITE *.... (This job is for - SQLCSS3 Jobs in VA Richmond Analyst - (in Richmond, VA))    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)

Featured Jobs AWS .NET FRAMEWORK UI CSS Tester (Jobs in Little Rock, Arkansas) Microsoft Consultant (Jobs in Nashville, Tennessee) - Consultant (Jobs in Nashville, Tennessee) Written Specialist (Jobs in Salem, Oregon) VLAN Subnets Routing Engineer (Jobs in Staunton, Virginia) Training Specialist (Jobs in Atlanta, Georgia) Adobe Analyst (Jobs in Jackson, Mississippi) MS Office EHR Consultant (Jobs in Richmond, Virginia) Information Manager (Jobs in Madison, Wisconsin) Jira UFT Defect Tester (Jobs in Raleigh, North Carolina)