Data Modeling & SQL Engineer (ETL/ELT)

Saathi Digital; City of Albany (NY); On-site; USD 85,000 - 138,000; Full time

Job summary

Saathi Digital in Albany, NY, seeks an IT Specialist Expert for a full-time, 30-month engagement. You will develop logical and physical data models for OLTP databases, using tools like Erwin or TOAD, and perform complex SQL development against SQL Server.

Expect to identify and troubleshoot data quality issues while delivering reliable ELT/ETL processes. The role involves Agile/Scrum practices and using Git/Azure DevOps for version control.

Qualifications

• Experience designing logical and physical relational data models for OLTP databases.
• Hands-on with Erwin Data Modeler and TOAD Data Modeler for modeling tasks.
• Strong SQL development skills in PL/SQL and T-SQL against SQL Server.
• Ability to identify and fix data quality issues across datasets.
• Experience building and managing ELT/ETL processes.
• Familiarity with Agile/Scrum practices and source control (Git, Azure DevOps).
• Knowledge of data governance and release processes is a plus.

Skills

Relational data modeling

OLTP databases

PL/SQL

T-SQL

ETL/ELT

Agile/Scrum

Data quality

Tools

Erwin Data Modeler

TOAD Data Modeler

Git

Azure DevOps

SQL Server

Job description

Saathi Digital in Albany, NY, seeks an IT Specialist Expert for a full-time, 30-month engagement. You will develop logical and physical data models for OLTP databases, using tools like Erwin or TOAD, and perform complex SQL development against SQL Server.

Expect to identify and troubleshoot data quality issues while delivering reliable ELT/ETL processes. The role involves Agile/Scrum practices and using Git/Azure DevOps for version control.