Information Technology Specialist - SQL
The Liro Group
SQL specialist to design scripts, manage data migration, and create reports for OGS.
6 days ago ago
$60,000 - $72,000
Intermediate (4-7 years), Expert & Leadership (13+ years), Experienced (8-12 years)
Full Time
Albany, NY
Office Full-Time
Company Size
1,000 Employees
Service Specialisms
Construction services
Project Management
Consulting
Engineering
Architecture
Design
Technical Services
General Contractor
Sector Specialisms
Commercial
Healthcare
Industrial
Energy
Infrastructure
Institutional
Role
What you would be doing
data migration
system reporting
sql automation
data cleansing
documentation
troubleshooting
- Analyze business requirements to plan, execute, and validate data migration projects.
- Create and manage system reports using tools like Crystal Reports, BIRT, and Tableau.
- Automate data synchronization processes and optimize existing SQL scripts for AiM.
- Design and implement SQL scripts to support data cleansing and migration for system enhancement projects.
- Create clear and detailed documentation. This can include user manuals, system specifications, design documents, and release notes to support System Administrators and end-users.
- Work with stakeholders to build data strategies and models.
- Troubleshoot enterprise data management software systems.
What you bring
tableau
power bi
sql
etl
data mapping
us authorization
- Extensive experience with data mapping, cleansing, testing, and migration of large datasets.
- Expertise in reporting and analytics tools like Tableau and Microsoft Power BI.
- Ability to multitask, managing multiple projects simultaneously, and prioritizing workload.
- Proficiency in SQL, Microsoft SQL Server, database management, and ETL processes.
- Experience with a variety of data-related technologies, including modeling and business intelligence tools.
- Strong communication, problem-solving, documentation, and multitasking skills.
- The selected candidate must be authorized to work in the United States; Visa sponsorship is not available for this role.
- Competitive Total Compensation Package
- Employee- Only Stock Purchase Plan
- Continuing Education Program
- Mentoring programs
- Volunteer/Industry association opportunities
- 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.
- Employee referral bonus
Information not given or found
Interview process
Information not given or found
Visa Sponsorship- visa sponsorship is not available; candidate must be authorized to work in the united states.
Information not given or found
Company
Overview
1986
Year Founded
The firm traces its origins back to 1986, marking over three decades of service in engineering, architecture, and construction.
- With a strong presence in key sectors, the firm specializes in projects that require integrated solutions across multiple disciplines.
- LiRo has built a reputation for managing large-scale projects that deliver timely, cost-effective results for both public and private sector clients.
- The company’s extensive portfolio includes major infrastructure projects, residential developments, commercial buildings, and energy-related initiatives.
- Their engineering and project management expertise spans a diverse range of markets, from transportation and utilities to industrial and government projects.
- LiRo's multidisciplinary approach sets it apart, delivering seamless, innovative solutions from concept to completion.
- The company is known for its ability to manage complex, high-profile projects, often working with municipalities, government agencies, and private enterprises.
- Commitment to excellence
- Delivering value to clients through innovation and results
- Collaboration and teamwork across disciplines
- Accountability and integrity in all actions
- Respect for individuals and communities
- Commitment to employee development and success
Net-Zero by 2050
Carbon Neutrality Goal
Aim to achieve net-zero emissions by the year 2050.
- Committed to sustainable practices in all projects.
- Dedicated to reducing environmental impact through energy-efficient solutions.
- Promotes green building designs, including LEED-certified projects.
- Engages in ongoing efforts for resource conservation and waste reduction.
- Diversity and inclusion are integral to the company's corporate culture.
- Gender representation statistics are not explicitly available.
Kablio AIIf you're someone who helps build and power the world (or dreams to), Kablio AI is your pocket-sized recruiter that gets you hired.
Copyright © 2025 Kablio