Location
Pune | India
Job description
A Data Modeler is responsible for designing, creating, and maintaining data models that accurately represent the structure and relationships of data within an organization. They work closely with business analysts, data architects, and database administrators to understand data requirements and develop efficient and effective data models. Data Modelers play a critical role in ensuring data integrity, data quality, and data consistency across various systems and applications.
Responsibilities:
- Data Modeling: Design and develop conceptual, logical, and physical data models based on business requirements, industry best practices, and data governance standards.
- Requirement Analysis: Collaborate with business analysts and stakeholders to understand data requirements, data sources, and data integration needs.
- Database Design: Create and maintain database schemas, tables, and relationships to support data models.
- Data Integration: Work with data integration teams to define data mappings, transformations, and data flows between different systems.
- Data Standardization: Establish and enforce data modeling standards, naming conventions, and data modeling best practices.
- Performance Optimization: Identify opportunities for performance improvement by optimizing data models, indexes, and queries.
- Data Quality Assurance: Develop and implement data quality rules and validation checks to ensure the accuracy, completeness, and consistency of data.
- Documentation: Prepare detailed documentation, including data dictionaries, entity-relationship diagrams, and data flow diagrams.
- Collaboration: Collaborate with cross-functional teams, including data architects, database administrators, software developers, and business users, to ensure successful implementation of data models.
- Data Governance: Support data governance initiatives by ensuring compliance with data privacy, security, and regulatory requirements.
Requirements:
- Education: Bachelor's or Master's degree in computer science, information systems, or a related field.
- Experience: A minimum of X years of experience in data modeling and database design.
- Knowledge: Strong understanding of relational database concepts, data modeling techniques (such as ER modeling), and database management systems (e.g., Oracle, SQL Server, MySQL).
- Tools: Proficiency in data modeling tools (e.g., ER/Studio, ERwin, PowerDesigner) and familiarity with data integration tools (e.g., Informatica, Talend).
- Technical Skills: Solid knowledge of SQL and experience with scripting languages (e.g., Python, R) for data manipulation and analysis.
- Analytical Thinking: Strong analytical and problem-solving skills to analyze complex data requirements and translate them into effective data models.
- Communication: Excellent verbal and written communication skills to effectively collaborate with stakeholders and present complex technical concepts to non-technical audience.
- Attention to Detail: Meticulous attention to detail to ensure data integrity and accuracy in data models.
- Adaptability: Ability to work in a fast-paced, dynamic environment and quickly learn new technologies and tools.
- Teamwork: Strong team player with the ability to work collaboratively in cross-functional teams and contribute to the overall success of data-related projects.
Job tags
Salary
