Business Intelligence & Analytics Specialist

Ramboll; United States; Hybrid; USD 82,029 - 121,505; Full time

Benefits offered by this job

Development opportunities

Inclusive culture

Collaborative environment

Foundation-backed company

Job summary

Ramboll in Syracuse, NY seeks a hands-on Business Intelligence & Analytics Specialist to turn performance data into actionable reporting. You will work hybrid from our Syracuse office, with a focus on SQL data sourcing, BI dashboard design, and migrating legacy VBA tools to modern BI solutions.

The role requires 5 years of relevant experience and strong SQL/SSMS skills. You will collaborate across Client, Sales, and Operations teams, build KPIs, and enable leadership with data-driven decisions.

Qualifications

• 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

Responsibilities

• SQL Data Sourcing: Extract data from corporate databases.
• Analytics & BI: Translate requirements into KPIs and metrics; design, build, and deploy dashboards for leaders.
• Optimize and support Legacy Applications: Maintain and enhance Excel-based tools with VBA; migrate to centralized BI solutions; document architecture for continuity.
• AI‑Driven Process Improvement: Collaborate cross‑functionally to identify bottlenecks; research and implement AI tools to streamline operations.

Education

Bachelor’s degree in a technical field

Tools

SQL Server

SSMS

Stored Procedures

Table-Valued Functions

Visual Studio 2022

VB.Net

Excel

MS Access

Remote Desktop

Server app management

Job 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.

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.

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

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 supports well‑being, professional development, and work‑life balance. Our recruiters are happy to share more about the specific salary range and total rewards package applicable to your location during the hiring process.

Ready to join us?

Please submit your application with your up‑to‑date CV. We invite diversity in all its forms and encourage applicants from all groups to apply.

You can contact us at [e-mail] with such requests.