Demo

Lead Consultant, Data Analytics

Ramboll
Blue, PA Full Time
POSTED ON 1/2/2026
AVAILABLE BEFORE 1/31/2026
Company Description

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.

Job Description

Hybrid-based position in our Arlington, VA or Blue Bell, PA office.

U.S. Citizenship is required for this position. Candidates must be able to obtain and maintain a Federal Clearance to work in this position.

We invite you to bring your data analysis and visualization experience into play as you continue to expand your career and make a direct impact within our innovation and digital transformation team.

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 a Data Analytics Lead Consultant, you will be part of a small team of technical experts that assist our clients with their data analysis and visualization needs, creating custom data workflows, building interactive dashboards, and developing bespoke applications for solving practical problems. Specifically, this role includes the opportunity to work directly with our U.S. Department of Defense (DoD) client and other Ramboll project teams, presenting deliverables and gathering feedback. More about Galago here: www.ramboll.com/galago We are looking for engaging individuals to help us deliver consistent analysis utilizing creative analytical tools for our clients.

As a Lead consultant on our Data Analytics team, you will provide consultative services to the U.S. Army Corps of Engineers as a contractor. This is a federal contract and as such a background investigation and clearance is required. This position is contingent upon you obtaining a Public Trust level Clearance and there being a position available at the time you are cleared.

Your key responsibilities will be:


  • Developing and maintaining Power BI reports, dashboards, and dataflows to provide actionable insights.
  • Designing new Power BI data models as well as maintaining existing data models built from a variety of data sources
  • Implementing integrations with Power Automate for streamlined workflow automation.
  • Providing technical support to users and stakeholders based on knowledge of data governance and best practices
  • Building custom measures and queries using DAX and M Language


Qualifications

About you


  • U.S. Citizenship is required
  • Able to obtain and maintain a Public Trust Clearance
  • Bachelor’s degree in Computer Science, Data Analytics, Statistics, Information Systems, Engineering, or related field.
  • 5 Years Relevant experience using Power BI and Power Platform
  • Experience working with Power BI tools including Dataflows and query language such as DAX and M query.
  • Experience with financial reporting.


Additional Information

What we can offer you


  • Investment in your development
  • Leaders you can count on, guided by our Leadership Principles
  • 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


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.

Salary Transparency Statement

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 $85,515 - $101,894. 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.

Salary : $85,515 - $101,894

If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Lead Consultant, Data Analytics?

Sign up to receive alerts about other jobs on the Lead Consultant, Data Analytics career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$38,201 - $46,679
Income Estimation: 
$46,989 - $58,932
Income Estimation: 
$38,172 - $48,987
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at Ramboll

  • Ramboll Baton Rouge, LA
  • Company Description Develop your excellence in our collaborative, inclusive, diverse, and empowering culture at Ramboll! When you start with Ramboll, you’l... more
  • 13 Days Ago

  • Ramboll Syracuse, NY
  • Company Description Applicants must be currently authorized to work in the United States on a full-time basis. No sponsorship is available for this positio... more
  • 13 Days Ago

  • Ramboll Dallas, TX
  • Company Description Ramboll is a global architecture, engineering, and consultancy company. As a foundation-owned people company, founded in Denmark, we be... more
  • 13 Days Ago

  • Ramboll Rochester, NY
  • Company Description Position: Senior Construction Manager – Electrical (Data Centers) Location: Base Office: Central, NY (Syracuse, Buffalo, Rochester) U.S... more
  • 14 Days Ago


Not the job you're looking for? Here are some other Lead Consultant, Data Analytics jobs in the Blue, PA area that may be a better fit.

  • Ramboll US Corporation Blue, PA
  • Company Description Ramboll is a global architecture, engineering, and consultancy company. As a foundation-owned people company, founded in Denmark, we be... more
  • 1 Month Ago

  • seisandbox Philadelphia, PA
  • WHO WE LOOK FOR An SEI-er is a master communicator and active listener who understands how to navigate an audience. Self-aware, almost to a fault, SEI-ers ... more
  • 1 Month Ago

AI Assistant is available now!

Feel free to start your new journey!