Senior Data Analyst / Data Modeler

4 Months ago • 3-12 Years

Job Summary

Job Description

Senior Data Analyst/Data Modeler with 3+ years of experience. Must have expertise in data modeling, ER & dimensional modeling, Star Schema implementation, RDBMS & cloud databases. Strong SQL/Python skills are essential.
Must have:
  • Data Modelling
  • ER & Dimensional
  • Star Schema
  • RDBMS & Cloud
Good to have:
  • Scrum Master
  • Product Owner
  • ETL Processes
  • Cloud Platforms

Job Details

Description

Department:                           Sales and Delivery Team - Empower

Industry:                                  Information Technology & Services, Computer Software, Management Consulting

Location:                                 Pune/Hyderabad/ Remote (Anywhere in India)

Experience Range:                 3 - 12 years

Basic Qualification:               Master/Bachelor of Engineering or Equivalent

Travel Requirements:           Not required

Website:                                  www.exusia.com

 

What’s the Role?

Full-time job to work with Exusia's global (Americas, Europe, Africa, Asia) clients to deliver on bleeding-edge data-driven solutions by performing business and data analysis, data modelling, data mapping and translating functional requirements into technical specifications. Work with Client Product Owners & Business SMEs, Exusia Solution Architects and Senior Application Designers/Developers.


Criteria for the Role!

·        Have a minimum of 3 years of experience working as a Data Analyst and Data Modeler

·        Master of Science (preferably in Computer and Information Sciences or Business Information Technology) or an Engineering degree in the above areas. 

·        Experience working in an agile software delivery model is required.

·        Prior data modelling experience is mandatory preferably for DWH/Data marts

·        Self-motivated and proactive in a fast-paced environment.

·        Excellent communication, creative problem solver, flexible, proactive, attitude to learn newer tools/technologies


Responsibilities

·      Own and Lead Data Analysis and data modelling activities

·      Discuss & document data and analytics requirements with cross functional teams and business stakeholders.

·      Analyse requirements and come up with technical specifications, source-to-target mapping, data and data models

·      Data profiling and cleaning data for data analysis. Interpret data, analyse results, prepare data analysis reports.

·      Perform Data validation and testing to certify data

·      Collect, analyse and disseminate significant amounts of information to project team & business stakeholders.

·      Manage changing priorities during the software development lifecycle (SDLC)

Requirements

Mandatory Skills

·        Able to create Logical and Conceptual data models for business and functional users

·        Understanding of ER and Dimensional modelling techniques like Star, Snowflake or Constellation

·        Hands on experience in implementing Star Schema and Relational (Normalized including 3NF) models is mandatory

·        Should have implemented physical data models for a variety of RDBMS and cloud hosted databases

·        Strong understanding of different types of facts and dimensions

·        Hands on experience with data modelling tools like Erwin, ER Studio, InfoSphere Data Architect (IDA)

·        Strong SQL or python skills for carrying out data analysis and data profiling

·        Transforming business/functional requirements into technical specifications.

·        Capturing data mapping / data transformation and business rules logic using source to target mapping templates

·        Hands-on exposure to SQL and NoSQL databases and able to write pseudo-code for ETL requirements.

·        Data validation and testing using SQL or any tool-based testing methods

 

Nice to have skills

·        Exposure to scrum master or product owner role will be desirable

·        Knowledge of data processing / ETL using Ab Initio / SAS / SSIS / Python / Scala / Apache Spark / Databricks

·        Exposure to one or more Cloud platforms – Amazon Web Services (AWS), Microsoft Azure, Google Cloud Platform

·        Experience with BI/Reporting such as Cognos / SSRS and Data Visualizations Tools like Power BI, Tableau, Qlik

·        Exposure to Data Governance projects including Metadata Management, Data Dictionary, Data Glossary, Data Lineage and Data Quality aspects.

·        Experience and knowledge of one or more domains – Banking & Financial services, Healthcare, Supply Chain/Inventory Management, Logistics Telecom

Similar Jobs

Next Level Business Services - Data Modeler

Next Level Business Services

Madison, Wisconsin, United States (On-Site)
4 Months ago
ION - Data Modeler, New York

ION

New York, New York, United States (Hybrid)
4 Months ago
saama - Data Modeler

saama

Chennai, Tamil Nadu, India (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Hoyoverse - CRM Intern (6-month)

Hoyoverse

Singapore (On-Site)
4 Months ago
Metacore - Build Engineer

Metacore

Helsinki, Uusimaa, Finland (Hybrid)
4 Months ago
Metacore - Art Producer

Metacore

Helsinki, Uusimaa, Finland (Hybrid)
4 Months ago
Moonbug Entertainment - Director, Revenue & Data Insights (Gaming)

Moonbug Entertainment

London, England, United Kingdom (On-Site)
4 Months ago
Playtech - Casino Insight Analyst

Playtech

(On-Site)
4 Months ago
Krafton  - [AI] Deep Learning Engineer - Model Optimization (3년 이하)

Krafton

Seoul, South Korea (On-Site)
4 Months ago
Technicolor Creative Studios - VFX Supervisor - CG

Technicolor Creative Studios

London, England, United Kingdom (On-Site)
4 Months ago
Aristocrat Gaming - Associate Automation Director

Aristocrat Gaming

Austin, Texas, United States (Hybrid)
4 Months ago
Pixar Animation Studios - Technical Director, Character Rigging/Model - Resident

Pixar Animation Studios

Emeryville, California, United States (On-Site)
4 Months ago
Tencent - Senior Data Scientist

Tencent

Shenzhen, Guangdong Province, China (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

Jobs in Delhi, India

Outscal - Video Editor

Outscal

Delhi, India (Hybrid)
4 Months ago
Ares Management Corporation - Application QA Engineer

Ares Management Corporation

Maharashtra, India (Hybrid)
4 Months ago
Upstox - News Desk Writers

Upstox

Delhi, India (On-Site)
4 Months ago
Head Digital Works - Manager - Corporate Affairs (West)

Head Digital Works

Delhi, India (Remote)
4 Months ago
Cloudhire - Senior Scala Architect

Cloudhire

Delhi, India (Remote)
4 Months ago
Cloudhire - Senior Database Engineer

Cloudhire

Delhi, India (Remote)
4 Months ago
Cloudhire - VBA Developer - CloudHire Consulting

Cloudhire

Delhi, India (Remote)
4 Months ago
Paytm - Team Lead - Sales - Goa

Paytm

Goa, India (On-Site)
4 Months ago
Cloudhire - Senior Content Strategist (Americas)

Cloudhire

Delhi, India (Remote)
4 Months ago
Paytm - Micro Market Manager - QR - GOA

Paytm

Goa, India (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded

Similar Category Jobs

Moonbug Entertainment - Director, Revenue & Data Insights (Gaming)

Moonbug Entertainment

London, England, United Kingdom (On-Site)
4 Months ago
Playtech - Casino Insight Analyst

Playtech

(On-Site)
4 Months ago
Tencent - Financial Management and Analysis Intern

Tencent

Tokyo, Japan (On-Site)
4 Months ago
ByteDance - Business Analysis & Operation Director

ByteDance

Singapore (On-Site)
4 Months ago
ByteDance - Experienced Enterprise Internal Control Partner - Singapore

ByteDance

Singapore (On-Site)
4 Months ago
ByteDance - Risk Control Business Partner - Los Angeles

ByteDance

Los Angeles, California, United States (On-Site)
4 Months ago
ByteDance - Risk Control Business Partner - Singapore

ByteDance

Singapore (On-Site)
4 Months ago
ByteDance - Experienced Enterprise Internal Control Partner - Dubai

ByteDance

Dubai, Dubai, United Arab Emirates (On-Site)
4 Months ago
ByteDance - Risk Control Business Partner - Dubai

ByteDance

Dubai, Dubai, United Arab Emirates (On-Site)
4 Months ago
Embark Studios - Game Data Analyst - Games

Embark Studios

Stockholm, Stockholm County, Sweden (On-Site)
4 Months ago

Get notifed when new similar jobs are uploaded