> Markdown version of [/jobs/ext/1251429-data-modeler](https://www.wearedevelopers.com/jobs/ext/1251429-data-modeler). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Modeler

- **Company:** RightTalents LLC
- **Location:** Albany, NY, United States
- **Experience:** Expert
- **Contract:** Temporary to permanent
- **Skills:** Databases, Data Architecture, Data Conversion, Data Manipulation Languages, Data Mapping, IBM DB2, Job Scheduling, Microsoft SQL Server, Performance Tuning, Software Engineering, SQL Stored Procedures, PL-SQL, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Freeform SQL, Usage Tracking, Physical Data Models, Redgate, SQL Server Management Studio (SSMS), Programming Languages
- **Published:** July 12, 2026
- **Apply:** https://www.careerjet.com/jobad/us5d8de58dd8c2b87ebef4df3f07dd1acc

## About the Role

* 84 months of experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures.
 * 84 months of experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis.
 * 84 months of experience writing complex DML SQL against enterprise SQL Server and DB2 databases.
 * 84 months of experience working with tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO.
 * 84 months of experience using programming languages such as SQL, PL/SQL.
 * 60 months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases.

## Description

Provide a list of the day-to-day tasks to be performed by the Candidate:

 * Build and maintain a data architecture based on the requirements.
 * Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases.
 * Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data.
 * Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts.
 * Performance tuning SQL to improve efficiency.
 * Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules.
 * Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation.
 * Create clear and accurate documentation on data models, and description of data usage in the application process flow.


## Related Videos

- [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization)
- [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt)
- [Beyond SQL Generation: How to Teach Agents What Your Database Actually Means](https://www.wearedevelopers.com/videos/100127-beyond-sql-generation-how-to-teach-agents-what-your-database-actually-means)
- [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering)

## Related Articles

- [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)
- [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)
- [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk)
- [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market)
- [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)
- [Résumé-Driven Development: How IT trends affect the job market for software developers](https://www.wearedevelopers.com/magazine/59-resume-driven-development-how-it-trends-affect-the-job-market-for-software-developers)