We're seeking a Senior Data Analyst in Business Intelligence (BI) who will collaborate closely with Ecosia’s Executive, Product, Marketing, and Operations teams to provide valuable insights on performance and opportunities.

Your skills in data management and problem-solving will enable you to translate raw data into actionable insights that empower data-informed decisions and contribute to our overall mission to solve the climate crisis. You will serve as a key resource for data analysis at Ecosia, focusing on the accurate delivery of data and quality analysis that aligns with business goals.

What you’ll be doing:

• Empower our marketing, product, and operations teams by translating raw data into clear insights and impactful recommendations to inform decision making.

• Partner with teams to build and refine business cases and testing plans for major new initiatives and features.

• Develop efficient data models using dbt and integrate new data sources, optimising the ETL pipeline and ensuring that our data structure supports stakeholder needs.

• Utilise data from our data collection platform (Snowplow) to generate insights while respecting our privacy-friendly philosophy.

• Write optimised SQL queries and perform advanced data analytics to support reporting, automation, AB testing, and performance tracking.

• Design, develop, and maintain dashboards and reports using Looker to support self-service data-driven decisions.

• Ensure the delivery of accurate, reliable, and consistent data through robust data validation and cleaning processes.

• Engage effectively with cross-functional teams and C-level to communicate insights and embed a data-oriented mindset.

• Ultimately, use data to support growth, provide value to the user, and support our mission to solve the climate crisis.

What you’ll bring:

• You have 5+ years of experience with managing data, and you know about extracting data from different data sources into a data warehouse or a data lake.

• You have good business understanding and have used data to support and guide strategic decisions.

• You are capable of writing complex SQL statements.

• You are a great communicator and can translate complex data into actionable insights and business impact for executive and non-technical stakeholders.

• Well-versed in analytical techniques such as churn modeling, regression, AB testing.

• You have practical knowledge and skills in analytics and data visualization tools (e.g., Looker).

• Understanding of modern data architecture and familiarity with data ingestion, storage, and transformation processes to convert raw data into insight-ready formats.

• Skilled in designing data workflows and automating processes to ensure high-quality data and accessibility across the organisation.

• You are a creative problem solver, able to think innovatively while wrangling data from multiple sources.

• You are curious and quickly learn new domains.

• You are fluent in English.

• Respect for privacy and awareness of relevant legislation in the EU, UK, and US.

Nice to have:

• Python and advanced statistical methods

• Experience with our data tech stack: 

  • Analysis, Visualization & Storytelling: Looker, Redash, Jupyter Notebooks

  • Data Modeling: dbt

  • Data Warehouse/Lake: AWS Redshift, Spectrum, S3, Athena, Glue

  • ETL: Airflow (Python), Airbyte, Spark

  • Tracking: Snowplow (JavaScript)

• Experience with Github

• Experience in a B2C tech company in search and digital advertising with a focus on frontend tracking analytics

We recognize that you may need further development in some areas, and we encourage you to apply even if your profile does not meet all of the requirements for the role: we encourage and support growth and development for everyone.

Hiring Process:

1. First call with our recruiter (30min)

2. Technical interview with the team (45-60min)

3. Case Study (1h prep, 1h presentation/discussion)

4. Final interview, Product/Culture (45min)

Why Ecosia?

• What if your job made a real difference in the climate crisis? Join Ecosia and help plant millions of trees where people and ecosystems need them most.

• We are a diverse team, committed to equality, equity, and inclusion, with members of various backgrounds: sexual orientations, genders, ages, races, ethnicities, nationalities, physical and mental disabilities, family structures, and religions.

• We offer you the opportunity to balance work with other parts of your life. (flexible working hours, 30 vacation days/year on a five-day week, designated Focus Times, remote work options) (not applicable to freelance contracts + different labor laws apply in other countries).

• Moving to Berlin for the first time? We welcome everyone and offer relocation support and visa/work permit assistance to new employees and their loved ones coming from abroad and within Germany (applicable for unlimited contracts).

• Our green benefits program, including subsidized public transport cards and bike inspection services, supports your sustainable living choices, varying by location (not applicable to freelance contracts).

• We support your professional growth through learning times, hack days, online and physical libraries, continuous feedback, etc. (not applicable to freelance contracts).

Q&A

How many people work at Ecosia?

114 (March 2025) - our departments include Engineering (incl. Platform), Product (incl. Design), Marketing, Trees, Operations (incl. B2B & BI), and People and Culture.

Where is Ecosia based and what kind of a work set-up do we have?

We are a remote-friendly company with one office in Berlin-Wedding. People come to the office or work from home per their wishes and/or circumstances. Some roles require presence in the office at least from time to time. The Talent Partner will tell you more.