Data Modeler (OLTP / Erwin)

Join to apply for the Data Modeler (OLTP / Erwin) role at Jobs via Dice

18 hours ago Be among the first 25 applicants

Join to apply for the Data Modeler (OLTP / Erwin) role at Jobs via Dice

Get AI-powered advice on this job and more exclusive features.

Trigyn's direct government client has an immediate need for a Data Modeler in Albany, NY.
Description:
The consultant will serve Data Modeler and developer in the .NET Developer Team implementing

• Analyzing and translating business needs into long-term solution data models.
• Evaluating existing data systems.
• Working with the development team to create conceptual data models and data flows.
• Developing best practices for data coding to ensure consistency within the system.
• Reviewing modifications of existing systems for cross-compatibility.
• Implementing data strategies and developing physical data models.
• Updating and optimizing local and metadata models.
• Evaluating implemented data systems for variances, discrepancies, and efficiency.
• Troubleshooting and optimizing data systems.
• Generate and publish data definition language (DDL) from physical data model to Oracle and SQL Server databases.
• Design and develop ELT/ETL processes for the migration of data.
• Develop and execute complex queries and procedures using T-SQL and SQL.
• Manage and maintain scripts and code in source control repository.
• Document data models, data migration and data quality requirements and solutions.
• Provide knowledge transfer to other data management team members.
• Assistance in development of software/hardware requirements for Development, User Acceptance Testing (UAT), and Production environment.
  

Mandatory Qualification:

• 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.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 months experience developing logical and physical relational data models for OLTP databases.
• 60 months experience using Erwin OR toad Data Modeler to create and maintain logical and physical data models.
• 84 months experience in complex PL\SQL, T-SQL and SQL development against SQL Server.
• 60 months experience identifying and troubleshooting data quality issues.
• 12 months experience developing and managing ELT/ETL processes.
• 36 months of experience in development using Agile/Scrum
• 36 months experience using source control and release technologies such as Git and Azure DevOps.
• Masters Degree in computer related field.
  

For Immediate Response call , or send your resume to
For Immediate Response call , or send your resume to
TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 9001:2015, ISO 27001:2013 (ISMS),ISO 20000:2018 and CMMI Level 5 certified company.

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Software Development

Referrals increase your chances of interviewing at Jobs via Dice by 2x

Get notified about new Data Modeler jobs in Albany, NY .

Requirement for Lead Data Modeler in Albany, NY

Albany, NY $58,000.00-$60,000.00 4 days ago

Albany, NY $112,597.33-$152,810.66 1 month ago

Albany, NY $86,681.00-$109,650.00 3 days ago

Albany, NY $116,480.00-$149,760.00 1 month ago

Albany, NY $63,093.33-$85,626.66 1 month ago

Albany, NY $86,681.00-$109,650.00 1 hour ago

Associate for Institutional Research (SQL Programmer)

Albany, NY $106,773.33-$144,906.66 1 month ago

Remote Work: Healthcare Data Engineer (Need only local candidates)

Albany, NY $79,700.00-$113,000.00 2 days ago

Albany, NY $137,280.00-$198,293.33 1 month ago

Records Examiner / Analyst Supporting the DEA

Albany, NY $63,000.00-$75,000.00 1 hour ago

Albany, NY $96,096.00-$138,805.33 1 month ago

Albany, NY $144,768.00-$209,109.33 1 month ago

Albany, NY $50,000.00-$200,000.00 1 month ago

Albany, NY $116,480.00-$149,760.00 1 month ago

Albany, NY $123,793.00-$156,224.00 1 day ago

Albany, NY $149,760.00-$216,320.00 1 month ago

Albany, NY $149,760.00-$216,320.00 1 month ago

Albany, NY $108,714.67-$139,776.00 1 month ago

Albany, NY $104,832.00-$142,272.00 1 month ago

Albany, NY $131,040.00-$168,480.00 1 month ago

Albany, NY $134,784.00-$194,688.00 1 month ago

Albany, NY $80,000.00-$130,000.00 1 year ago

Albany, NY $112,000.00-$144,000.00 1 month ago

Albany, NY $139,776.00-$201,898.00 1 month ago

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.

#J-18808-Ljbffr