Data Modeling Specialist
Data Modeling Specialist
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Develop the logical data model based on the understanding of the conceptual model and conduct data profiling to deliver highquality data models and highquality data within the limits of standards defined by the client and the industry.
Analyses the requirements and creates a clarification list if required.
Define data requirements based on an understanding of the same.
Create a conceptual model based on the understanding of the business processes.
Map KPIs to the conceptual model if required Validate the conceptual model with the client Create a logical model (capturing the descriptions of entities tables columns etc. based on the conceptual model.
Create tables and relationships between the tables.
Map conceptual to the logical model to ensure the coverage Identify the entities and their properties.
Define the attributes and domain (data types).
Create a physical model based on functional/ nonfunctional requirements for small and simple projects.
Seek review inputs from the Lead / Manager / Architect on the logical and physical model. Define the data dictionary/ business glossary based on the model developed if required. Define the data governance model to ensure the data quality Interact with SMEs (business) and architects to validate whether the data model is aligned with the technology suggested for the project Interact with the Architect to gather reporting requirements and create models based on the same.
Participate in Data Model Health Assessments Create questionnaires analyse the ASIS data model for data structure conformance to industry standards best practices and make recommendations for solution/roadmap.
Requirements
Ability to coordinate and explain with business users to get the requirements.
Should have very good and clear communication skills.
Should have experience working in an Onsiteoffshore model.
10 Years of experience in writing complex DB queries in MS SQL Server Azure Data Models Power BI and Azure Analytics Services.
Must have 5 years of minimum experience in developing conceptual logical and physical data models the implementation of RDBMS operational data store (ODS) data marts and data lakes on target platforms.
Normalization/Denormalization concepts.
Metadata management and data governance.
Strong Data Analysis and Physical Data Modeling experience.
Deep expertise in data modeling and structuring and experience in highvolume data environments.
Good experience in schema designs and data warehousing ETL/ELT concepts.
How to Apply: You can apply online on our careers page 7/career/. Alternatively email your CV and cover letter to
Required Experience:
Unclear Seniority
Employment Type
Full-Time
