Looker Engineer / BI Engineer

Astrafy SA; Genf; On-site; CHF 90,000 - 150,000; Full time

Job summary

Astrafy SA is seeking a data analytics professional to drive customer data initiatives across business and technical domains in Genf, Switzerland. You will design Looker dashboards, model data in BigQuery and dbt, and publish scalable analytics that empower stakeholders.

The role emphasizes collaboration with a dynamic team and climate for innovation. You will contribute to building modern data platforms, share insights, and publish articles to advance Astrafy’s data capabilities and industry

Qualifications

• Experience with enterprise-grade BI tools (Looker, Data Studio).
• Advanced knowledge of SQL.
• Google Cloud knowledge (BigQuery, Cloud Storage, Cloud Function ...).
• Good understanding of dbt.
• Good understanding of end-to-end pipeline design and implementation (ETL).
• Experience with dbt and Git.
• Strong data visualization skills to convey information and results clearly.
• Attention to detail and quality with excellent problem-solving.
• Analytics and solution-oriented mindset.
• Team player and independent work style.
• Excellent communication and collaboration skills (with colleagues and external stakeholders).
• Fluent English and French.

Responsibilities

• Collaborate with stakeholders to understand business needs.
• Define visualizations and the dashboard structure in Looker.
• Build or refine the data model to support Looker’s data exploration (BigQuery and dbt).
• Develop LookML models for transforming and structuring data.
• Ensure flexibility for users to explore custom reports.
• Focus on usability and clear data presentation.
• Leverage AI-driven solutions to enhance user experience.
• Contribute to knowledge sharing and community engagement.

Skills

SQL

Looker

Data Studio

BigQuery

Google Cloud

dbt

Git

Data viz

Teamwork

Communication

English

French

Tools

Looker

Data Studio

BigQuery

Cloud Storage

Cloud Function

dbt

Git

Job description

Your mission

You will work on different projects to help Astrafy customers get the most out of their data. You will work on the business and technical sides of the customer use case.

On the business side:

• Collaborate with stakeholders to understand the business needs.
• Challenge and refine the requirements to ensure alignment with business objectives.
• Perform a thorough analysis of the client's database to assess the available data.
• Conduct workshops with stakeholders to validate KPIs.
• Define visualizations and the overall dashboard structure in Looker (using Miro or Figma)

On the technical side:

• Build or refine the data model to support Looker’s data exploration (using BigQuery and dbt).
• Develop LookML models for transforming and structuring data.
• Ensure flexibility for users to explore custom reports.
• Focus on usability and clear data presentation.
• Leverage AI-driven solutions to enhance user experience

In addition to these core responsibilities, we strongly value knowledge-sharing and community engagement. At Astrafy, we are active contributors on platforms like Medium, where we regularly publish articles to share our expertise, insights, and innovations, helping to grow both our community and industry presence.

As part of the role, the candidate will also be encouraged to write articles, offering valuable insights and thought leadership to enhance Astrafy's impact further and foster greater collaboration within our field.

Your profile

• Experience with enterprise-grade BI tools is required (Looker, Data Studio)
• Advanced knowledge of SQL is required
• Google Cloud knowledge (BigQuery, Cloud Storage, Cloud Function ...) is required
• Good understanding of dbt
• Good understanding of end-to-end pipeline design and implementation (ETL)
• Experience with dbt and Git is required
• Strong data visualization skills to convey information and results clearly
• Attention to detail and quality with excellent problem-solving
• You have an analytics and solution-oriented mindset
• You work well in a team as well as independently
• Excellent communication and collaboration skills (both with your colleagues as well as with external stakeholders)
• You speak English and French fluently

This role is not just a job; it's an opportunity to be at the forefront of the data revolution, helping companies unlock the potential of modern data technologies. If you are passionate about data analytics, thrive in dynamic environments, and are eager to make a significant impact, we would love to hear from you.

Was this list a bit much? Don't worry - we don't expect you to tick every box from the beginning.

Why us?

• An attractive salary package, with no blurry or hidden clauses. Everything we offer is open-source via our Gitbook. Check it out here (https://astrafy.gitbook.io/handbook/its-all-about-people/compensation).
• An exciting job where technology innovation is not a buzzword but a reality.
• Be part of a dynamic team that shares strong values. Check out our “Culture and Values” chart here (https://docs.astrafy.io/handbook/the-company/culture-and-values).
• Continuous training & development of soft and hard skills. Check out our training policy here (https://docs.astrafy.io/handbook/its-all-about-people/training).
• Flexible working hours and remote policies. Check it out here (https://docs.astrafy.io/handbook/the-company/remote-work).
• An excellent team of colleagues & regular team-building activities. Check it out here (https://docs.astrafy.io/handbook/its-all-about-people/team-building-and-retreat).

And much more. We have compiled a detailed handbook covering all you need to know about our company. Check it out here (https://docs.astrafy.io/handbook/).