Expect a mix of behavioral questions focused on your work ethic and technical questions focused on your analytical process. The goal is to see how you handle the realities of data work in a professional services firm.

Technical and Analytical Process

These questions test your methodology and your ability to ensure data quality.

• "Describe your process for cleaning a large, messy dataset."
• "What tools do you prefer for data visualization and why?"
• "How do you ensure accuracy when working with multiple data sources?"
• "Tell me about a complex analytical problem you solved recently."

Behavioral and Soft Skills

ERM values commitment and the ability to work within a team structure.

• "Tell me about a time you had to meet a tight deadline with a large volume of data."
• "How do you prioritize your tasks when supporting multiple project managers?"
• "Describe a time you had to explain a technical concept to a non-technical colleague."
• "What interests you most about working in the environmental and sustainability sector?"

Domain and Case-Based Questions

These questions assess your ability to apply your skills to ERM's specific business.

• "How would you track and report on carbon emissions for a global client?"
• "What metrics would you prioritize for a biological field survey report?"
• "If a client provides incomplete data, how do you proceed with your analysis?"

Domain Knowledge and Logic

Whether you are a Biologist - Desktop Analyst or a General Data Analyst, you need to understand the "why" behind the data. This involves logical reasoning and a basic grasp of the environmental or industrial contexts ERM operates in.

Be ready to go over:

• Environmental Context – Familiarity with sustainability metrics or biological survey methods.
• Logical Reasoning – Approaching a problem when you have incomplete information.
• Project Lifecycle – Understanding how data analysis fits into a larger consulting engagement.

Advanced concepts (less common):

• Spatial analysis and GIS integration.
• Predictive modeling for environmental impact.
• Regulatory reporting frameworks (e.g., ESG reporting standards).

Key Responsibilities

A Data Analyst at ERM handles a diverse range of responsibilities that bridge the gap between field data and client deliverables. Your day-to-day will involve collecting, analyzing, and interpreting data from various sources to support environmental and sustainability projects. You will often act as a "Desktop Analyst," meaning you provide the analytical backbone for teams who may be out in the field.

Collaboration is a core part of the role. You will work closely with ERM consultants and project managers to understand client requirements and ensure that the data analysis aligns with project goals. This might involve creating automated reporting templates, maintaining internal databases, or performing quality control on large-scale environmental assessments.

Typical projects include biological monitoring reports, EHS (Environment, Health, and Safety) compliance tracking, and sustainability performance dashboards. You are responsible for ensuring that the data presented to clients is accurate, visually compelling, and legally defensible.

Role Requirements & Qualifications

To be competitive for a Data Analyst position at ERM, you need a blend of analytical rigor and communication skills. The firm values candidates who can demonstrate a track record of reliability and technical competence.

• Technical Skills – Strong proficiency in Microsoft Excel is mandatory. Experience with SQL, Python, or R is highly preferred for more technical tracks. Familiarity with visualization tools like Power BI or Tableau is a significant advantage.
• Experience Level – Entry-level roles often require a degree in a relevant field (Science, Math, Data Science, or Environmental Studies). Mid-level roles typically look for 2–5 years of experience in an analytical or consulting environment.
• Soft Skills – Excellent written and verbal communication skills are non-negotiable. You must be able to work independently, manage your time across multiple projects, and maintain a high level of attention to detail under deadlines.

Must-have skills:

• Advanced Data Manipulation (Excel/SQL).
• Technical Writing and Reporting.
• Analytical Problem-Solving.

Nice-to-have skills:

• GIS (Geographic Information Systems) experience.
• Knowledge of environmental regulations or ESG frameworks.
• Experience in a consulting or client-facing role.

Frequently Asked Questions

Q: How long does the interview process typically take at ERM? The process can be quite variable. Some candidates receive an offer within a few weeks, while others report a "moroso" (slow) process that can take several months. It is important to stay in touch with your recruiter and manage your expectations regarding the timeline.

Q: Is there a technical test for the Data Analyst role? Yes, most candidates undergo some form of assessment. This often includes a writing test (redação) to evaluate your reporting skills and a technical evaluation of your Excel or data manipulation abilities.

Q: What is the culture like for analysts at ERM? ERM has a professional, science-driven culture. Analysts are expected to be self-starters who are comfortable working in a collaborative, global environment. There is a strong emphasis on quality and scientific integrity.

Q: Does ERM offer remote work for Data Analysts? Many Data Analyst roles at ERM are hybrid or remote-friendly, especially "Desktop Analyst" positions. However, this depends on the specific team and the requirements of the projects you are supporting.

Other General Tips

• Highlight Your Writing: Since ERM is a consultancy, your ability to draft reports is just as important as your ability to run queries. Mention any experience you have with technical documentation or client reporting.
• Be Patient but Proactive: Some candidates have noted a lack of feedback during the process. If you haven't heard back within two weeks of an interview, a polite follow-up with the recruiter is appropriate.
• Understand the Mission: ERM is deeply committed to sustainability. Research their recent "Sustainability Report" and be prepared to discuss how your data skills can help them achieve their environmental goals.