Lead Consultant, Data Analytics

Job Description

Applicants must be currently authorized to work in the United States on a full-time basis. No sponsorship is available for this position.

This is a hybrid position based in our Arlington, VA office. Individuals who are non-U.S. nationals must have lived in the United States or U.S. territory for 3 years or more.

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 our new Data Analytics Consultant, you will be part of a team that assists our clients with their data analysis and visualization needs, creating custom data workflows, building interactive dashboards, and developing bespoke applications for solving practical problems. This role includes opportunities to work directly with clients and project teams, presenting deliverables and gathering feedback. More about Galago here: www.ramboll.com/galago We are a small team of technical experts, looking for someone to come in and help us deliver consistent and engaging analysis and tools for our clients.

Your key responsibilities will be:

• Developing and maintaining Power BI reports and dashboards
• Designing new Power BI data models as well as maintaining existing data models built from a variety of data sources
• Providing technical support to users and stakeholders
• Building custom measures and queries using DAX and M Language

Your new team

As the Data Analytics Consultant, you will be part of a team that utilizes critical thinking skills and contributes to creating web mapping applications, report documents, and client-specific deliverables. The successful consultant will be able to work independently, thrive in a team-environment, and be a technical  resource for project managers and staff. Data management, report development, and data analysis are frequent needs. This role also includes opportunities to present your findings directly to clients and project teams. You may also play a role in strategically refining existing reports and dashboards, and suggesting additional, practical and beneficial uses.

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.
• 3-5 years of relevant experience using data analytics tools.  
• DAX and M programming experience within Power BI
• Experience working with Power BI Dataflows
• JavaScript development
• Experience developing Extract/Transform/Load (ETL) pipelines
• Previous experience with the US Army Corps of Engineers
• Individuals who are non-U.S. nationals must have lived in the United States or U.S. territory for 3 years or more

Personal qualities that will help you succeed in this role include: Excellent communication, writing, strategic thinking, and presentation skills;  capacity to work independently; self-motivated; organizational skills.  

What we can offer you

• Investment in your development
• Leaders you can count on, guided by our Leadership Principles
• Be valued for the unique person you are
• Never be short of inspiration from colleagues, clients, and projects
• The long-term thinking of a foundation-owned company
• Ramboll has adopted a hybrid model of work, allowing a combination of remote and in-office employee engagement.  

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 his