Data Warehouse Specialist
Job details
Data Warehouse Specialist
Netsolace It, PakistanThe Data Warehouse Specialist will be responsible for the design, development, testing, maintenance, and support of the data warehouse. This role includes developing data warehouse and business intelligence solutions using Microsoft Business Intelligence tools and underlying technologies. The individual will also provide enterprise information management expertise with emphasis on data design, access, usage, and stewardship to ensure proper governance, security, and quality of information assets.
Job SpecificationQualification:BCS/MCS/equivalent
Experience:Minimum 3 years of direct work experience
Responsibilities:
Knowledgeable in the design, construction, and management of Data Warehouse and Business Intelligence solutions.
Knowledge of problem analysis, structured analysis, and design and programming techniques.
Good grounding in development best practice skills, including requirements definition, analysis, design, testing, implementation, documentation, and support.
Must have strong skills in Microsoft SQL Server 2005/2008, including:
SQL Server Integration Services (SSIS)
SQL Server Analysis Services (SSAS)
SQL Server Reporting Services (SSRS)
Experienced in developing Business Intelligence solutions (reports, dashboards, scorecards) using Microsoft SSRS, SSAS, and MDX in a data warehousing environment.
Experience in the design and implementation of ETL processes.
Experience developing and running MDX queries.
Ability to perform detailed data analysis (i.e., determine the structure, content, and quality of the data through examination of source systems and data samples).
Advanced knowledge of OLAP/MOLAP technologies and dimensional modelling, including applicability to various reporting problems.
Knowledge of any of the following would be advantageous:
BI Tools including ProClarity, MS Performance Point, and SPSS Clementine
MS Visual Studio
MS SharePoint
Power Pivot
Cubes and Data marts
Data Warehousing methodologies, especially Kimball
Previous experience in consumer and marketing data, analysis, and reporting
Information Technology and Services - Islamabad, Pakistan#J-18808-Ljbffr
Apply safely
To stay safe in your job search, information on common scams and to get free expert advice, we recommend that you visit SAFERjobs, a non-profit, joint industry and law enforcement organization working to combat job scams.