Data Modeling Techniques : Conceptual, logical, and physical data modeling.
Data Modeling Tools : ER/Studio, Power Designer, Erwin.
Modeling Methodologies : Dimensional modeling, Data Vault.
Data Warehousing & Optimization : Star Schema, SQL, and query optimization.
Programming Languages : Experience with Apache Spark and Python.
Key Responsibilities
Data Model Development : Design and build conceptual, logical, and physical data models for various applications, including RDBMS, operational data stores (ODS), data marts, and data lakes on platforms such as SQL and NoSQL.
Cloud Platform Expertise : Leverage experience with market-leading cloud platforms, including GCP and AWS, to optimize data models for cloud environments.
Data Relationship Design : Create data models that reflect complex data relationships, supporting efficient data ingestion, processing, and usage.
Business Requirements Translation : Work closely with stakeholders to understand business needs and translate them into scalable data models for long-term solutions.
Reverse Engineering : Conduct reverse engineering of physical data models from databases and SQL scripts to ensure data integrity and consistency.
System Integration & Solutions : Analyze data-related system integration challenges and propose effective solutions to meet data requirements.
Stakeholder Interaction : Communicate effectively with both technical and non-technical stakeholders, providing insights and solutions that align with business objectives.
Minimum Qualifications
Bachelor s degree in Computer Science, Information Technology, or equivalent work experience.
Proven experience in data modeling with expertise in designing efficient, high-quality data solutions.
Mandatory Skills
Proficiency in data modeling techniques (conceptual, logical, and physical).
Experience with data modeling tools (ER/Studio, Power Designer, Erwin).
Strong knowledge of data modeling methodologies (Dimensional modeling, Data Vault).
Expertise in data warehousing, star schema design, SQL, and query optimization.
Experience with programming languages such as Apache Spark and Python.