IT Specialist Expert

IT SpecialistNYS Department of Public Service (DPS) is seeking an IT Specialist to serve as Data Modeler and developer in the.Net Developer Team. Implementing specific tasks will include: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.Required Qualifications: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 fieldWork hours and location:Full time role with engagement length of 30 monthsDaily work hours: 8:30 AM - 5:00 PMPhysical office location: Three Empire State Plaza, 2nd Floor, Albany, NY 12223Telecommuting options: None. Fully Onsite RoleSpruce Technology, Inc. is a mid-size, award-winning technology services firm with a steadily growing portfolio of commercial and government clients. Spruce provides innovative technology solutions, specialized IT staff, and IT strategy consulting nationwide. Spruce maintains partnerships with major technology vendors and continually develops leading-edge offerings in service areas such as digital experience, data services, application development, infrastructure, cyber security, and IT staffing. Spruce Technology, Inc. is an affirmative action and equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity, national origin, veteran status, or genetic information. Consistent with the Americans with Disabilities Act, it is the policy of Spruce Technology, Inc. to provide reasonable accommodation when requested by a qualified applicant or employee with a disability, unless such accommodation would cause an undue hardship. The policy regarding requests for reasonable accommodation applies to all aspects of employment, including the application process. All full-time employees are eligible for the following benefits: Medical, dental, vision health benefits Life Insurance and AD&D (paid by company) 401k, Flexible and Dependent Care Spending Account plans. Paid-time Off or Paid Sick Leave (amount dependent on position level and if required by state). Spruce Technology