Exponentia.ai - Data Modeler - AWS / SQL

Job Summary :

We are seeking a highly skilled Data Modeler 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 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.

ref : hirist.tech)