Business Intelligence & Analytics Specialist

Company Description

Ramboll is a global architecture, engineering, and consultancy company. As a foundation-owned people company, founded in Denmark, we believe that the purpose of sustainable change is to create a thriving world for both nature and people. So, that’s where we start – and how we work. Our history is rooted in a clear vision of how a responsible company should act and being open and curious is a cornerstone of our culture. Ramboll in the Americas has thousands of experts working across more than 70 offices. Ramboll experts deliver innovative solutions across Environment & Health, Water, Energy, and Planning & Urban Design.

Job Description

This is a hybrid-based position in our Syracuse, NY office. 

Applicants must be currently authorized to work in the United States on a full-time basis. No sponsorship is available for this position.

Are you eager to develop your excellence in an inclusive, collaborative, and empowering community? Are you excited about joining a company that strives to make a difference – for its employees, clients, and society?   

We are looking for a hands-on Analyst with strong SQL, VBA, and .NET skills who can turn business performance data into reliable, actionable reporting. The role requires intermediate SQL query expertise (temporary tables, indexes, joins, expressions) and practical experience with SQL Server, SSMS, Stored Procedures and Table-Valued Functions.

Your new role  

Ramboll is seeking a Business Intelligence & Analytics Specialist for an open position in our Syracuse office.  The ideal candidate will be working in a challenging and dynamic environment that will include a detail-oriented team and independent work. 

Your key responsibilities will be: 

• SQL Data Sourcing 
  • Extract data from corporate databases.
• Analytics & Business Intelligence
  • Translate complex business requirements from Client, Sales, and Operations teams into actionable KPIs and metrics.
  • Design, build, and deploy interactive dashboards that empower leadership to make data-driven decisions.
• Optimize and support Legacy Applications
  • Maintain and make functional enhancements to existing Excel-based project management tools utilizing VBA.
  • Proactively identify opportunities to migrate legacy, manual spreadsheets into automated, centralized BI solutions.
  • Document tool architecture and logic to ensure business continuity and straightforward system updates.
• AI-Driven Process Improvement
  • Collaborate cross-functionally to identify operational bottlenecks and manual workflows.
  • Research, test, and implement emerging AI tools to streamline day-to-day operations.

Qualifications

About you 

• Bachelor's degree in a technical field and 5 years of relevant experience 
• Intermediate SQL Server skills (temporary tables, indexes, joins, expressions)
• Proficiency with SSMS and familiarity with Stored Procedures and Table-Valued Functions
• Intermediate experience with Visual Studio 2022 or newer.  Working knowledge of VB.Net and ability to edit, compile and distribute existing .NET applications
• Experience with VBA (Excel and MS Access) for reporting/automation
• Understanding of business practices for project costs and revenue, plus basic knowledge of financial and project management systems
• Demonstrated experience or eagerness to become fluent in BI reporting
• Understanding of AI prompt engineering and development of AI-enabled applications
• Familiarity with Remote Desktop and basic server app management
• Comfort navigating large networks and related infrastructure constraints

Additional Information

What we can offer you

• Investment in your development
• Being valued for the unique person you are
• Never being short of inspiration from colleagues, clients, and projects
• The long-term thinking of a foundation-owned company

Salary Transparency Statement

At Ramboll, we are committed to fair and transparent compensation practices that support our people and our purpose of creating sustainable societies. The anticipated base salary range for this position is $82,029-$121,505 per year. This range reflects the compensation we reasonably expect to offer at the time of posting. Actual compensation will vary based on factors such as location, skills, experience, education, and internal equity. Because we operate across multiple U.S. markets, pay may differ depending on the cost of labor in specific locations. In addition to base salary, this position may be eligible for bonus, overtime or other forms of compensation and we offer a comprehensive benefits package that s