Business Intelligence & Analytics Specialist

Ramboll•City of Syracuse, NY

2d•$82,029 - $121,505•Hybrid

About The Position

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

Requirements

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

Responsibilities

Source, extract, and clean raw data from corporate resources and the internal data warehouse.
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.
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.
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.

Benefits

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
comprehensive benefits package that supports well-being, professional development, and work-life balance

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume