Description

You will design and maintain data models to support large-scale database and data warehouse environments.

Responsibilities

• Create conceptual, logical, and physical data models for databases and data warehouses.
• Optimize data structures for performance, scalability, and reliability.
• Collaborate with business analysts, architects, and developers to define database structures and gather project requirements.
• Develop and maintain data dictionaries, metadata, and documentation for all models.
• Implement data solutions on Hadoop or Hive and resolve data inconsistencies or redundancy.

Required Skills

• 5+ years of experience in data modeling or database design.
• Expertise in Data Vault (ODS) Modeling and Dimensional Data Modeling.
• Proficiency with ER Studio and MS SQL Server.
• Experience with Big Data systems including Hive and Impala.
• Strong knowledge of relational database systems like Oracle.
• Advanced understanding of normalization, denormalization, and schema design patterns.
• Familiarity with ETL processes, data warehousing, and cloud technologies.
• Knowledge of data lakes, lakehouses, and data governance frameworks.
• Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.

Preferred Skills

• Experience with Hadoop and Spark.
• Proficiency in ANSI-SQL.

Key Skills

Education

Bachelors or Masters degree in Computer Science Information Systems