Information Technology Specialist - SQL

The LiRo Group•Albany, NY

4d•$60,000 - $72,000•Onsite

About The Position

Overview We're looking for a SQL Information Technology Specialist in Albany, NY Come join our team! We are looking to build services and capabilities through the growth of our key asset- our staff. Ranked among the nation's top A/E firms by Engineering News-Record, LiRo-Hill provides construction management, engineering, environmental, architectural, and program management solutions. You can become part of an organization that has a strong track record and is looking to strengthen relationships and capabilities to continue being a trusted resource for our clients in the public and private sector. We are proud to be known as a n “ Integrated Construction, Design and Technology Solutions” firm and we have delivered on that label time and again. Recently, Global Infrastructure Solutions Inc. (GISI), the parent company of The LiRo Group and Hill International, Inc. consolidated a portion of the highly experienced staff of both LiRo and Hill in the Northeast to create a larger, more efficient, and cost-effective team to serve clients. LiRo-Hill is a 1100-person firm with offices in NYC, Long Island, Buffalo, Rochester, Boston and Metro Park, NJ. The client for this position is the NYS Office of General Services (OGS) in Albany, NY Information Technology Specialist for SQL Responsibilities The client is the Real Estate Division of the NYS Office of General Services (OGS) in Corning Tower, Albany, NY

Requirements

Proficiency in SQL, Microsoft SQL Server, database management, and ETL processes.
Extensive experience with data mapping, cleansing, testing, and migration of large datasets.
Expertise in reporting and analytics tools like Tableau and Microsoft Power BI.
Strong communication, problem-solving, documentation, and multitasking skills.
Experience with a variety of data-related technologies, including modeling and business intelligence tools.
Ability to multitask, managing multiple projects simultaneously, and prioritizing workload.

Responsibilities

Design and implement SQL scripts to support data cleansing and migration for system enhancement projects.
Automate data synchronization processes and optimize existing SQL scripts for AiM.
Create and manage system reports using tools like Crystal Reports, BIRT, and Tableau.
Analyze business requirements to plan, execute, and validate data migration projects.
Troubleshoot enterprise data management software systems.
Work with stakeholders to build data strategies and models.
Create clear and detailed documentation. This can include user manuals, system specifications, design documents, and release notes to support System Administrators and end-users.