Data Warehouse / Senior Data Analyst

Allegis Services India Pvt. Ltd.

Business Intelligence, Data Analysis, Data Mining, Data Modeling, Data Warehouse

1 - 3 Years
Not Disclosed
Job Type
4 Openings
Functional Area
IT-software services
Share This Job On
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.

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.

Subscribe, to get jobs into your inbox
See other related jobs
SAP Supply Chain Management

Data Scientist

Openings for Informatica Da...