Senior Data Analyst - Data Engineering / Modeling

6 Months ago • 5 Years + • Data Analyst

Job Summary

Job Description

Seeking a Senior Data Analyst with 5+ years of experience in data modeling, particularly for DWH/Data marts, to lead data analysis activities for global clients. Must have expertise in ER and Dimensional modeling, Star Schema implementation, and SQL/Python skills. Experience with data modeling tools like Erwin, ER Studio, or InfoSphere Data Architect is essential.
Must have:
  • Data Modeling
  • Star Schema
  • SQL/Python Skills
  • Data Modeling Tools
Good to have:
  • Scrum Master
  • Cloud Platforms
  • Data Governance
  • Banking/Healthcare

Job Details

Description

Department:                           Client Delivery Team - Empower

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

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

Experience Range:                 5+ 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 5 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 modeling activities

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

·      Analyze 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, analyze results, prepare data analysis reports.

·      Perform Data validation and testing to certify data

·      Collect, analyze 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 modeling 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 modeling 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

·        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 or Healthcare

Similar Jobs

Canva - Senior Backend Software Engineer - Java - RPC

Canva

Auckland, Auckland, New Zealand (Remote)
1 Month ago
Velotio Technologies - Data Engineer

Velotio Technologies

Pune, Maharashtra, India (Remote)
1 Month ago
ByteDance - Data Scientist

ByteDance

San Jose, California, United States (On-Site)
1 Month ago
CloudHire - Scala API Architect

CloudHire

Pune, Maharashtra, India (Remote)
1 Month ago
PwC - Director Cybersecurity - Financial Sector (Dutch)

PwC

Amsterdam, North Holland, Netherlands (On-Site)
6 Months ago
EXUSIA - Data Governance Developer - Collibra & Ab Initio

EXUSIA

India (Remote)
6 Months ago
Animoca Brands - Digital Assets Research Analyst

Animoca Brands

Hong Kong (On-Site)
3 Months ago
Framestore - Lead DataOps and Render-Support

Framestore

Mumbai, Maharashtra, India (On-Site)
5 Months ago
PwC - IN-Senior Associate_PySpark Developer_Data & Analytics_Advisory_ PAN India

PwC

Gurugram, Haryana, India (On-Site)
6 Months ago
Garena - Garena - Data Warehouse Engineer

Garena

Taipei City, Taiwan (On-Site)
3 Months ago

Get notifed when new similar jobs are uploaded

Similar Skill Jobs

The Walt Disney Company - Lead Software Engineer

The Walt Disney Company

Washington, United States (On-Site)
4 Months ago
Ness Digital - Big Data Engineer

Ness Digital

Timișoara, Timiș, Romania (Remote)
1 Month ago
The Walt Disney Company - Lead Machine Learning Engineer

The Walt Disney Company

New York, New York, United States (On-Site)
3 Months ago
PwC - IN-Manager_Big Data Engineer_Data and Analytics_Advisory_Bengaluru

PwC

Bengaluru, Karnataka, India (On-Site)
7 Months ago
Rockstar Games - Senior Data Engineer

Rockstar Games

Carlsbad, California, United States (On-Site)
2 Months ago
ION - Data Engineer/Analyst - Graduate Development Program

ION

Pisa, Tuscany, Italy (On-Site)
6 Months ago
SmileGate - Game Data Engineer (Platform Development)

SmileGate

Seongnam-si, Gyeonggi-do, South Korea (On-Site)
3 Months ago
SmileGate - Game Data Engineer [LOST ARK]

SmileGate

Seongnam-si, Gyeonggi-do, South Korea (On-Site)
3 Months ago
Balbix - Staff /Sr Staff/ Principal Engineer - Lakehouse

Balbix

Gurugram, Haryana, India (On-Site)
6 Months ago
Netflix - Senior Data Engineer, Commerce Insights and Data Products Engineering

Netflix

Mexico City, Mexico City, Mexico (On-Site)
2 Months ago

Get notifed when new similar jobs are uploaded

Jobs in India

Luxoft - Principal/Lead GCP Cloud Modernization Engineer

Luxoft

New Delhi, Delhi, India (Remote)
4 Months ago
Wipro - ITIL Release Manager

Wipro

Bengaluru, Karnataka, India (On-Site)
5 Months ago
CloudHire - Senior Scala Architect

CloudHire

Maharashtra, India (Remote)
1 Month ago
Assystems - Quantity Surveyor

Assystems

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Rackspace Technology - AWS Support Engineer IV

Rackspace Technology

Gurugram, Haryana, India (Remote)
3 Months ago
Quizizz - Revenue Marketing Manager

Quizizz

Bengaluru, Karnataka, India (On-Site)
1 Month ago
Nielsen Holdings - Senior Software Engineer-AM-TECH-DA-SDK-09

Nielsen Holdings

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Head Digital Works - Product Manager

Head Digital Works

Hyderabad, Telangana, India (On-Site)
6 Months ago
PwC - Senior Associate-SAP PP-Kolkata-RDC

PwC

Kolkata, West Bengal, India (On-Site)
7 Months ago
Postman - Engineering Manager, Workspaces

Postman

Bengaluru, Karnataka, India (Hybrid)
6 Months ago

Get notifed when new similar jobs are uploaded

Data Analyst Jobs

Aristocrat Gaming - Business Analyst

Aristocrat Gaming

Austin, Texas, United States (Hybrid)
1 Month ago
Equivalent Jobs - C++ SOFTWARE ENGINEER (MARKET DATA)

Equivalent Jobs

(Remote)
5 Months ago
Nagarro - Associate Principal Engineer, Big Data

Nagarro

(On-Site)
6 Months ago
OUTFIT7 - Marketing Data Scientist

OUTFIT7

Ljubljana, Ljubljana, Slovenia (On-Site)
1 Month ago
Knuddels - Backend Development and Data Science Internship

Knuddels

Baden-Württemberg, Germany (Remote)
1 Month ago
GoTo Group - Senior Software Engineer - Data Platform (Mercury)

GoTo Group

Bengaluru, Karnataka, India (On-Site)
6 Months ago
Fanatee - Data Science Intern

Fanatee

(On-Site)
9 Months ago
Luxoft - Senior Data Ops Engineer

Luxoft

(Remote)
5 Months ago
Next Level Business Services - SDE 3 (BI Analyst-Cosmos)

Next Level Business Services

Redmond, Washington, United States (On-Site)
6 Months ago
EXUSIA - Power BI Data Analyst

EXUSIA

Hyderabad, Telangana, India (Remote)
2 Months ago

Get notifed when new similar jobs are uploaded

About The Company

Exusia (ex-OO-see-ah), A Globant Division has the mission of transforming the world through the innovative use of information. Exusia is an ISO 27001 certified technology solutions company that empowers its clients to gain a competitive edge by accelerating business objectives and providing solutions in artificial intelligence, cloud computing, data engineering and digital transformation. Exusia is a leader in end-to-end data strategy, execution and managed services offerings, leveraging its team of business strategy, analytics and data engineering experts along with cutting edge hosted software as a service accelerators to deliver to clients. Exusia was founded in 2012 and now provides services in IT Strategy, AI Enablement, Data Governance, Data Engineering, Cloud Migration and Mainframe Modernization to the Globant client base as apart of the Data & Artificial Intelligence Studio.

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