Greetings from
Sligo Software Solutions, Inc. !!
This is
Deepika from SLIGO. We have an urgent requirement for
Sr. Data Modeler position with our client.
Title : Sr. Data Modeler
Location : Albany, New York
Duration : 24 Months
Client : NY State - Workers’ Compensation Board
Job ID: SLG - 19 - 11386
Respond by: 11/24/25 5:00 PM
Greetings from
Sligo Software Solutions, Inc. !!
SLIGO is a Software Development & IT Consulting company. We have around 100+ IT associates working with our esteemed clients across several domains such as IT, Banking, Healthcare, and Government.
We have an urgent requirement for Sr. Data Modeler position with our client.
Role: Sr. Data Modeler
Location: Albany, New York
Duration: 24 Months
Job ID: SLG - 19 - 11386
Client: NY State - Workers’ Compensation Board
Description
The position is required to provide data management expertise supporting the continued development and maintenance of WCB systems. Working as part of a DevOps environment, the position will be responsible for the development and maintenance of ETL/ELT pipelines in Azure ADF and/or data migration processes, T-SQL and SQL scripts. In addition, the resource will review business requirements documents, analyze and profile source data, maintain scripts in source control repository, performance tune scripts, review and troubleshoot data quality alerts, prepare source to target mapping documents and execute data manipulation language (DML) scripts. The duties will be performed against both cloud-based and on-premises databases.
Duties
- Generate and publish data definition language (DDL) from physical data model to Azure cloud-based and/or on-premises SQL Server databases.
- Design and develop ELT/ETL processes for the migration of data using various ETL tools, mainly MS ADF.
- Manage, monitor and troubleshoot Azure Data Factory pipelines.
- Identify and troubleshoot data quality issues.
- Develop and execute complex queries and procedures using T-SQL and SQL.
- Manage and maintain scripts and code in source control repository.
- Interact with the development team and business users to understand business process flow and business rules.
- Design and document data models, data migration and data quality requirements and solutions.
- Provide knowledge transfer to other data management team members.
Mandatory Requirements
- Experience (12+ Years)
- Works in the field of Information Technology, experienced in the usage and support of a collection of development platforms, technical architectures or business applications and products that run on those platforms - beyond that of a Programmer.
Requirements
- This is an 100% Onsite.
- 84 months experience developing logical and physical relational data models for OLTP databases.
- 60 months experience using Erwin Data Modeler to create and maintain logical and physical data models.
- 84 months experience in complex T-SQL and SQL development against SQL Server.
- 60 months experience identifying and troubleshooting data quality issues.
- 48 Months experience developing and managing Azure Data Factory ELT/ETL processes.
- 48 months experience using source control and release technologies such as Git and Azure DevOps.
- Résumé
- Copy of Candidate Identification (i.e., Driver’s License/Green Card/Visa and Passport if applicable)
- Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.)
Thanks & Regards
Deepika Pagalla
Senior Talent Acquisition Specialist
Sligo Software Solutions Inc.
deepika.pagalla@sligosoft.com
www.sligosoft.com
Direct: (518) 415 1584
Office: (518) 444-0459 X 121
Fax: (518) 444 0457
IMPORTANT NOTICE: This e-mail and any attachments may contain confidential or sensitive information which is, or may be, legally privileged or otherwise protected by law from further disclosure. It is intended only for the addressee. If you received this in error or from someone who was not authorized to send it to you, please do not distribute, copy or use it or any attachments. Please notify the sender immediately by reply e-mail and delete this from your system. Thank you for your cooperation.
