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 Edison , 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
PI697278b26af0-30492-40301886
...We are Skyborne, an industry-leading aviation training academy with a mission to Build Better Pilots. As a growing business, weve invested in state-of-the-art training facilities in both the UK and U.S., as well as cutting-edge resources to deliver the very best in airline...
...Responsibilities Part- Time Pharmacy Technician Opportunity JOB DESCRIPTION: Under direct supervision, assists the Director of Pharmacy and Staff Pharmacists to compound, fill and dispense pharmaceutical preparations at the hospital pharmacy within the laws...
...business lines. Position Summary: The Manager of Sales & Marketing is a leadership role responsible for developing and executing a... ...across all marina locations, including website, social media, email, and local advertising channels. Own the marketing calendar,...
...skilled Maintenance Technician to support plant operations and help keep equipment running safely and efficiently. This is a first shift, Monday through Friday position with consistent hours, a strong team environment, and the opportunity to share in the companys...
...Were looking for a detail-oriented and motivated Remote Clinical Research Assistant to join New Paradigm Staffing, a growing healthcare staffing agency focused on supporting remote research and data programs. This role is ideal for someone who enjoys data accuracy...