Data Modeler
Nitya SoniRemoteSENIORPosted 13h ago
Data ModelingData ArchitectureErwinER/StudioPowerDesignerData Vault 2.0Dimensional ModelingODSSQLPL/SQLSnowflakeAzureAWSGCPRedshiftDatabricksOraclePostgreSQLMySQLHadoop
About the Role
We are looking for a skilled Data Modeler to join our Data Management team. You will design and implement conceptual, logical, and physical data models to support enterprise data warehouses, data lakes, and analytics initiatives.
Key Responsibilities
• Design, maintain, and optimize conceptual, logical, and physical data models (Dimensional, ODS, and Data Vault 2.0—Hubs, Links, Satellites).
• Translate business needs into source-to-target transformation mappings, raw/business vaults, and data flows.
• Implement data architectures across RDBMS, data marts, and cloud data lakes (SQL/NoSQL).
• Perform data profiling, data quality analysis, and reverse engineering of existing databases.
• Establish modeling standards, naming conventions, metadata management, and query performance optimizations.
• Guide developers, analysts, and project teams on data architecture best practices and system integration.
Requirements
• Minimum 8 years in data architecture/data modeling, including 5–7 years in a management role.
• 7–10 years of implementation experience with Erwin, ER/Studio, PowerDesigner, or similar tools.
• Strong command of Data Vault 2.0, Dimensional Modeling, ODS, and full SDLC.
• Hands-on experience with cloud platforms (Snowflake preferred, Azure, AWS, GCP) and databases/big data tools (Redshift, Databricks, Oracle, PostgreSQL, MySQL, Hadoop).
• Strong SQL skills (PL/SQL and scripting preferred) along with data profiling and integration expertise.