Jobs via Dice
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
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