HOTREQ: BI Analyst---- Location: TN---Duration:6Months.

Hi Business Partners,

Kindly check with the requirement and let me know if you have any suitable resources available with you. Please respond with Resume, Rate and Phone numbers of the Consultant. Make sure the Consultants skills match the requirement. Send resume to businessexec14@valconusa.com

 

Position :BUSINESS INTELLIGENCE ANALYST

Location  :TN

Duration  : 6 Months

Start Date: Immediate

Rate: Doe

 

General Summary The job's primary purpose and overall scope of responsibility.

Business Intelligence Analyst is an expert in one or more BI tools, captures analytical and reporting requirements, performs source data analysis, develops the semantic layer and metadata, and creates reports, dashboards and OLAP solutions. Creates and delivers IT and end-user training and provides second-line support to power users who develop reports on behalf of their departmental colleagues.

 

 

Core Responsibilities The job's most important functions and responsibilities and percentage of time.

30 % 1.  Understands the business questions that users are trying to get answered and translates them into Business requirements. Profiles source system data, identifies data anomalies and proposes data cleansing rules. Customizes BI tools to meet user needs. Defines and captures Metadata and rules associated with BI processes.   20 % 2.  Sets design specifications for end-user semantic layers and multi-dimensional models across BI environments. Identifies user profiles and designs report delivery environment to meet users' needs.    30 % 3.  Develops Semantic layer or BI objects for end users. Creates reports and report templates, performance dashboards and Adhoc analysis environments. Develops BI tool training and documentation. Trains users in using the toolset and data. Mentors less experienced BI Developers in these areas.   20 % 3.  Implements and supports complex BI processes. Troubleshoots BI tool problems and tunes for performance. Adapts BI processes to accommodate changes in source systems and new business user requirements. Supports client areas in their analytical functions.

 

 

 

Job Requirements The level of education, experience, specialized knowledge or skills, and competencies necessary to perform the duties of the job.
Education: This position normally requires:    High School Diploma    AA    AS    BA    BS    MA    MS    PhD   Certification/Licenses:        Other (Please specify)   Please refer to this table for experience and fiscal responsibility definitions.
Experience                                                       Fiscal Responsibility
A	Less than 1 year	NI	No impact
B	1 to 2 years	SI	Some Impact
C	3 to 5 years	PA	Participates or advises management
D	8 to 10 years	MR	Major role, but not final authority
E	More than 10 years	OMR	Overall management responsibility
Experience:   ·         1-3 years experience with Microsoft BI Solutions (Reporting Services, Excel Services, SQL Server Analysis Services, Microsoft Office Sharepoint Server(MOSS) and/or Performance Point Server). ·         2-3 years experience with Data Warehousing environments / corresponding concepts ·         1-3 years experience using data structures such as highly normalized data models, Star Schemas and Snowflake Schemas ·         1-3 years experience in building Dashboards and integration with Portals like WebSpace and MOSS   Fiscal Responsibility: $                      revenue and/or budget    NI   SI      PA     MR    OMR                                                             accountability   Knowledge, Skills and Abilities Summarize the kinds and level of knowledge, skills and abilities your job requires.   Knowledge of:   ·         Business Intelligence tool architecture, features and functionality ·         Relational databases like SQL Server and Oracle ·         Hospitality industry business models and data ·         Familiarity with CRM and Campaign Management solution implementations ·         Data modeling concepts (star schemas, snowflake schemas, highly normalized data models), and familiar with data modeling tools such as Erwin or PowerDesigner ·         Familiar with physical database administration concepts such as table partitioning, materialized views, indexing strategies, aggregate navigation and their role within the decision support environment ·         Familiar with OLAP and multi-dimensional database technologies such as Hyperion Essbase or SQL Server Analysis Services ·         Familiar with hardware concepts such as SMP and MPP architectures and their impact on the BI environment   Skill In:     ·         Excellent at performance tuning BI processes and queries (concepts such as caching, sorting, and indexing) ·         Excellent SQL programming skills ·         Excellent relational database knowledge ·         Excellent problem solving skills ·         Excellent communication skills with both business and technical customers   Ability To: ·         Demonstrate a high level of integrity and maturity ·         Work on multiple projects and deliver consistently on time ·         Escalate issues appropriately to management and project team ·         Take a proactive approach to cross-functional communication ·         Actively seek out feedback from management and peers, improve own performance based on that feedback

--
You received this message because you are subscribed to the Google Groups "Best IT Consulting Group" group.
To post to this group, send email to best-it-consulting-group@googlegroups.com.
To unsubscribe from this group, send email to best-it-consulting-group+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/best-it-consulting-group?hl=en.