Aws_Databricks_Data Modelling

Job description

**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. Cognizant is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected Veteran status, age, or any other characteristic protected by law.