BI Engineer Senior (Teradata Microsoft Fabric)

CGI
Municipality of Madrid, Spain
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English

Job location

Municipality of Madrid, Spain

Tech stack

Artificial Intelligence
Azure
Cloud Computing
Continuous Integration
Information Engineering
Data Governance
Data Warehousing
Linux
DevOps
Hive
Python
Oracle Applications
Performance Tuning
Power BI
SQL Databases
Oracle Fusion Middleware
Teradata
Data Ingestion
Sap Business Objects
Build Management
Microsoft Fabric
PySpark
Azure
Oracle Ebusiness
Oracle Erp
Data Pipelines
Control M

Job description

  1. Teradata (Current Platform) Maintenance, evolution, and optimization of existing processes Resolution of critical incidents Performance tuning of data loads and queries Development of new ELT processes

  2. Microsoft Fabric (New Projects) Design and build architectures in Fabric Development of data ingestion pipelines Creation of Lakehouse and Warehouse models Implementation of semantic models for financial reporting Definition of best practices, security, and governance

  3. Oracle ERP Integration Extraction and transformation of financial data from Oracle EBS / Oracle Fusion Ensuring consistency between Teradata and Fabric environments Financial reporting-oriented data modeling

#LI-JC10

  • Azure Service Fabric
  • Teradata
  • Python

Together, as owners, let's turn meaningful insights into action.

Requirements

To select a Senior BI Engineer with proven experience in Teradata Vantage and Microsoft Fabric, capable of working across both environments. The professional will be responsible for maintaining and evolving the current Teradata platform while developing new solutions in Microsoft Fabric.

Microsoft Fabric Hands-on, demonstrable experience in real projects involving: Lakehouse Data Engineering (Notebooks, PySpark, Spark SQL) Data Pipelines Fabric Warehouse / SQL Endpoint Power BI (datasets and semantic models) The candidate must demonstrate real prior experience, not only theoretical training.

Teradata Vantage Strong experience in: Advanced SQL in Teradata Performance tuning ELT development (BTEQ, TPT or equivalent) Design and optimization of data models and data loads in Teradata Incident resolution and operational support

Financial Context (Oracle ERP EBS 11.5 / Fusion Cloud) Experience integrating financial data from Oracle Practical knowledge of financial data models, including: GL (General Ledger) AR (Accounts Receivable) AP (Accounts Payable) FA (Fixed Assets) Cash Management Financial Reporting Previous experience working with Finance data: accounting, month-end closings, reporting, audits, reconciliations

Other Mandatory Requirements Experience with Control-M and Linux scripting Advanced SQL (analytics functions, partitioning, optimization) Experience in complex, mission-critical data environments Senior profile with strong technical autonomy

Nice-to-Have Requirements Experience with SAP BusinessObjects Azure Data Platform experience complementary to Fabric Purview or other data governance tools Experience migrating from traditional DWH to Lakehouse architecture Advanced Python CI/CD and DevOps practices for data pipelines Development of AI agents using M365, Copilot Studio, or AI Foundry

Apply for this position