Senior Data Modeler — Remote (8+ yrs)

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

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.