Data Analytics (h/m)

• Person with 3-5 years of experience in similar roles.
• Advanced SQL: windows, CTEs, query optimization in large-scale data warehouse environments.
• dbt: layered modeling, macros, tests, documentation, materializations, incremental models.
• Jinja and YAML as standard working languages within dbt projects.
• BigQuery: table design, cost optimization, partitioning, clustering, and basic permission management.
• Python at a scripting level and data process automation.
• Git: working with branches, pull requests, and CI/CD pipelines. The stack is already in Git with CI/CD - you are expected to use it from day one.
• Basic GCP: IAM, Cloud Storage, Cloud Scheduler, and Cloud Run as a dbt orchestrator.
• Looker or equivalent BI tool: building dashboards and a semantic layer for self-service.
• Star schema / Kimball methodology for dimensional model design.
• Regular use of AI tools (Claude, Gemini, Copilot, or others) as part of the workflow, not just as occasional curiosity.
• Ability to translate business needs into data specifications without intermediaries.
• Self-service mindset: build so that others can use it without constantly asking for help.
• Ability to communicate technical concepts to non-technical profiles in a clear and actionable way.
• Proactive attitude.

• You will be part of a dynamic, growing company in full international expansion.
• You will receive a Welcome Pack and will join through an onboarding process so that you have everything clear from day one.
• They are pioneers in the IoT and Digital Twins sector internationally.
• You will be able to develop personally and professionally
• Family-Responsible Company among which we highlight those focused on work-life balance and flexibility.
• Hybrid modality of remote work and office work to favor work-life balance while also enjoying the company of the team. (3 days remote and 2 in the office)
• Coffee service in the office at no cost to the team.
• Teaming team that organizes leisure activities.
• Competitive salary: Fixed + Variable + Flexible Remuneration.
• Employee Club: discounts on services and establishments.
• Employee Portal user-friendly with all the information you need in your day-to-day.

A company developing innovative technological solutions based on environmental data through digital twins, enriched with local information captured by our IoT devices. They are looking for a Data & Analytics Engineer with 3-5 years of work experience in a similar role.

• Position with career and professional development opportunities
• Core IT Client

• Design, build, and maintain data models in dbt on BigQuery following a layered architecture (staging, intermediate, marts) and star schema / Kimball methodology.
• Implement incremental models in dbt for high-volume tables, reducing execution costs in BigQuery.
• Maintain documented data lineage in dbt, so that any change in a source can be traced to the dashboards it impacts.
• Translate business needs from internal teams (sales, operations, finance) into actionable data specifications and reusable models.

Data Quality and Governance

• Guarantee the quality, consistency, and traceability of corporate data: define and maintain quality tests (not_null, unique, accepted_values, relationships) in dbt.
• Standardize data in the staging layer: names, formats, enums, null and duplicate fields, so that downstream models do not inherit source problems.
• Maintain an active data catalog so that any team knows what data exists, what it means, who maintains it, and when it was last updated.
• Continuously monitor data quality and act on anomalies before they impact teams or management reports.

Business Intelligence and Self-Service

• Develop and maintain dashboards and reports in Looker for different areas of the company, oriented towards operational and strategic decision-making.
• Build the semantic layer in Looker to allow non-technical teams
• to explore data, generate their own visualizations, and export reports without needing help from the data team for every query.
• Train internal users in the use of Looker: how to filter, explore, create visualizations, and read data autonomously.
• Perform ad hoc analysis when management needs to answer questions that are not in any existing dashboard.

Automations and Internal Portal

• Build and maintain automation flows with N8N to streamline the company's day-to-day processes.
• Develop and maintain internal mini-apps (forms, interfaces, process status pages) that connect data with automation flows, as part of the internal operations portal.
• Participate in the evaluation and possible evolution of the current internal portal towards a more robust and maintainable solution.

Orchestration, Infrastructure, and Technical Debt

• Manage and monitor dbt executions in Cloud Run: scheduling,
• execution order, failure alerts, and notifications.
• Basic management of the GCP environment where the data stack lives: IAM permissions, Cloud Storage, Cloud Scheduler.
• Maintain existing Airflow DAGs and migrate legacy developments to the new infrastructure, documenting the business logic in the process.
• Document all developments in Git with clear commit messages, code reviews, and deployments through the existing CI/CD pipeline.