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 Power BI Developer/Analyst with strong SQL and .NET skills who can turn business performance data into reliable, actionable reporting. The role requires intermediate SQL query expertise (CTEs, 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:

• Data Warehousing & Integration
  • Source, extract, and clean raw data from corporate resources and the internal data warehouse.
• Analytics & Business Intelligence
  • Translate complex business requirements from Client, Sales, and Operations teams into actionable KPIs and metrics.
  • Design, build, and deploy interactive Power BI 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.
  • Champion a culture of innovation, exploring how predictive analytics and AI can reduce costs and scale operations.

Qualifications

About you

• Intermediate SQL Server skills ( CTEs, temporary tables, indexes, joins, expressions)
• Proficiency with SSMS and familiarity with Stored Procedures and Table-Valued Functions
• Intermediate experience with Visual Studio 2017 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 a Subject Matter Expert (SME) for 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 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.

Thank you for taking the time to apply! We look forward to receiving your application.