Data Modeller

Win Solutions; United States; Remote; USD 83,000 - 124,000; Part time

Job summary

Win Solutions is seeking an experienced Data Modeler for a 3-month remote engagement in the United States. The role requires 8+ years in data modeling, data architecture, or related roles, translating business needs into robust data models across conceptual, logical, and physical layers.

You will partner with Data Architects and developers to design scalable data solutions, build data flows, and ensure data quality and governance.

Qualifications

• 8+ years of hands-on data modeling experience (OLTP, OLAP, dimensional, 3NF, Data Vault).
• Strong expertise in conceptual, logical, and physical modeling.
• Proficiency with modeling tools (ERwin, ER/Studio, Power Designer, or equivalent).
• Advanced SQL skills; experience with relational databases (Oracle, SQL Server, PostgreSQL, MySQL).
• Experience with data warehouses/lakes (Snowflake, Redshift, BigQuery, Synapse, Databricks).
• Solid understanding of ETL/ELT processes and data integration patterns.
• Experience with metadata management, data governance, and data quality practices.
• Ability to reverse engineer models from existing databases and scripts.
• Strong analytical, problem-solving, and communication skills; ability to engage both technical and business stakeholders.
• Bachelor’s degree in Computer Science, Engineering, IT, or a related field.

Responsibilities

• Translate business requirements into data models and associated solutions.
• Partner with Data/Dev teams to implement data strategies, build data flows, and develop data models.
• Create, define, maintain, and optimize logical and physical data models using best practices, ensuring high data quality, minimal redundancy, and consistent metadata.
• Design and implement conceptual, logical, and physical models.
• Identify opportunities to reuse data models in new environments.
• Reverse engineer physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variance, discrepancies, and efficiency.
• Analyze data integration challenges and propose solutions.
• Identify architecture, infrastructure, and interfaces to data sources, automated dataload tooling, security concerns, analytics models, and data visualization.
• Collaborate with Data Architects and business teams to meet modeling requirements.
• Perform data cleansing, wrangling, conversion, and integration; support development and testing; resolve data issues across large, varied datasets.

Skills

Data modeling

Modeling tools

SQL

Databases

Data warehouses

ETL

Metadata

Data governance

Reverse engineering

Communication

Education

Bachelors degree in CS/Engineering/IT

Tools

ERwin

ER/Studio

Power Designer

Job description

Role & responsibilities

Contract - 3months

Work mode - Remote

Shift Timings - 2PM to 11PM

Job Description: Data Modeler (8+ Years Experience)

Role Summary

We are seeking an experienced Data Modeler to translate business needs into robust

conceptual, logical, and physical data models. You will work closely with Data Architects,

developers, and business stakeholders to design scalable, high-quality data solutions.

Experience: 8+ years in data modeling, data architecture, or related roles

Key Responsibilities

• Translate business requirements into data models and associated solutions.
• Partner with Data/Dev teams to implement data strategies, build data flows, and develop data models.
• Create, define, maintain, and optimize logical and physical data models using best practices, ensuring high data quality, minimal redundancy, and consistent metadata.
• Design and implement conceptual, logical, and physical models.
• Identify opportunities to reuse data models in new environments.
• Reverse engineer physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variance, discrepancies, and efficiency.
• Analyze data integration challenges and propose solutions.
• Identify architecture, infrastructure, and interfaces to data sources, automated dataload tooling, security concerns, analytics models, and data visualization.
• Collaborate with Data Architects and business teams to meet modeling requirements.
• Perform data cleansing, wrangling, conversion, and integration; support development and testing; resolve data issues across large, varied datasets.

Required Skills & Qualifications

• 8+ years of hands-on data modeling experience (OLTP, OLAP, dimensional, 3NF, Data Vault).
• Strong expertise in conceptual, logical, and physical modeling.
• Proficiency with modeling tools (ERwin, ER/Studio, Power Designer, or equivalent).
• Advanced SQL skills; experience with relational databases (Oracle, SQL Server, PostgreSQL, MySQL).
• Experience with data warehouses/lakes (Snowflake, Redshift, BigQuery, Synapse, Data bricks).
• Solid understanding of ETL/ELT processes and data integration patterns.
• Experience with metadata management, data governance, and data quality practices.
• Ability to reverse engineer models from existing databases and scripts.
• Strong analytical, problem-solving, and communication skills; ability to engage both technical and business stakeholders.
• Bachelors degree in Computer Science, Engineering, IT, or a related field.

Preferred Skills

• Exposure to NoSQL databases (MongoDB, Cassandra) and semi-structured data (JSON, Parquet).
• Experience with cloud platforms (AWS, Azure, GCP).
• Familiarity with BI/visualization tools (Power BI, Tableau).
• Knowledge of data security, privacy, and compliance (GDPR, etc.).
• Experience in Agile delivery environments.
• Python or scripting for data wrangling.

Soft Skills

• Stakeholder management and requirement elicitation
• Documentation and presentation skills
• Collaborative, detail-oriented, and proactive