Mid Data Analyst (PySpark)

act digital; Lisboa; On-site; EUR 30,000 - 45,000; Full time

Job summary

A leading digital consultancy in Lisbon is seeking a Data Analyst to collect and analyze data for actionable business insights. This role involves creating data pipelines using Airflow and optimizing code and queries. The successful candidate will collaborate with teams to deliver reliable data and identify opportunities for user experience improvements. Strong SQL skills and fluent English are mandatory. Join a dynamic team and contribute to impactful business decisions.

Qualifications

• Fluent in English is mandatory.
• Experience with Apache Airflow is desirable.
• Strong analytical abilities are required.

Responsibilities

• Responsible for creating data pipelines in Airflow.
• Generate insights and identify trends.
• Deliver data in useful and appealing ways to users.

Skills

SQL skills and relational database management

Fluent in English

Strong analytical abilities

Adaptability skills

Apache Airflow

Experience in creating APIs in Python

Agile methodologies (At least SCRUM)

Git

Experience with Data Warehouses

Job description

Overview

The Data Analyst is responsible for collecting, cleaning, analyzing, and interpreting data to provide actionable insights for business decisions. The role involves creating and managing data pipelines using Airflow for data extraction, processing, and loading, ensuring their maintenance, monitoring, and stability. The analyst will work closely with end-users and other teams to provide accessible and reliable data.

Core Technical Skills

• SQL skills and relational database management (Oracle is Mandatory)
• Git - (is a plus)
• Experience with Data Warehouses (is a plus)
• Experience in creating APIs in Python is a plus
• Apache Airflow - Experience in pipeline development is desirable
• Agile methodologies (At least SCRUM)
• Fluent in English (Mandatory)
• Strong analytical abilities, able to have the right synthesis and all possible details at same time
• Adaptability skills

Main Activities

• Responsible for creating data pipelines in Airflow for data extracting, processing, and loading
• Responsible for code and query optimization
• Responsible for generating insights and identify trends, anomalies or opportunities to improve users experience and anticipate their daily tasks
• Responsible for delivering data in useful and appealing ways to users
• Responsible for understanding business change and requirement needs, assess the impact and the cost.