Lead Consultant, Data Analytics

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.

U.S. Citizenship is required for this position.  Candidates must be able to obtain and hold a Common Access Card (CAC) for 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 our new Lead Consultant, Data Analytics 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, 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

About you

• 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.
• U.S. Citizenship is required.  Candidates must be able to obtain and hold a Common Access Card (CAC) for work in this position. 

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

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 [email protected] with such requests.

All your information will be kept confidential according to EEO guidelines.