Senior Lead Consultant, Data AnalyticsNew

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 their full potential.

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.

Equality, Diversity, and Inclusion

Equality, diversity, and inclusion are at the heart of what we do. At Ramboll, we believe that diversity is a strength and that different experiences and perspectives are essential to creating truly sustainable societies. We are committed to providing an inclusive and supportive work environment where everyone is able to flourish and reach their potential. 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 invite applications from candidates of all backgrounds, 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.

At Ramboll, your base pay is only part of your overall total compensation package. At the time of this posting, this role is likely to be compensated at an annual base salary between $93,861 - $140,791.  Actual pay may be more or less than the posted range, depending on numerous factors, including experience, geographical location, internal equity, market conditions, education/training and skill level, and does not include bonuses, overtime, or other forms of compensation or benefits.