Responsibilities:
-
Lead the development of conceptual, logical, and physical data models
-
Implement business and IT data requirements across relational, dimensional, and NoSQL platforms
-
Define and enforce data modelling and design standards, tools, and best practices
-
Oversee the implementation of RDBMS, operational data store (ODS), data marts, and data lakes
-
Identify architecture, infrastructure, and interfaces to data sources, ensuring security and analytic model support
-
Optimize data query performance through best practices. Identifying areas for improvement in current data systems
-
Collaborate with teams, addressing project requirements and reducing delivery risks
-
Support the development of data tools for reporting, visualization, analytics, and machine learning
-
Designing and managing data infrastructure to extract, organize, and store data for authorized users to access
-
Identifying internal and external data sources within the organization. Ensuring the accuracy, security, and accessibility of the data
Requirements
-
Strong expertise in conceptual, logical, and physical data modeling
In addition to data warehouse and data lake design approaches with hands-on experience of Inmon & Kimball methodologies.
-
Hands-on experience with RDBMS, NoSQL databases, and Cloudera CDP technologies
-
Proven experience in defining and implementing data architecture strategies
-
Excellent communication skills for technical and non-technical stakeholders
-
Experience in performance tuning for data queries
-
Understanding of data modelling and design standards, tools, and best practices
-
Analytical mind-set and problem-solving skills for proactive project support
-
Experience with modelling tools like ERWIN