Data Warehouse / Senior Data Analyst (1-3 Years)

Posted on 12-Jan-2017 (Job Expired) by : Allegis Services India Pvt. Ltd.
Bangalore
Not Disclosed
Full-Time

Keyskills : Business Intelligence Data Analysis Data Mining Data Modeling Data Warehouse


Job Summary

4 Openings
IT-software services
IT/ Software/ Services
Graduation

Job Description

  • Working in Business Intelligence & Analytics team.
  • Creating necessary Schema for Fact & Dimension tables in Hive.
  • Creating necessary Customer metrics for Customer Retention / Behavior & Product Ads.
  • Created lot of Interactive dashboards for Business Users using Qlikview.
  • Working on API & automated QPS using Python through URL End point.
  • Creating Real-time/Batch fact in Vertica using Bigfoot.
  • Taking care of Monetization dashboard for Product Ads.
  • Managing internal tools of BI (Business Intelligence) team and adding features or updating it based on new internal requirements.
  • Manipulating, cleansing & processing data using Qlikview, MySQL & VBA.
  • Analyzing raw data, drawing conclusions & developing recommendations.


Roles & Responsibilities

    • Manipulating, cleansing & processing data using SQL, ETL Process and Ms-Excel, Responsible for loading, extracting and validation of client data.
    • Analyzing raw data, drawing conclusions & developing recommendations Writing T-SQL scripts to manipulate data for data loads and extracts.
    • Responsible for extracting, transforming, loading and validation of client data. Manipulating and processing the data using Excel and SQL.
    • Knowledge of working with Excel Pivot and VBA macros to Perform daily, monthly, quarterly and annual data values updates and system checks.


Company Profile

Superior talent distinguishes great companies from the rest. Through our network of specialised operating companies, Allegis Group partners with organisations across the globe to optimise talent attraction and retention — while simultaneously providing individuals with significant opportunities to realise their professional aspirations and achieve personal success.

See other Courses

Share job on :
ETL- Database Developer (3-6 Years)
Careernet Technologies Pvt Ltd
Not Disclosed

SAP Bw - Data and Analytics (3-6 Years)
Pricewaterhouse Coopers Private Limited
Not Disclosed