Job 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:

Whats 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.

\xef\xbb\xbfCriteria 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)

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

Exusia