Data Modeling Specialist

15 سبتمبر، 2022

0 31 2 دقائق

Job Description

Job Description :

Define and govern data modeling and design standards, tools, best practices, and related development
Methodologies for the organization for which they work.
Set standards for document naming, security, and lifecycle & retention architecture.
Make recommendations for standardization and proper data usage.
Perform development or maintenance work on data models, data dictionaries, CRUD matrix, flowcharts, design
Justifications or other artifacts to meet with corporate standards, integration with enterprise data architecture and company goals.
Conduct data analysis and capture data requirements.
Create a data dictionary and metadata around the data elements.
Responsible for defining the source repositories and rules around the transformations.
Create logical and physical models
Contribute to large modeling projects with other data modelers at remote sites.
Work with Management to establish a data-modeling disciple in the company's environment.
Work with customers to understand and derive meaningful data relationships and translate them into appropriate data models.
Serve as a reference and authority on the process of data modeling and ensure consistency with existing data models and data architectures, published standards and guidelines.
Develop, review, approve new data models and enhance existing models.
Validate logical data models with business subject matter experts.
Work with other members of the development team to ensure all requirements are capture and reflect in data model.
Work with the DBA team to design physical models to satisfy optimal performance.
Participate in best practices and standards development.
Train/mentor others in data modeling.
Actively participate in meta-data definition and management.
Actively participate in designing the data access layer.
Assist and backup DW/BI design in support of data warehouse/business intelligence functions.
Perform reverse engineering of physical data models from databases and SQL scripts.
Analyze data-related system integration challenges and propose appropriate solutions.
Guide System Analysts, Engineers, Programmers, and others on project limitations and capabilities, performance requirements and interfaces.
Bachelor degree in Computer Science, MIS, or a related field, or an equivalent combination of education and related work experience.
4 years of data modeling experience.
Experience in Oracle 11g (Security model, Integration Services and Reporting Services).
Ability to present data model designs.
Ability to write clear and concise technical documents.
Ability to clear document a process or procedure for others to follow.
Ability to be rely upon to complete a task or project with minimal supervision.
Advanced knowledge and experience in logical and physical data modeling.
Strong knowledge of Oracle, SQL Server or other enterprise databases.