Lead Consultant, Data Analytics at Ramboll in Blue Bell, PA | USD85,515-101,894 | Kablio

Role

Description

power automate

power bi

technical support

dax queries

data modeling

workflow automation

Implementing integrations with Power Automate for streamlined workflow automation.
Developing and maintaining Power BI reports, dashboards, and dataflows to provide actionable insights.
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
Designing new Power BI data models as well as maintaining existing data models built from a variety of data sources

Requirements

bachelor's

financial reporting

public trust

u.s. citizenship

power bi

power platform

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

Benefits

Investment in your development

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

requires a background investigation and public trust clearance for the federal contract.

Company

Overview

35 Countries

Global Presence

The company has expanded its operations to over 35 countries worldwide, showcasing its international reach and influence.

Revenue 2022

Annual Revenue

The company achieved a revenue of DKK 16 billion in 2022, reflecting its strong financial performance.

Net Income 2022

Profitability

With a net income of DKK 937 million in 2022, the company demonstrated consistent profitability and growth.

Evolved from a Nordic firm into a multinational player with offices in over 35 countries.
Renowned for landmark infrastructure: Öresund Bridge, Great Belt Bridge, Copenhagen Opera House, Tate Modern extension.
Offers multidisciplinary services spanning structural design, geotechnical, HVAC, traffic, environmental and digital engineering.
Typical projects include urban transport systems, cultural icons, energy plants, water infrastructure and environmental assessments.
Unusual engagements: projects in Antarctica and immersive tunnels like Fehmarn Belt.
Owned by an independent foundation, enabling long-term investment in innovation and reinvestment into the firm.

Culture + Values

Focus on cultivating meaningful insights and achieving high standards in all endeavors.
Commitment to ethical practices and understanding customers' and team members' needs.
Encouraging collaborative environments where everyone feels confident to contribute ideas and take ownership of their roles.
Create a positive work atmosphere where employees can engage with their work enthusiastically.

Environment + Sustainability

90% reduction

GHG Emissions Target

Achieve a 90% reduction in greenhouse gas emissions across scopes 1, 2, and 3 by 2040, with the remaining 10% neutralized through carbon removal.

53.9% reduction

Scope 1 & 2 Emissions

Aim to reduce scope 1 and 2 emissions by 53.9% by 2030.

70% suppliers

Science‑Based Targets

Ensure that 70% of suppliers (by emissions) have science‑based targets by 2028.

40% EVs

Electric Vehicle Fleets

Over 40% of company fleets in multiple European countries are electric vehicles.

Approved by Science Based Targets initiative (May 2024)
Exiting oil & gas exploration before end‑2025; redeploying expertise to renewables
ISO 14001‑certified environmental management system

Inclusion & Diversity

37% Women Workforce

Global Workforce Demographics

The company has 37% women representation across the total workforce as of 2023.

32% Women Top Management

Top Management Gender Representation

32% of top management roles (including GEB, leadership, and global function heads) are held by women.

92% Survey Participation

Employee Engagement Survey

The annual ESES employee survey had a 92% participation rate among employees.

4.2/5 Satisfaction

Employee Satisfaction Score

Employees scored the company a 4.2/5 satisfaction rating in the 2023 ESES survey.

Aim to achieve ~40% women representation in the workforce by the end of the strategy period.
Women in new hires: 40% globally.
Women in senior leadership: 27–32% (2023–2024).
Aspirational EDI goals include building a culture of inclusion and belonging, ensuring balanced gender representation, and embedding diversity and equity in people processes.
Key EDI initiatives include Women in STEM mentorship, STEM school partnerships, menopause and safety workshops, Girls’ Day in Science, and strategic partnerships with organizations like NSBE and HunterWiSE.

Articles

Engineering and Design

Management Consulting

Project and Portfolio Management Solutions

Smart Mobility

Environmental and Nature‑based Services

Energy Infrastructure

Company

Overview

35 Countries

Global Presence

The company has expanded its operations to over 35 countries worldwide, showcasing its international reach and influence.

Revenue 2022

Annual Revenue

The company achieved a revenue of DKK 16 billion in 2022, reflecting its strong financial performance.

Net Income 2022

Profitability

With a net income of DKK 937 million in 2022, the company demonstrated consistent profitability and growth.

Evolved from a Nordic firm into a multinational player with offices in over 35 countries.
Renowned for landmark infrastructure: Öresund Bridge, Great Belt Bridge, Copenhagen Opera House, Tate Modern extension.
Offers multidisciplinary services spanning structural design, geotechnical, HVAC, traffic, environmental and digital engineering.
Typical projects include urban transport systems, cultural icons, energy plants, water infrastructure and environmental assessments.
Unusual engagements: projects in Antarctica and immersive tunnels like Fehmarn Belt.
Owned by an independent foundation, enabling long-term investment in innovation and reinvestment into the firm.

Culture + Values

Focus on cultivating meaningful insights and achieving high standards in all endeavors.
Commitment to ethical practices and understanding customers' and team members' needs.
Encouraging collaborative environments where everyone feels confident to contribute ideas and take ownership of their roles.
Create a positive work atmosphere where employees can engage with their work enthusiastically.

Environment + Sustainability

90% reduction

GHG Emissions Target

Achieve a 90% reduction in greenhouse gas emissions across scopes 1, 2, and 3 by 2040, with the remaining 10% neutralized through carbon removal.

53.9% reduction

Scope 1 & 2 Emissions

Aim to reduce scope 1 and 2 emissions by 53.9% by 2030.

70% suppliers

Science‑Based Targets

Ensure that 70% of suppliers (by emissions) have science‑based targets by 2028.

40% EVs

Electric Vehicle Fleets

Over 40% of company fleets in multiple European countries are electric vehicles.

Approved by Science Based Targets initiative (May 2024)
Exiting oil & gas exploration before end‑2025; redeploying expertise to renewables
ISO 14001‑certified environmental management system

Inclusion & Diversity

37% Women Workforce

Global Workforce Demographics

The company has 37% women representation across the total workforce as of 2023.

32% Women Top Management

Top Management Gender Representation

32% of top management roles (including GEB, leadership, and global function heads) are held by women.

92% Survey Participation

Employee Engagement Survey

The annual ESES employee survey had a 92% participation rate among employees.

4.2/5 Satisfaction

Employee Satisfaction Score

Employees scored the company a 4.2/5 satisfaction rating in the 2023 ESES survey.

Aim to achieve ~40% women representation in the workforce by the end of the strategy period.
Women in new hires: 40% globally.
Women in senior leadership: 27–32% (2023–2024).
Aspirational EDI goals include building a culture of inclusion and belonging, ensuring balanced gender representation, and embedding diversity and equity in people processes.
Key EDI initiatives include Women in STEM mentorship, STEM school partnerships, menopause and safety workshops, Girls’ Day in Science, and strategic partnerships with organizations like NSBE and HunterWiSE.

Articles

Engineering and Design

Management Consulting

Project and Portfolio Management Solutions

Smart Mobility

Environmental and Nature‑based Services

Energy Infrastructure