Data Modeller
- Exponentia Team
- 2 - 8 years
- Mumbai
- 10 months ago
- Email to a friend
- Report this job
Job Description
- 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.
- 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.
- 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.
Job Classification
Industry: Software ProductFunctional Area / Department: Data Science & AnalyticsRole Category: Data Science & Analytics - OtherRole: Data Science & Analytics - OtherEmployement Type: Full timeContact Details:
Company: Exponentia TeamLocation(s): Mumbai
Keyskills: Business process Data analysis metadata Data modeling Schema Data quality data mapping SQL Data extraction Python
Similar positions
Exponentia Team
Data is the new Oil and AI is the most powerful value accelerator today - this is one of the most important belief we live by. We are an award-winning AI-Tech MNC transforming businesses through AI, ML and Data Analytics Solutions. We help organizations solve complex business challenges by combin...
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in