Junior Analytics & Insights Engineer; Internship

Your mission

As an Intern in the Analytics & Insights Engineering team, you will primarily work on internal technical projects that strengthen Astrafy’s data stack and ways of working. Under the guidance of consultants and your entity manager, you will contribute to both the business and technical sides of these use cases, while investing heavily in learning and developing your skills. Depending on your progress and project needs, you may also have the opportunity to contribute to selected customer engagements under the supervision of experienced consultants.

You will also have the opportunity to use the latest AI technologies to support your day-to-day work on internal technical topics and accelerate how you learn, build, and deliver.

On the business side:

• Collaborate with internal stakeholders (consultants, Team Leads, product owners) to understand internal needs and priorities for our data and analytics stack.
• Help refine and clarify requirements for internal tools, dashboards, and processes to ensure they align with Astrafy’s business objectives.
• Assist in analyzing internal datasets (for example operational, financial, or product-related data) to identify opportunities for better reporting and decision-making.
• Support internal workshops or working sessions to define and validate key metrics (KPIs) used across teams.
• Contribute to the definition of visualizations and internal dashboards that make data easy to understand and use.
• Depending on your progress and the projects in flight, you may also be involved in specific, well-scoped client-related tasks, mainly as support to a consultant.

On the technical side:

• Contribute to building and improving internal data models in Big Query and dbt that support Astrafy’s own reporting and analytics needs.
• Help develop and maintain LookML models and internal dashboards used by the Astrafy team.
• Implement and test simple business rules and data transformations to ensure internal data is consistent, reliable, and well documented.
• Support the creation of internal reports and monitoring dashboards with a strong focus on usability and clear data presentation.
• Explore and, where relevant, leverage AI-driven solutions to improve internal workflows and user experience.
• Depending on your progress and the projects in flight, you may also be involved in specific, well-scoped tasks on client projects, always under the guidance of a senior consultant.

In addition to these 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.

As part of the role, you will be encouraged to contribute to articles and internal documentation, sharing what you learn and helping to grow Astrafy’s impact and knowledge base.

Learn fast, deliver small but reliable pieces of work, and progressively gain autonomy with the support of the team. Your success is measured by your ability to learn, collaborate, and ship incremental value with quality and consistency.

• Basic experience with enterprise-grade BI or analytics tools is a strong plus (Looker, Data Studio, or similar).
• Solid understanding of SQL fundamentals; you can write simple queries and are eager to improve.
• Initial exposure to Google Cloud (Big Query, Cloud Storage, Cloud Functions, etc.) is appreciated.
• Basic understanding of dbt and end-to-end data pipeline concepts (ETL/ELT).
• Familiarity with Git and collaborative development workflows is a plus.
• Strong interest in data visualization and the ability to build basic, clear reports with guidance.
• Attention to detail and quality, with a structured and solution-oriented mindset.
• Strong willingness to learn, take…