Home
Communities
Companies
- Companies
  
  Discover best places to work
- Compare Companies
  
  Compare & find best workplace
- Add Office Photos
  
  Bring your workplace to life
- Add Company Benefits
  
  Highlight your company's perks
Reviews
- Company reviews
  
  Read reviews for 6L+ companies
- Write a review
  
  Rate your former or current company
Salaries
- Browse salaries
  
  Discover salaries for 6L+ companies
- Salary calculator
  
  Calculate your take home salary
- Are you paid fairly?
  
  Check your market value
- Share your salary
  
  Help other jobseekers
- Gratuity calculator
  
  Check your gratuity amount
- HRA calculator
  
  Check how much of your HRA is tax-free
- Salary hike calculator
  
  Check your salary hike
Interviews
- Company interviews
  
  Read interviews for 40K+ companies
- Campus placements
  
  Interviews questions for 2K+ colleges
- Share interview questions
  
  Contribute your interview questions
Jobs
Awards

WINNERS AWAITED!
- ABECA 2025
  
  WINNERS AWAITED!
  
  AmbitionBox Employee Choice Awards - 4th Edition
- ABECA 2024
  
  AmbitionBox Employee Choice Awards - 3rd Edition
- AmbitionBox Best Places to Work 2022
  
  2nd Edition
- AmbitionBox Best Places to Work 2021
  
  1st Edition

Add office photos

Engaged Employer

Exponentia.ai

Compare

4.2

based on 117 Reviews

84 Exponentia.ai Jobs

Data Modeller

Exponentia Team

4.2

based on 117 Reviews

2-8 years

Mumbai

1 vacancy

Data Modeller

Exponentia.ai

posted 9d ago

Job Role Insights

Flexible timing

Key skills for the job

Data Analysis Python SQL Data Modeling Business Process Management Data Extraction

+ 4 more

Job Description

Job Summary:

We are seeking a highly skilled Data Modeller with 5-10 years of experience in data analytics and data warehousing projects on the AWS platform. The ideal candidate will have a strong background in data modelling, business requirements analysis, and KPI development. This role requires expertise in creating data flow diagrams, business process flow diagrams, and data mapping from source to target systems. The candidate should also be proficient in analysing source data for data quality issues and designing conceptual, logical, and physical data models for dashboards and KPIs. Experience with star schema, snowflake schema, and data marts is essential.

Key Responsibilities:

Gather and document business requirements for KPI development, dashboards, and reports.
Create and maintain business process flow diagrams and data flow diagrams.
Perform data mapping from source systems to target data models.
Analyse source data in Excel or databases to identify and resolve data quality issues.
Design conceptual data domains, logical data entities, and physical data models.
Develop data warehouse models, including star schema, snowflake schema, and data marts.
Collaborate with stakeholders, including business teams, data engineers, and developers, to ensure alignment between business needs and data architecture.
Support data governance initiatives by defining metadata, data lineage, and data quality rules.
Work on data analytics projects to enhance data-driven decision-making.
Implement best practices for data modelling, ensuring scalability and performance optimization.

Required Skills Qualifications:

5-10 years of experience in data analysis, data modelling, and data warehousing.
Hands-on experience with AWS data services (e.g., Redshift, Glue, Athena, S3, Lambda).
Proficiency in SQL for data extraction, transformation, and analysis.
Experience with data visualization tools (e.g., Power BI, Tableau, QuickSight).
Strong understanding of data governance, metadata management, and data quality principles.
Experience in designing and implementing star schema and snowflake schema and ER models.
Proficiency in data analysis, including requirement gathering and stakeholder communication.
Familiarity with ETL processes and tools like Erwin.
Ability to work with large datasets and optimize performance.
Strong problem-solving and analytical skills.

Preferred Qualifications:

Experience with Python other scripting languages for data analysis.
Knowledge of data cataloging tools and data lineage tracking.
AWS certifications (e.g., AWS Certified Data Analytics, AWS Solutions Architect) are a plus.
Experience in Agile development methodologies.
Experience in working on AWS infrastructure.