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.

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:

• Experience in Analytics and BI platforms, such as Qlik Sense and Power BI
• Experience developing in Python
• Experience in data analysis and exploration
• Understanding of relational databases
• Ability to work on multiple deliverables at the same time, while maintaining organization and efficiency
• Demonstrate excellent communication skills and ability to interact with and present to others
• Travel 5-10%
• Ability to obtain Department of Defense Common Access Card (CAC Card)
• A Federal Bureau of Investigation (FBI) fingerprint check
• A National Agency Check with Written Inquiries (NACI) check
• Individuals who are non-U.S. nationals must have lived in the United States or U.S. territory for 3 years or more

Your new team

As the Lead Consultant, Data Analytics, 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 Analyst will be able to work independently, thrive in a team-environment, and be a technical GIS resource for project managers and staff. Data management, presentation development, data analysis, and spatial calculations 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 GIS applications, 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
• Familiarity with developing and deploying ArcGIS Experience Builder web apps
• JavaScript development
• Experience web scraping using the Selenium testing framework
• Experience developing Extract/Transform/Load (ETL) pipelines
• Experience with geospatial tools such as ESRI ArcGIS
• Familiarity with project management platforms
• Previous experience with the US Army Corps of Engineers

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 combinatio