Senior Lead Consultant, Data Analytics

Company Description

Ramboll is a leading engineering and consulting firm specializing in delivering innovative solutions to the data center sector. Our expertise spans design, construction, and operational consulting, ensuring mission-critical facilities are optimized for performance, efficiency, and sustainability. We pride ourselves on our commitment to excellence, collaboration, and fostering long-term partnerships with our clients.

Job Description

Job locations - Chicago, IL, Arlington, VA, Blue Bell, PA. Hybrid work arrangements are available.

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 passionate about leveraging data analytics to drive meaningful environmental change? Do you thrive in a dynamic, collaborative environment with opportunities for cross-functional teamwork? Are you excited to use your expertise to lead and advise clients on cutting-edge data solutions?

If this sounds like you, or you’re curious to learn more, then this role could be the perfect opportunity. Join our team and work with us to close the gap to a sustainable future.

Your new role

As our new Senior Lead Consultant – Data Analytics, you will play a pivotal role in applying advanced analytics to address complex environmental challenges and strengthen our firm’s digital capabilities. You will lead the integration of data analytics, strategic thinking, and environmental domain expertise to deliver high-quality, actionable outcomes for clients. In this role, you’ll serve as both a technical expert and a strategic advisor, guiding clients through data-driven decision-making processes and fostering strong, collaborative relationships.

Your key responsibilities will include:

• Designing and delivering innovative data analytics solutions that support and advance environmental strategies.
• Overseeing data acquisition, processing, and visualization efforts using tools such as SQL, Python, Tableau, and Power BI.
• Serving as a trusted advisor to clients by translating complex data into clear, compelling insights that drive business and environmental outcomes.
• Partnering with multidisciplinary teams to combine analytical methods with subject matter knowledge across projects.
• Identifying and implementing opportunities for automation, workflow optimization, and improved data governance practices.

Your new team

As part of our team, you will be part of a creative group, filled with people who are really excited about solving clients’ problems and creating sustainable solutions for them. You will work with all levels of technical expertise from entry level team members to members with decades of experience, many of whom are subject matter experts in their own fields. And you will engage in a continual learning environment through coaching, mentoring, and on the job tasks.

About you

From the moment you start at Ramboll, we will support your personal and professional development so that you can continue to grow with the company. While we look forward to supporting your continued learning and development, for this role we have identified some qualifications, skills, and capabilities that will set you up for success.

These include: 

• Bachelor’s degree in Computer Science, Data Analytics, Statistics, Information Systems, Engineering, or related field and 6+ years relevant experience using Power BI and Power Platform
• Expertise in data visualization tools (e.g., Power BI, Looker, Tableau).
• Highly proficient with SQL, DAX, and M query.
• Strong understanding of data management and governance.
• Ability to translate complex data into clear, actionable insights.

What we can offer you

• Commitment to your development
• Leaders guided by our Leadership Principles
• A culture that welcomes you as the unique person you are
• Inspiration from colleagues, clients, and projects
• The long-term thinking of a foundation-owned company

Work at the heart of sustainable change

Ramboll is a global architecture, engineering, and consultancy company. 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. At Ramboll, our core strength is our people, and our history is rooted in a clear vision of how a responsible company should act. Being open and curious is a cornerstone of our culture. We embrace an inclusive mindset that looks for fresh, diverse, and innovative perspectives. We respect, embrace, and invite diversity in all forms to actively cultivate an environment where everyone can flourish and realize t