Data Modeler

Role: IT Specialist Expert - Data Modeler

Location: Albany, NY – 100% ONSITE (need locals or from nearby states)

Visa: USC/GC/GC-EAD/H4-EAD only

Responsibilities:

The consultants 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 crosscompatibility.
• 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 TSQL 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.

Required skills:

• 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.

Job Types: Full-time, Contract

Pay: $69,478.49 - $120,000.00 per year

Schedule:

• Monday to Friday

Ability to commute/relocate:

• Albany, NY 12202: Reliably commute or planning to relocate before starting work (Required)

Application Question(s):

• NOTE: NEED ONLY ON OUR PAYROLL

What's your visa status and current location?

Experience:

• developing relational data models for OLTP databases: 7 years (Required)
• erwin OR toad Data Modeler: 5 years (Required)
• complex PL\SQL, T-SQL, and SQL development: 8 years (Required)
• data quality issues: 5 years (Required)
• developing and managing ELT/ETL processes: 1 year (Required)
• development using Agile/Scrum: 3 years (Required)
• Git and Azure DevOps: 3 years (Required)

Work Location: In person

Salary : $69,478 - $120,000