I have a very urgent DIRECT CLIENT requirement for BI Data Architect in Columbia, SC. Please Let Me Know If you have available candidate, please reply with their word resume, location, rate and contact number.
*Please send the resumes at [email protected] <[email protected]> * Job Title: BI Data Architect Location: Columbia, SC Duration: 12 Months Interview: Skype 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. Database Platforms SQL Server Yes 1 Lead Currently Using 2 - 4 Years Database Platforms SQL Server Analysis Services ( SSAS) Yes 1 Lead Currently Using 2 - 4 Years Database Platforms SQL Server Integration Services (SSIS) Yes 1 Lead Currently Using 2 - 4 Years Database Platforms SQL Server Reporting Services (SSRS) Yes 1 Lead Currently Using 2 - 4 Years Database Platforms SQL Tuning Yes 1 Lead Currently Using 2 - 4 Years Miscellaneous Business Intelligence (BI) Yes 1 Miscellaneous Dimensional Data Models (star and snowflake) Yes 1 Miscellaneous DWH - Data Cleansing Yes 1 Miscellaneous Hybrid On Line Analytical Processing - HOLAP Yes 1 Miscellaneous Multidimensional - MOLAP Yes 1 Miscellaneous Relational On Line Analytical Processing - ROLAP Yes 1 Miscellaneous Slowly Changing Dimensions (SDC) Yes 1 Miscellaneous Tabular Data Models Yes 1 Miscellaneous CAPSS Database No 1 Miscellaneous LCMS DATABASE No 1 Specialties OLAP Yes 1 Lead Currently Using 2 - 4 Years Specialties Reporting/OLAP/DW Yes 1 Lead Currently Using 2 - 4 Years Thanks, *Sunny Roy* 720-789-5728 Phone [email protected] -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/groups/opt_out.
