Data Modeling Specialist
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.
Job Details
Employment Types:
Full time
Industry:
Telecom
Function:
IT
Roles:
Software Engineer / Programmer
Skills:
Data Modeling Specialist
