Data Analyst

Hexa Consulting; Lisboa; Híbrido; EUR 45 000 - 60 000; Tempo integral

Resumo da oferta

A data solutions provider in Lisbon is seeking a Data Analyst to transform data into actionable insights. This role involves designing and maintaining data pipelines using Apache Airflow, analyzing complex datasets, and delivering visualizations. The ideal candidate will have proficiency in Python and strong SQL skills, with a minimum English level of B2. This position follows a hybrid work model, requiring two days onsite in Lisbon. Competitive compensation is offered.

Qualificações

• Proficiency in Python, with API development experience preferred.
• Strong knowledge of PySpark for distributed data processing.
• Advanced SQL skills with experience in Oracle Database.

Responsabilidades

• Design and maintain data pipelines in Apache Airflow.
• Optimize code and SQL queries for performance.
• Analyze datasets to identify trends and opportunities.
• Deliver data insights and visualizations.
• Collaborate with stakeholders to understand requirements.
• Ensure data accuracy and quality across processes.

Conhecimentos

Python

PySpark

SQL

Oracle Database

Apache Airflow

Git

Agile environments

Descrição da oferta de emprego

We are looking for a Data Analyst to join our team and play a key role in transforming data into actionable insights that drive strategic business decisions.

The ideal candidate will be responsible for collecting, cleaning, analyzing, and interpreting data, as well as designing and maintaining data pipelines using Apache Airflow for extraction, processing, and loading (ETL).

This role requires a mix of technical expertise, analytical thinking, and business acumen to ensure that data is accurate, accessible, and valuable for decision-making.

The analyst will collaborate closely with end-users and cross-functional teams to deliver reliable insights and impactful data solutions.

This position follows a hybrid work model, with 2 days per week onsite in Lisbon, and requires a minimum English level of B2.

Main Responsibilities:

• Design, develop, and maintain data pipelines in Apache Airflow for data extraction, processing, and loading.
• Optimize code and SQL queries for performance and scalability.
• Analyze complex datasets to identify trends, anomalies, and opportunities that enhance user experience and anticipate business needs.
• Deliver data insights and visualizations in clear, engaging, and user-friendly formats.
• Collaborate with business stakeholders to understand requirements, assess the impact of proposed changes, and estimate costs.
• Ensure data accuracy, consistency, and quality across all data processes and systems.

Technical Skills:

• Proficiency in Python (experience in developing APIs is a plus).
• Strong knowledge of PySpark for distributed data processing.
• Advanced SQL skills and experience with Oracle Database.
• Hands-on experience with Data Warehouses.
• Solid understanding and practical experience with Apache Airflow (pipeline development and orchestration).
• Familiarity with Git for version control.
• Experience working in Agile environments.

Soft Skills:

• Strong analytical and problem-solving abilities.
• Attention to detail and data quality.
• Effective communication and collaboration with both technical and non-technical stakeholders.
• Proactive and curious mindset, with a drive to continuously improve data processes.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Consulting

Industries

• Software Development