Description

You design and maintain logical and physical data models to ensure data accuracy, consistency, and scalability across databases and platforms.

This role is remote.

Responsibilities

• Design conceptual, logical, and physical data models, defining entities, relationships, attributes, and data flows.
• Translate business requirements into efficient data structures and maintain data dictionaries and metadata.
• Collaborate with data engineers, DBAs, and analysts to support data warehousing and ETL processes.
• Ensure data quality, consistency, and governance standards while optimizing database performance through proper modeling.
• Maintain documentation and version control of models.

Required Skills

• 10+ years of experience in data modeling.
• Strong proficiency with ERwin for modeling tools.
• Expertise in data modeling techniques including ER modeling and dimensional modeling.
• Hands-on experience with database systems: Oracle, SQL Server, PostgreSQL, and Snowflake.
• Strong SQL and query optimization skills.
• Experience with ETL/ELT processes.
• Familiarity with big data platforms such as Hadoop and Spark.
• Ability to understand complex business processes and ensure data accuracy.

Preferred Skills

• Experience with data warehousing concepts like star and snowflake schemas.
• Familiarity with ER/Studio or PowerDesigner.

Key Skills

Education

Any Graduate