Senior Analytics Engineer

About the role

Model clean, well-documented datasets in dbt and translate complex business processes into standardized definitions and a semantic layer used across Tableau and Power BI. You'll diagnose data quality issues, optimize query performance, and partner with BI and business teams to design certified datasets and dashboards.

What you'll do

• Model clean, well-documented datasets in dbt (staging → marts), including tests, ownership, and clear metric definitions.
• Translate complex business processes into standardized definitions and a semantic layer used across Tableau and Power BI.
• Diagnose messy or ambiguous source data, reconcile inconsistencies, and align stakeholders on a single source of truth.
• Optimize Snowflake query performance, data freshness, and quality through testing and monitoring.
• Partner with BI and business teams to design certified datasets, dashboards, and self-service standards.
• Develop reporting end-to-end — from understanding business needs to delivering actionable, intuitive data products.
• Maintain and evolve central data pipelines, dbt models, and Tableau integrations within a modern stack (Python, AWS/Azure/GCP, Git).
• Act as a technical mentor for the team, helping others adopt best practices in analytics engineering.

What you'll need

• 3+ years of experience as an Analytics Engineer, BI Developer, or Data Engineer.
• Proven record of turning complex, large-scale data into actionable insights and governed metrics used across BI.
• Expert in SQL and data modeling (star schemas, dimensions/facts, semantic layer design).
• Hands-on experience building production-grade dbt projects with testing, documentation, and version control workflows.
• Strong proficiency in Python for analytics tasks (data checks, automation, utilities).
• Strong stakeholder management and communication skills — able to translate business logic into durable, scalable data models.
• Familiarity with ELT concepts, CI/CD for analytics code, data cataloging, and basic cost/performance tuning.

What they offer

• Work at Germany's first green unicorn and play an active role in shaping the solar energy transition.
• Hybrid working concept with Workflex option to relocate abroad for up to 30 days a year.
• Modern office in Berlin-Friedrichshain with height-adjustable desks, table tennis, and barista coffee.
• Onboarding with buddy program and supportive team.
• 29 + 2 vacation days, discounted Wellhub membership, and corporate benefits.
• Transparent culture with short decision-making processes and legendary team events.