Data Modeler - India

Mid / Senior



Meytier Premier Employer

Working there

About This Workplace

Meytier Partner

The ideal candidate will show interest in mastering and exercise responsibility towards both project and team. The candidate must have strong analytical skills and possess excellent communication skills, both oral and written.

Locations: Bangalore, Chennai, Pune

Key Responsibilities:

  • Understand and translate business needs into data models supporting long-term solutions
  • Work with the Data warehouse development team to implement data strategies, build data flows and develop conceptual data models
  • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
  • Optimize and update logical and physical data models to support new and existing projects
  • Maintain conceptual, logical, and physical data models along with corresponding metadata
  • Develop best practices for standard naming conventions and coding practices to ensure consistency of data models
  • Recommend opportunities for reuse of data models in new environments
  • Perform reverse engineering of physical data models from databases and SQL scripts
  • Evaluate data models and physical databases for variances and discrepancies
  • Validate business data objects for accuracy and completeness
  • Analyze data-related system integration challenges and propose appropriate solutions
  • Develop data models according to business requirements and best practices
  • Review modifications to existing models to improve efficiency and performance

Desired Profile:

  • 10+ years of data architecture, data modelling or similar experience
  • Experience using major data modelling tools (examples: Erwin, ER Studio, Power Designer, etc.)
  • Good Hands-on experience in working with Snowflake, SQL Server etc.
  • Overall 10+ years of experience in Business Intelligence and Data Architecture projects
  • Projects delivered in banking industry will be an added advantage
  • Understanding and experience with major Data Architecture philosophies (Dimensional, ODS, Data Vault, etc.)
  • As a Data and Analytics subject matter expert, you will be responsible to lead, collaborate and produce data and analytics solution architecture and detail data architectures
  • The role requires a hands-on approach to produce data models and high-level design artefacts for data and analytics solution
  • Understanding of modern data warehouse capabilities and technologies such as real-time, cloud, Big Data
  • Experience across ETL, SQL and other emerging data technologies with Experience in operations and integrations of various cloud-based analytics environment
  • Experience querying and manipulating data on multiple platforms using multiple methodologies and tools and create conceptual design of the defined data solution
  • Experience using cloud-based Hybrid solution
  • Good understanding of Data Strategy, Data Governance Process etc.
  • Working with Business on storyboarding and requirement elicitation
  • Experience using Agile methodologies and Scrum

© 2023 Meytier - All Rights Reserved.
Privacy Policy    Terms of Use