Aws_Databricks_Data Modelling
Summary
Designs and optimizes data solutions using ANSI SQL and Alteryx for media and entertainment analytics, focusing on scalable platforms and audience insights.
Job Description\: AWS Data Modeller
Key Skills\: AWS | Databricks | Semantic Modeling | Tableau Reporting | Data Migration
Role Summary
Seeking an AWS Data Modeller with strong data migration experience to design scalable data models, semantic layers, and reporting-ready datasets across AWS and Databricks platforms, enabling governed Tableau reporting and business-ready analytics.
Key Responsibilities
· Design conceptual, logical, and physical data models for AWS-based data platforms.
· Support data migration activities including source assessment, mapping, transformation rules, validation, and reconciliation.
· Develop dimensional, semantic, and reporting-ready data structures for Tableau consumption.
· Collaborate with business, architecture, engineering, and BI teams to translate requirements into data models.
· Define source-to-target mappings, data dictionaries, metadata, lineage, and data quality rules.
· Support Databricks lakehouse design, curated data layers, and performance-focused modelling standards.
· Ensure model quality, governance, security, scalability, and reporting alignment across analytics use cases.
Must-Have Skills
Skill | Expectation |
Data Migration | Must have experience in migration planning, source-to-target mapping, transformation rules, data validation, reconciliation, and cutover support. |
AWS | Strong understanding of AWS data services such as S3, Glue, Redshift, Athena, IAM, and Lake Formation. |
Databricks | Experience with lakehouse concepts, Delta Lake, curated layers, and data engineering collaboration. |
Semantic Modeling | Ability to define business entities, metrics, dimensions, relationships, and reusable semantic models. |
Tableau Reporting | Experience designing reporting-ready datasets and optimized models for Tableau dashboards. |
SQL & Data Modelling | Strong SQL, dimensional modelling, ER modelling, data profiling, and source-to-target mapping skills. |
Preferred Qualifications
· 13+ years of experience in data modelling, data warehousing, BI, migration, or cloud data platform projects.
· Hands-on exposure to AWS, Databricks, data modernization, and legacy-to-cloud migration programs.
· Knowledge of data quality, governance, access controls, and enterprise reporting standards.
· AWS, Databricks, or Tableau certification is an added advantage.
Expected Deliverables
· Logical and physical data models, semantic model definitions, and reporting-ready datasets.
· Migration mappings, transformation rules, data dictionary, lineage, validation rules, and modelling documentation.
· Tableau-aligned data structures supporting scalable, governed, and self-service analytics.