Information Technology Specialist - SQL
LiRo-Hill
sql scripting
data migration
data sync
report development
system troubleshooting
data strategy
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.
sql
etl
tableau
power bi
communication
problem solving
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.
- The selected candidate must be authorized to work in the United States; Visa sponsorship is not available for this role.
- Mentoring programs
- Employee referral bonus
- Continuing Education Program
- 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.
- Competitive Total Compensation Package
- Employee- Only Stock Purchase Plan
- Volunteer/Industry association opportunities
- visa sponsorship is not available for this role.
Founded in 1984
Year Established
The company was established in 1984, marking its beginning as a leader in the architecture and construction industry.
Thousands of projects
Projects Completed
The firm has successfully managed and designed thousands of projects, showcasing its expertise across various scales and complexities.
- The firm has built a reputation for delivering high-quality and technically proficient solutions across a diverse range of projects.
- The company is recognized for its ability to complete projects efficiently, ensuring cost-effectiveness and adherence to timelines.
- LiRo's innovative approach is further exemplified by its involvement in some of the country's top projects, leveraging advanced technologies such as GIS BIM integration and virtual design and construction services.
- A commitment to diversity, inclusion, and a collaborative work environment.
- Empowers employees to share ideas and contribute to innovative solutions.
- Inclusive culture essential for building the workplaces of the future.
- Fosters a sense of belonging among its diverse workforce.
- Values a practical, hands-on approach to projects.
- Integrates constructability into engineering designs for effective and efficient outcomes.
- Actively involved in environmental construction and site assessments, focusing on projects that enhance indoor air quality and address environmental concerns in New York, the Northeast, and the West Coast.
- Involved in environmental consulting services for the New York City Department of Design & Construction (DDC), managing programs like the Storage Tank Program and Remediation Program. These programs involve the investigation, design, and remediation of storage tank facilities and contaminated sites.
- Contributes to environmental sustainability while enhancing its reputation as a leader in sustainable construction and engineering practices.
- Fosters a workplace environment that values and empowers all employees, encouraging them to share their ideas and maximize their potential.
- Engages minority and women-owned business enterprises (MWDBE) through strategic partnerships.
- Actively involves MWDBE firms in projects, providing mentoring and training for effective participation and success, including guidance to Section 3 hires.
