HP Published: April 13, 2016
Location
Job Type
Category
Skills
SQL SSIS SSAS Data Modelling

Description

In this role, the candidate will require to work and excel in following areas

  • Required to work on projects of medium/High complexity and display excellent programming capabilities using MSBI (SQL, SSIS, SSAS)
  • Evaluate and define functional requirements for DW and BI solutions with Business users
  • Define Data Acquisition and Data Integration Design and logical data models that are globally scalable and reusable across multiple source systems
  • Define Analytic capabilities requirements and design (Dashboards, Scorecards/Performance Management, Ad-Hoc, Slice/Dice, Alerts and Guided Analytics, Search and Text, Prediction and Simulation)
  • Capacity to solve problems, identify options and propose a solution in MS BI technologies
  • Create, execute and document test cases and results
  • Prepare process documentation for all processes. Effectively transition implementation knowledge to support teams
  • Good verbal & written communication skills to interact with the relevant stakeholders
  • Flexibility to work across time zones and diverse cultures and across different technologies.
  • Estimate costs for technical components.
  • Develop ETL technical architecture.
  • Evaluate and select ETL tool.
  • Develop access/analysis tool technical architecture.
  • Evaluate and select access/analysis tools.
  • Interface with DBA staff.
  • Interface with systems operations staff.
  • Work with data designer and the ETL architect to determine space requirements.
  • Monitor BI usage capture and maintenance of metrics.
  • Develop and manage the BI dependency plan, job scheduling and cycle management.
  • Develop disaster recovery strategy.
  • Determine and ensure execution of backup and recovery strategy.
  • Ensure execution of archival strategy.
  • Continue to investigate and evaluate emerging BI technologies.
  • Define and get agreement with support and IT operations personnel on service level agreements.

OTHER FUNCTIONS AND RESPONSIBILITIES

  • Project Lifecycle Management
  • Project Documentation
  • Technical Innovation to embrace latest trends in BI

REQUIRED COMPETENCIES (Mandatory)

  • Proficiency in SQL, SSIS, SSAS
  • Proficiency and minimum hands on experience of 3 years in end to end MS BI Application
  • Good verbal & written communication skills to interact with the relevant stakeholders
  • Flexibility in adapting to new technologies.
  • Flexibility to work across time zones and diverse cultures

REQUIRED COMPETENCIES (Preferred)

  • Exposure to SharePoint/Script languages Javascript, C#, QlikView would be an advantage.

Qualifications

Education and Experience Required:

Typically a Bachelor’s degree or equivalent experience and a minimum of 10 years of related experience or a Master’s degree and a minimum of 8 years experience.

Knowledge and Skills Required:

Exceptional written and verbal skills. Strong business experience in multiple business sub-domains. Strong relationship management skills. Excellent project management and process development skills.

Attention! This job posting is 347 days old and might be already filled.