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
ResponsibilitiesThe 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.
Compensation range for this role: Min $60,000 to Max $72,000
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.
#ID22
#ZR22
#LI-CM
Compensation details: 60000-72000 Yearly Salary
PI6c3b443d3b4d-30492-38781942
...process to document the assembly process for passenger train coaches to facilitate future analysis and training Coordinate with Production associates to capture established content of work on film orders as they are being produced in Sacramento train factory Manage...
...Were looking for friendly, patient, and reliable individuals to join our team as Remote Phone Support Representatives. In this work-from-home role, youll handle incoming customer calls, assisting with questions, providing information, and helping resolve basic issues....
...Summary The position is for a Research Assistant I to provide responsible assistance for establishment and propagation of organoid cultures... ...complete assignments under minimal supervision. Technical experience is required in sterile maintenance and culturing of cells,...
...responsibilities, and leadership roles that the Body Handler / Personal Assistant shall provide will include but are not limited to:... ...communication, coordination, and operational execution. Support real-time adjustments to routes, schedules, and itineraries in...
Join Cleveland Clinic and experience world-class healthcare at its best. This outpatient therapy clinic , opening in Erie, Pennsylvania , operates through a strategic partnership between Cleveland Clinic and Physicians Rehab Solution (PRS)the official employer...