Astrafy

Role Description 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. Qualifications - 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. Benefits - Be part of a dynamic team that shares strong values. - Continuous training and development of both soft and hard skills. - Flexible working hours and remote policies. - An excellent team of colleagues and regular team-building activities. - And much more. We have compiled a detailed handbook covering all you need to know about our company. Company Description 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.

• Lead the legal, operational, and commercial establishment of Astrafy in Mexico. • Identify, engage, and close early customers in Mexico and the broader Americas region. • Handle everything from strategy and sales to day-to-day administrative hurdles. • Act as the face of Astrafy in the region, building relationships with local tech communities, partners, and the Google Cloud ecosystem. • Help attract, hire, and onboard the next wave of local talent as the entity grows.

• Work on various projects to help customers get the most out of their data • Design and maintain scalable data pipelines leveraging technologies such as Airflow, dbt, BigQuery, Pubsub, and Snowflake • Develop and optimize data infrastructure in the Google Cloud environment • Use Terraform to automate infrastructure provisioning and manage containerized workloads • Implement data governance, security, and quality measures • Collaborate with cross-functional teams to design and deploy BI dashboards • Continuously refine data architecture to accommodate changing business needs • Champion a culture of innovation by researching, evaluating, and recommending emerging data technologies

• Define Company-Wide Strategy: Shape a scalable people strategy aligned with Astrafy’s core values. • Employer Brand & Value Proposition: Define and communicate our value proposition to attract top-tier data and AI consulting talent. • AI-Enhanced Sourcing: Proactively identify new sourcing channels. • Full-Cycle Recruitment & Ownership: Take full accountability for the employee lifecycle, from identifying initial team needs with managers to executing a seamless onboarding experience. • Cultivate "Solution-Seekers": Foster a culture where team members take extreme ownership. • Drive clear, concise, and constructive communication channels across the company. • Establish a highly rational, transparent, and data-driven compensation framework.

• Engage with stakeholders to understand their needs, discover opportunities, map vision & business requirements, and translate them into effective cloud-based solutions and services. • Identify opportunities for automation and drive continuous improvement in the deployment process. • Design and implement automation frameworks and deployment pipelines using cutting-edge tools and technologies. • Continuously evaluate and enhance deployment practices to drive efficiency and reliability. • Be autonomous and proactive; understand functional and technical requirements, identify gaps, and suggest improvements. • Promote an automate everything approach and apply DevOps best practices to ensure consistent and transparent execution. • Contribute to the development and creation of automated services. • Keeping up to date with emerging technologies, industry trends, and best practices related to deployment services and DevOps. • Travel from time to time to work on-site with the client in Switzerland (Geneva).

• Trabajarás en distintos proyectos para ayudar a los clientes de Astrafy a sacar el máximo partido de sus datos. • Colaborarás tanto en el plano de negocio como en el técnico del caso de uso del cliente. • Diseñar y mantener pipelines de datos escalables aprovechando tecnologías como Airflow, dbt, BigQuery, Pub/Sub y Snowflake, garantizando una ingesta, transformación y entrega de datos eficientes y fiables. • Desarrollar y optimizar la infraestructura de datos en Google Cloud, aplicando buenas prácticas de rendimiento, coste y seguridad. • Usar Terraform para automatizar el aprovisionamiento de infraestructura y gestionar cargas de trabajo contenizadas, fomentando la agilidad y la repetibilidad entre entornos. • Implantar medidas sólidas de gobernanza, seguridad y calidad de los datos, asegurando exactitud, consistencia y cumplimiento a lo largo de todo el ciclo de vida del dato. • Colaborar con equipos multidisciplinares para diseñar y desplegar paneles de BI y otras soluciones analíticas que ofrezcan a los stakeholders información accionable. • Refinar continuamente la arquitectura de datos para adaptarla a las necesidades cambiantes del negocio, escalando las soluciones para gestionar un mayor volumen y complejidad de datos. • Promover una cultura de innovación investigando, evaluando y recomendando tecnologías de datos emergentes y mejores prácticas del sector.

• Collaborate with stakeholders to understand business needs. • Challenge and refine the requirements to ensure alignment with business objectives. • Perform 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). • 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. • Write articles for platforms like Medium to share expertise, insights, and innovations.