Junior Analytics & Insights Engineer (Internship)

Astrafy; Madrid; Presencial; EUR 6696 - 13.392; Jornada completa

Descripción de la vacante

Astrafy is looking for an Analytics & Insights Intern to help strengthen our data stack. You will work on internal projects, learn to build dashboards, models in BigQuery/dbt, and contribute to LookML and internal reporting.

You will collaborate with consultants, team leads, and stakeholders, while growing your analytics skills and business understanding. You will gain exposure to AI-enabled workflows, assist with internal documentation, and progressively take on independent tasks under

Formación

• Basic experience with enterprise-grade BI/analytics tools (Looker, Data Studio) is a strong plus.
• Solid SQL fundamentals; able to write simple queries and improve.
• Initial exposure to Google Cloud (BigQuery, Cloud Storage, Cloud Functions) is appreciated.
• Basic understanding of dbt and end-to-end data pipelines (ETL/ELT).
• Familiarity with Git and collaborative development workflows is a plus.
• Strong interest in data visualization and ability to build clear reports with guidance.
• Attention to detail and a structured, solution-oriented mindset.
• Willingness to learn, take feedback, and improve continuously.
• Fluency in Spanish and English; French is a plus.

Responsabilidades

• Collaborate with internal stakeholders to understand data needs and priorities.
• Help refine requirements for internal tools, dashboards, and processes.
• Analyze internal datasets to identify opportunities for reporting and decision making.
• Support workshops to define KPIs and measure success.
• Define visualizations and internal dashboards for data clarity.
• Assist on client tasks under guidance of a senior consultant.

Conocimientos

SQL fundamentals

Fluent Spanish & English

Communication skills

Team collaboration

Willingness to learn

Attention to detail

Herramientas

Looker/Data Studio

BigQuery

dbt

Cloud Storage/Functions

Git

Descripción del empleo

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 BigQuery 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.

Your profile

• 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 (BigQuery, 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 feedback, and continuously improve.
• Curiosity about both the business context and the technical stack.
• Reliability in executing tasks agreed with your mentor or consultant and communicating clearly about progress and blockers.
• Team mindset: ready to help with supporting tasks such as testing, documentation, and small fixes.
• You work well in a team and can progressively handle tasks independently as you gain experience.
• Excellent communication and collaboration skills (with colleagues and, when relevant, with external stakeholders).
• You speak Spanish and English fluently. Speaking French is a significant plus and will help you stand out from other applicants.

This role is not just an internship; it is an opportunity to be at the forefront of the data revolution, learning how to help companies unlock the potential of modern data technologies. If you are passionate about data analytics, eager to learn, and motivated to make an impact in a supportive environment, 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?

• Be part of a dynamic team that shares strong values. Check out our Culture and Values here: https://docs.astrafy.io/handbook/the-company/culture-and-values
• Continuous training and development of both soft and hard skills. Our training policy is available here: https://docs.astrafy.io/handbook/its-all-about-people/training
• Flexible working hours and remote policies. Learn more here: https://docs.astrafy.io/handbook/the-company/remote-work
• An excellent team of colleagues and regular team-building activities. Discover more 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/