Senior Data Analyst / Data Modeler

5 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)
5 Months ago
ION - Data Modeler, New York

ION

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

saama

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

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

Hoyoverse - CRM Intern (6-month)

Hoyoverse

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

Metacore

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

Metacore

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

Moonbug Entertainment

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

Playtech

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

Krafton

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

Technicolor Creative Studios

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

Aristocrat Gaming

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

Pixar Animation Studios

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

Tencent

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

Get notifed when new similar jobs are uploaded

Jobs in Delhi, India

Outscal - Video Editor

Outscal

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

Ares Management Corporation

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

Upstox

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

Head Digital Works

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

Cloudhire

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

Cloudhire

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

Cloudhire

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

Paytm

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

Cloudhire

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

Paytm

Goa, India (On-Site)
5 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)
5 Months ago
Playtech - Casino Insight Analyst

Playtech

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

Tencent

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

ByteDance

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

ByteDance

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

ByteDance

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

ByteDance

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

ByteDance

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

ByteDance

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

Embark Studios

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

Get notifed when new similar jobs are uploaded

About The Company

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

Hyderabad, Telangana, India (Remote)

View All Jobs

Get notified when new jobs are added by EXUSIA

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug