Job Details
Skills And Tools:
Job Description
The Data Modeler is responsible for transforming business information into logical data models and managing the enterprise data model.
The Data Modeler is proficient in industry standard techniques for process modeling and data modeling. The Data modeler designs, implements, and documents data architecture and data modeling solutions, which include the use of relational, dimensional, and NoSQL databases. Within data modeling, the Data Modeler must be proficient in 3rd normal form relational modeling as well as dimensional modeling. Experience with alternate modeling techniques such as Data Vault, and key modeling as it relates to Big Data would be a strong added value.
A Data Modeler understands semantic modeling requirements and concepts, and when working with associated Teradata Consultants, can design and document semantic models that are required for specific applications. The Data Modeler is also familiar with new and emerging data which contributes to behavioral or interaction data. This may include modeling for documents, XML, JSON, meta tags (audio, video, pictures) and others.
Key Areas of Responsibility
- Analyze and translate business needs into long term solution data models.
- Design and normalize the logical data model to third normal form.
- Facilitate the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community.
- Prepare fully refined data models in accordance with the guidelines/conventions of Integration Definition (IDEF) or equivalent methodology.
- Work with all related consultants to design and document semantic models.
- Work closely with Data Architects to translate LDMs and Semantic Models into their physical representations.
- Work with ETL consultants to map source system data to Teradata physical models.
- Maintain and publish project business rules and the associated enterprise data dictionary.
- Evaluate access paths for data which spans multiple deployed technologies; provide recommendations for optimizations in accessing these heterogeneous relationships.
- Work within Teradata Solutions and Applications.
Job Requirements
Mandatory Skills
- Degrees Computer Science, Engineering or other related areas is desirable.
- 3/5+ year’s experience of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
- In depth knowledge of business processes and business information models.
- In depth knowledge of data modeling methodologies and techniques.
- In depth knowledge of Data modeling tools (e.g. Erwin, Power design).
- In depth knowledge of requirements documentation and information gathering techniques.
- Industry experience from one or more core industries (e.g. Finance, Insurance, Telco, Government).
- Understanding of the Teradata Reference Information Architecture and the Unified Data Architecture.
- Excellent written and oral English with experience preparing and managing documentation of senior-level client deliverables.
- Excellent communication and presentation skills.
Other skills
- Requirements management tools (e.g. JIRA).
- Working effectively in multi-disciplinary and cross-organizational teams.
- Work with the appropriate project management methodology (Agile or Waterfall) based upon customer and project requirements.
- knowledge of facilitation and conflict resolution processes.
- Detail focussed, resourceful, decisive, composed, problem-solver, flexible and adaptable.
