UST - Data Modeler - Erwin/ER/Studio (4-8 yrs)

Job Title : Data Modeler.

Experience : 4+ Years.

Location : Bengaluru.

Job Description :

We are looking for a skilled Data Modeler to join our team. The ideal candidate will analyze business needs, create data models, and implement data strategies to optimize data systems. You will collaborate with development teams, troubleshoot data discrepancies, and ensure data consistency across systems..

Key Responsibilities :

- Develop conceptual, logical, and physical data models for various business domains and applications.

- Design and implement data warehousing and data mart solutions.

- Create and maintain data dictionaries and metadata repositories.

- Ensure data models comply with data governance and security standards.

- Utilize data modeling tools (ERwin, PowerDesigner, ER/Studio) to create and maintain data models.

- Analyze business requirements and translate them into data modeling specifications.

- Conduct data profiling and analysis to understand data characteristics and relationships.

- Collaborate with business analysts, data engineers, and developers to gather data requirements.

- Document data requirements and specifications.

- Design and optimize database schemas and structures.

- Ensure data models are scalable and performant.

- Provide guidance on database design and implementation best practices.

- Collaborate with database administrators (DBAs) to implement and maintain data models.

- Design data integration and ETL processes to support data warehousing and data migration.

- Ensure data models support data integration and ETL requirements.

- Collaborate with data engineers to implement data integration and ETL solutions.

- Define and implement data governance policies and procedures.

- Ensure data models support data quality and consistency.

- Participate in data quality initiatives and data cleansing activities.

- Implement data lineage and metadata management processes.

- Create and maintain comprehensive documentation of data models, data dictionaries, and data standards.

- Communicate data modeling concepts and designs to technical and non-technical stakeholders.

- Conduct training and knowledge sharing sessions on data modeling best practices.

- Stay up-to-date on the latest data modeling techniques and technologies.

- Identify and implement opportunities to improve data modeling processes and methodologies.

- Participate in data modeling community and industry events.

Technical Skills & Qualifications :

- 4+ years of experience as a Data Modeler or related role.

- Strong understanding of data modeling principles and methodologies (e.g., dimensional modeling, relational modeling).

- Proficiency in using data modeling tools (ERwin, PowerDesigner, ER/Studio).

- Experience with database technologies (SQL Server, Oracle, MySQL, PostgreSQL).

- Experience with data warehousing concepts and technologies (star schema, snowflake schema).

- Strong SQL skills for data analysis and manipulation.

- Understanding of data governance and data quality principles.

- Excellent communication and interpersonal skills.

- Strong analytical and problem-solving skills.

- Ability to work effectively in a team environment.

Preferred Qualifications :

- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.

- Experience with cloud data warehousing platforms (Azure Synapse Analytics, AWS Redshift, Google BigQuery). -

- Experience with NoSQL databases.

- Experience with data integration and ETL tools.

- Experience with metadata management tools.