BI Engineer Senior (Teradata + Microsoft Fabric)

Position Description:

Search Objective
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.

Your future duties and responsibilities:

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

Key Role Responsibilities
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

Skills:

• Azure Service Fabric
• Teradata
• Python

What you can expect from us:

Together as owners lets turn meaningful insights into action.

Life at CGI is rooted in ownership teamwork respect and belonging. Here youll reach your full potential because

You are invited to be an owner from day 1 as we work together to bring our Dream to life. Thats why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our companys strategy and direction.

Your work creates value. Youll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas embrace new opportunities and benefit from expansive industry and technology expertise.

Youll shape your career by joining a company built to grow and last. Youll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons.

Come join our teamone of the largest IT and business consulting services firms in the world.