What You’ll Do
Develop conceptual, logical, and physical data models to represent various data domains, ensuring accuracy, consistency, and scalability.
Define data structures, relationships, and attributes that capture business requirements and enable efficient data storage and retrieval.
Collaborate with business stakeholders, analysts, and data consumers to gather and understand data requirements, ensuring that data models align with business needs.
What You’ll Do
Develop conceptual, logical, and physical data models to represent various data domains, ensuring accuracy, consistency, and scalability.
Define data structures, relationships, and attributes that capture business requirements and enable efficient data storage and retrieval.
Collaborate with business stakeholders, analysts, and data consumers to gather and understand data requirements, ensuring that data models align with business needs.
Translate business requirements into database schema designs, including normalization and denormalization techniques to optimize data integrity and performance.
Ensure data integrity and quality by defining constraints, validation rules, and data governance policies within the data models.
Define data quality standards and best practices and maintenance process for CDM/LDM/PDM/Semantic dimensional models.
Create comprehensive documentation of data models, including entity-relationship diagrams, data dictionaries, and metadata definitions.
Maintain up-to-date documentation as data models evolve over time.
Collaborate with data scientists to provide structured data for analytical and machine learning purposes.
Enforce data governance and compliance standards by incorporating security and privacy considerations into data models.
Collaborate with legal and compliance teams to ensure adherence to data protection regulations.
Keep up-to-date with industry trends, emerging technologies, and best practices in data modeling, database design, and data management.
Provide regular updates for tasks, deliverables, … including information on task status, est. target dates, % completed, priority, allocation percentage, % completed, issues, gaps, … for all tasks worked on/planned.
Lead a project team of Data Modelers
Teradata seeks a Data Modelling professional to work closely with customer on the projects.
Professional developments offered:
Training on the Teradata products.
Opportunities to work on high-profile international projects.
What Makes You a Qualified Candidate
Bachelor’s Degree from a reputed Educational Institute.
Must have 10+ years of IT experience.
Must have 8+ years of Data Modeling relevant experience.
Proven experience as a Data Modeler / Database Designer / Information Architect.
Proficiency in data modelling tools such as ERwin, PowerDesigner, ER/Studio, or similar tools.
Strong understanding of relational database concepts, normalization, and denormalization.
Familiarity with various database systems (e.g. Vantage, SQL Server, Oracle, PostgreSQL).
Experience with big data platforms and NoSQL databases is a plus.
Excellent problem-solving skills and attention to detail.
Knowledge of Insurance industry domain could be a plus.
Experience with reference industry data models could be an advantage.
Strong communication and collaboration skills.
Ability to clearly and confidently articulate your thoughts.
Ability to work in a fast-paced, dynamic environment.
Knowledge of data governance and compliance regulations is desirable.
Willing to travel – both short-term and long-term if required.
Job Description
Role Purpose
The purpose of this role is to interpret data and turn into information (reports, dashboards, interactive visualizations etc) which can offer ways to improve a business, thus affecting business decisions.
͏
Do
1. Managing the technical scope of the project in line with the requirements at all stages
a. Gather information from various sources (data warehouses, database, data integration and modelling) and interpret patterns and trends
b. Develop record management process and policies
c. Build and maintain relationships at all levels within the client base and understand their requirements.
d. Providing sales data, proposals, data insights and account reviews to the client base
e. Identify areas to increase efficiency and automation of processes
f. Set up and maintain automated data processes
g. Identify, evaluate and implement external services and tools to support data validation and cleansing.
h. Produce and track key performance indicators
2. Analyze the data sets and provide adequate information
a. Liaise with internal and external clients to fully understand data content
b. Design and carry out surveys and analyze survey data as per the customer requirement
c. Analyze and interpret complex data sets relating to customerâÃÂÃÂs business and prepare reports for internal and external audiences using business analytics reporting tools
d. Create data dashboards, graphs and visualization to showcase business performance and also provide sector and competitor benchmarking
e. Mine and analyze large datasets, draw valid inferences and present them successfully to management using a reporting tool
f. Develop predictive models and share insights with the clients as per their requirement
͏
Deliver
| No | Performance Parameter | Measure |
| 1. | Analyses data sets and provide relevant information to the client | No. Of automation done, On-Time Delivery, CSAT score, Zero customer escalation, data accuracy |
͏
͏
Ability to clearly and confidently articulate your thoughts.
Ability to work in a fast-paced, dynamic environment.
Knowledge of data governance and compliance regulations is desirable.
Willing to travel – both short-term and long-term if required.