Jobs → Data & Analytics → Data Modeler

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.

Similar projects

Microsoft Fabric Data Engineer
Sekhar Gopalakrishnan · Microsoft Fabric, Lakehouse, Warehouse
Snowflake Data Modeler & AI Platform Architect
Akiv Khan · Snowflake, Databricks, Generative AI
Snowflake Data Engineer
Krishna Nayak V · Snowflake, DBT, Azure Cloud
Early · 0 applied1 of 5,624 projects

Apply with AI cover letter

AI writes a personalized application in 19 seconds. Just upload your resume.

No credit card · First application free
© 2026 Freelanly · Terms · Privacy