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:  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 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. Be sure to include all relevant documents including your RESUME, cover letter, etc.
Ramboll in the Americas
Founded in Denmark, Ramboll is a foundation-owned people company. Ramboll has thousands of experts working across more than 70 offices in the Americas, delivering innovative solutions within Environment & Health, Water, Energy, and Planning & Urban Design. We invite you to contribute to a sustainable future working in an open, collaborative, and empowering company. Combining local experience with global knowledge, we together shape the societies of tomorrow.
An equal opportunity employer
Equality, diversity, and inclusion is 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 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. Please reach out to our recruitment team to discuss any adjustments that you might require during the application process.