Information Technology Specialist

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 an "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

Information Technology Specialist, SQL

Responsiblities:

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

Qualifications:

• 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.
• Create clear and detailed documentation. This can include user manuals, system specifications, design documents, and release notes to support System Administrators and end-users.
• Experience with a variety of data-related technologies, including modeling and business intelligence tools.
• Ability to multitask, managing multiple projects simultaneously, and prioritizing workload.

We are committed to your success, and we invest in your growth and development to unlock your full potential.

• Competitive Total Compensation Package
• Employee- Only Stock Purchase Plan
• Mentoring programs
• Continuing Education Program
• Employee referral bonus
• Volunteer/Industry association opportunities

Compensation range for this role: Min $60,000 to Max $72,000

• The range provided is the salary that the Firm in good faith believes at the time of this posting is willing to pay for the advertised position.
• The selected candidate must be authorized to work in the United States; Visa sponsorship is not available for this role.

LiRo-Hill is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, race, color, creed, religion, national origin, ancestry, marital status, sex, affectional or sexual orientation, gender identity or expression, or protected veteran status; and will not be discriminated against on the basis of disability.

Minimum : USD $60,000.00/Yr. Maximum : USD $72,000.00/Yr.