Data analyst en finanzas y ventas

Capitole; Barcelona; On-site; EUR 35,000 - 50,000; Full time

Benefits offered by this job

€1,200/year for professional dev

Private health insurance

Wellhub subscription

Capitole Club discounts

Team-building events every 2 months

Sports clubs & communities

Job summary

Capitole ищет Data Analyst с опытом 4+ лет для поддержки аналитики продаж и финансов. Ваша роль — преобразовывать данные в практические рекомендации, работать с прогнозами, KPI и отчетами, используя Power BI/Tableau и Excel.

Необходимо умение общаться с техническими и нетехническими аудиториями и собирать требования у заинтересованных сторон. Здесь вас ждут увлекательные задачи и коллаборация в быстрорастущей команде на базе Барселоны.

Qualifications

• Аналитический профиль с опытом финансовой или продажной аналитики.
• Умение собирать требования, взаимодействовать с заинтересованными сторонами и презентовать результаты.
• SQL: сложные запросы и оптимизация; ETL и моделирование данных.
• Визуализация и отчетность в BI-инструментах и Excel.

Responsibilities

• Преобразование данных в практические рекомендации по финансовым или продажным отчетам.
• Подготовка и оценка прогнозов, отслеживание KPI.
• Визуализация данных и создание отчетов в BI-платформах и Excel.
• Сбор требований и взаимодействие с заинтересованными сторонами.
• Коммуникация результатов как технической, так и нетехнической аудитории.
• Проведение сравнительного анализа эффективности стратегий продаж.

Skills

SQL

ETL

Data modeling

Forecasting

Stakeholder comms

Data analysis

Python/Pandas

Tools

Power BI

Tableau

Git

Job description

Описание

Capitole continues to grow—and we want you to be part of the journey! We are looking for a Data Analyst with 4+ years of experience to join our amazing team.

Задачи

• Transform data into actionable recommendations based on financial or sales reporting and analytics
• Prepare and evaluate forecasts, and track and communicate KPIs
• Visualize data and create reports using BI tools and advanced Excel
• Gather requirements and liaise with stakeholders
• Communicate results to both technical and non-technical audiences
• Carry out comparative analyses to identify which sales strategies or commercial actions work best and why (impact analysis, A/B comparisons, before/after, etc.)

Требования

• Analytical profile with experience in financial or sales reporting and analytics (Data Analyst / Business Analyst / FP&A / Analytics)
• Good knowledge of SQL and understanding of ETL processes and data modeling
• Experience gathering requirements, liaising with stakeholders, and communicating results
• SQL (complex queries and optimization)
• Data visualization and reporting using BI tools (Power BI, Tableau, etc.) and advanced Excel
• Experience preparing and evaluating forecasts, and tracking and communicating KPIs
• Curiosity and initiative: questioning data, identifying patterns, and proposing analyses independently
• Ability to transform data into actionable recommendations
• Good communication skills with both technical and non-technical audiences
• Будет плюсом: Python (Pandas) for data analysis and automation; Experience in statistics and Data Science; Version control with Git; Knowledge of cloud; Knowledge of the airline industry; Experience in Controlling, Finance, Commercial, or Sales, where data analysis has a direct impact on decision-making; Ability to carry out comparative analyses (impact analysis, A/B comparisons, before/after, etc.)

Условия

• €1,200/year for your professional development (training, events, certifications...)
• Monthly feedback sessions with your team to keep learning and growing
• Private health insurance fully covered by Capitole Payflow benefits (food, transport, childcare)
• Wellhub subscription
• Discounts with major brands through Capitole Club
• Team-building events every two months (our summer party and Christmas dinner are legendary!)
• A football, padel, and basketball team sponsored by Capitole Tech communities where sharing knowledge is part of our DNA
• And above all... an AMAZING TEAM you will love being part of!