Astrafy

Junior Analytics & Insights Engineer (Internship)

Astrafy · Madrid, Community of Madrid, Spain

IT Services and IT Consulting · 11-50 employees

1 h ago
Remote Junior (0-2 yrs) Internship Spain
Log in to apply, save this posting, or score it against your profile with AI.

About the role

The intern will build and improve internal data models and dashboards using BigQuery, dbt, and Looker to support Astrafy's reporting needs. They will also collaborate with stakeholders to refine requirements for internal tools and may support selected client engagements.

What they look for

SQL BigQuery dbt Looker Google Cloud Platform Data Visualization LookML Git ETL/ELT Data Modeling English Spanish

Requirements

Candidates should have a solid understanding of SQL fundamentals and basic experience with BI tools or Google Cloud Platform. Fluency in English and Spanish is required, with a strong willingness to learn and a solution-oriented mindset.

Benefits

Continuous Training And Development Flexible Working Hours Remote Policies Team-building Activities

Full description

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/

About us

At Astrafy, we are on a mission to empower every individual with a truthful vision of reality. By acting as a seamless extension of our clients' Data & AI departments, we engineer the robust foundations required to strip away bias and replace guesswork with certainty. 

We prioritize true craftsmanship over generic consulting, bringing strict software engineering rigor to the rapidly evolving data and Generative AI landscape. 

Ultimately, we don't just build technology — we democratize insights, enabling organizations to make confident, fact-driven decisions that unlock their highest potential.