Previous Job
Previous
Data/Information Architect
Ref No.: 13-01172
Location: COLUMBIA, South Carolina
Department of Social Services
18-24 Months
Skype Interviews
Columbia SC


This position will most likely last 18-24 months.
Manager is requiring Skype video interviews.
This means candidate's should present themselves professionally in both appearance and environment. Meaning....dress professional, quiet/private interview environment.....No Pajama's, shorts, t-shirt or TV or other distractions in the background.

Any interviews posted for his opportunities must be conducted within the following hours:
Between 9:30-11:30 and 1:30-3:30
Therefore, if an interview is requested and the candidate cannot make the dates and times provided in the request. Please make sure you request a new date with the above mention time frames noted.
It is assumed that resumes will reflect quality of candidate. Unorganized and unprofessional resumes will be promptly disregarded. Resumes should be no more than 2 pages.
Candidates submitted above the average bill rate are expected to be above average in skill set, knowledge and ability.

A final decision will not be made until all resumes are reviewed. This is a critical position and critical judgment will be made in the hiring decision.
SCOPE OF THE PROJECT:

ONGOING 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, KPI's 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
Category
Name
Required
Importance
Level
Last Used
Experience
Database PlatformsSQL ServerYes1LeadCurrently Using2 - 4 Years Database PlatformsSQL Server Analysis Services ( SSAS)Yes1LeadCurrently Using2 - 4 Years Database PlatformsSQL Server Integration Services (SSIS)Yes1LeadCurrently Using2 - 4 Years Database PlatformsSQL Server Reporting Services (SSRS)Yes1LeadCurrently Using2 - 4 Years Database PlatformsSQL TuningYes1LeadCurrently Using2 - 4 Years MiscellaneousBusiness Intelligence (BI)Yes1 MiscellaneousDimensional Data Models (star and snowflake)Yes1 MiscellaneousDWH - Data CleansingYes1 MiscellaneousHybrid On Line Analytical Processing - HOLAPYes1 MiscellaneousMultidimensional - MOLAPYes1 MiscellaneousRelational On Line Analytical Processing - ROLAPYes1 MiscellaneousSlowly Changing Dimensions (SDC)Yes1 MiscellaneousTabular Data ModelsYes1 MiscellaneousCAPSS DatabaseNo1 MiscellaneousLCMS DATABASENo1 SpecialtiesOLAPYes1LeadCurrently Using2 - 4 Years SpecialtiesReporting/OLAP/DWYes1LeadCurrently Using2 - 4 Years
Additional Skills: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
Tabular Data Models
Dimensional Data Models (star and snowflake)
Data Warehouse Skills
Data Cleansing
ETL Process
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
Staging and Aggregating Data
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)