Business Intelligence & Analytics Specialist at Ramboll · Syracuse

companyDescription 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. jobDescription 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 additionalInformation 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. Work at the heart of sustainable change with Ramboll in the Americas 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. Where People Flourish Our mission is to create sustainable societies where people and nature flourish. This means that a culture of inclusion is embedded in everything we do.  Our people bring diverse backgrounds and experiences to the company, enabling us to deliver innovative and forward-thinking solutions to our clients. We also know how important it is to achieve the right balance of where, when, and how much you work. At Ramboll, we offer flexibility as part of our positive and inclusive approach to work. We are committed to equal employment opportunity, regardless of age, disability or medical condition, gender identity, marriage and domestic partnership, pregnancy and maternity, race, ancestry, or national origin, religion or belief, sex and sexual orientation, military service and veteran status, or any other protected characteristic. Ramboll wants to ensure opportunities are accessible to candidates with disabilities. So, please let us know if there are any changes we could make to the application process to make it more comfortable for you. You can contact us at job.advert.accessibility@ramboll.com with such requests.