Identify and document, together with Operations teams, the main processes, systems and data sources (internal and external);
Model tables and data layers (staging, core, mart) aligned with the CoE standards;
Develop and maintain ingestion, transformation and load processes using Python, SQL and GCP (e.g., BigQuery, Cloud Storage);
Orchestrate pipelines with Airflow, ensuring reliability, reprocessing and monitoring;
Automate system integrations between Operations platforms and the data warehouse/data lake;
Create and evolve management and operational dashboards in Power BI, focusing on performance, efficiency, cost, quality and SLA metrics;
Ensure consistency of KPI definitions in collaboration with Operations managers and the Data CoE;
Implement data quality rules, monitoring completeness, consistency and timeliness of loads;
Document data sources, data dictionary, indicator calculation logic and integration flows;
Support the standardization of metrics and the use of data according to CoE guidelines;
Act as a business partner, understanding Operations pain points and opportunities and translating them into data solutions;
Perform exploratory and ad-hoc analyses in Python/SQL to answer business questions and validate hypotheses;
Train key users (Operations managers and analysts) on the use of dashboards and metrics;
Work in alignment with architects, engineers and data scientists from the CoE;
Ensure solutions comply with corporate architecture, security and data governance standards;
Contribute best practices, component reuse and the evolution of the data platform.
Requirements
Bachelor's degree (completed);
Advanced SQL and Python experience for ETL/ELT and automations;
Experience with GCP (BigQuery, Cloud Storage, Airflow/Composer);
Experience in data modeling and pipeline orchestration;
Experience with Power BI (Power Query, DAX, dashboards and RLS);
Clear communication between business and technology;
Hands-on, analytical and delivery-oriented profile;
Organized, documentation-focused and collaborative work style;
Proactive in proposing improvements and data solutions;
Experience with large volumes of data and multiple sources is desirable;
Good data engineering practices;
Experience with AI/LLMs applied to data;
Desirable knowledge of statistics and a data-driven mindset;
Experience working close to operational areas is a plus.
Tech Stack
Airflow
BigQuery
Cloud
ETL
Google Cloud Platform
Python
SQL
Benefits
High-quality health coverage with Omint: access to a top-tier national medical and dental network through Omint;
Alelo Pod card for flexible spending on meal and food allowances, accepted at major restaurant and supermarket chains;
Flexible and sustainable working hours;
Mobility options: choose the modality that makes sense for you—commuter voucher, fuel allowance or parking;
Total Pass: an online platform dedicated to promoting quality of life, health and well-being, offering access to gyms, studios and online services with exclusive Matrix discounts, covering you and up to 3 dependents;
Group life insurance;
Profit Sharing (PLR), subject to goals and performance;
Work with a fantastic team in a collaborative environment that aims to build a brighter, more sustainable future.