# OUSSAMA AMARA

OUSSAMA AMARA is a remote worker on Himalayas, Matrix IDM Consultant at Bridge Consulting, based in Canada.

Source: https://himalayas.app/@oussamaamara

```text
Data Engineer at Bridge Consulting who integrated FactSet and Bloomberg feeds into Azure and Databricks pipelines for financial data.
```

| Detail | Value |
| --- | --- |
| Availability | Looking for a job |
| Location | Canada |
| Authorized to work in | Canada |
| Salary expectations | 120k+ CAD |
| Job categories | Data Engineer, Data Warehouse Developer, Business Intelligence Developer, ETL Developer, Database Administrator |
| Skills | Data Engineering, ETL ELT, Data Pipelines, Data Warehouse, Data Integration, Data Quality, Data Validation, Data Reconciliation, Data Modeling, Dimensional Modeling, Medallion Architecture, Star Schemas, Legacy System Migration, Financial Data, Performance Optimization |

## About

```text
At Bridge Consulting, I designed and operated Azure Data Factory and Databricks pipelines for the RIMES Financial Data Platform, integrating FactSet and Bloomberg feeds for a U.S. financial services client. I built Python and PySpark transformations and data quality frameworks to prepare and validate financial data for downstream use.

For Alberta Investment Management Corporation (AIMCo), I contributed to Databricks, Azure Synapse, and Snowflake modernization work. I led the migration of 300+ legacy SSRS reports to Power BI Service, rebuilding data models and reconciling outputs before the old reports were decommissioned.

Across my work, I’ve developed ETL processes, dimensional models, and reporting solutions, and investigated production issues through to root cause. I’ve also supported SQL Server performance tuning, automated deployments with Azure DevOps CI/CD and Git, and written technical documentation and runbooks.
```

## Experience

### Matrix IDM Consultant

Bridge Consulting. Oct 2024 - Aug 2026

```text
Designed and operated large-scale ingestion pipelines on Azure Data Factory and Databricks, integrating FactSet and Bloomberg data. Built data quality, validation, and monitoring frameworks, and developed Power BI reporting for business stakeholders.
```

Skills: Azure-Data-Factory, Databricks, PySpark, Python, Power-BI, Factset, Bloomberg, Data-Quality, Monitoring, Git, Azure-DevOps

### Data Warehousing, Analytics and Business Intelligence Developer

Bridge Consulting. Jan 2018 - Sep 2024

```text
Contributed to Databricks and Azure Synapse Medallion architecture and Snowflake data warehouse build. Developed ETL pipelines, optimized T-SQL, led migration of 300+ SSRS reports to Power BI, and automated deployments via Azure DevOps.
```

Skills: Databricks, Azure-Synapse, Snowflake, Python, T-SQL, Power-BI, SSRS, Azure-DevOps, Git, Power-Automate, Dimensional-Modeling

### BI / ETL Developer

Calgary IT Consulting Inc.. Feb 2017 - Dec 2017

```text
Built SQL transformations, ETL pipelines, and dimensional data models for private-equity clients. Developed reconciliation and validation routines and converted legacy SAP BusinessObjects reports to Power BI.
```

Skills: SQL, ETL, Dimensional-Modeling, Power-BI, SAP-Business-Objects, Data-Validation, Reconciliations

### MS SQL / BI ETL Developer

BIRKBY Service. May 2015 - Jan 2017

```text
Developed enterprise data models, complex T-SQL, stored procedures, and SSIS transformation logic. Improved SQL Server performance through query optimization and led integration and UAT testing.
```

Skills: T-SQL, SSIS, SQL-Server, Performance-Optimization, Power-BI, SSRS, Data-Modeling

### BI / ETL Developer

Target Consulting. Dec 2014 - Apr 2015

```text
Developed ETL pipelines in SAP BusinessObjects Data Services and maintained data lineage. Modeled relational data from disparate sources including SAP BI, SAP HANA, Oracle, and SQL Server.
```

Skills: SAP-Data-Services, SAP-Hana, Oracle, SQL-Server, Data-Modeling, Data-Lineage

### Database Administrator (Oracle)

[SAIT Polytechnic](https://himalayas.app/companies/sait). Oct 2013 - Mar 2014

```text
Administered Oracle and Banner ERP databases and led a migration from Access to Oracle. Built tables to ER-diagram specification and applied SQL performance tuning.
```

Skills: Oracle, Banner-ERP, SQL, Toad, Performance-Optimization, Database-Design

## Education

### ERP College

Certificate, Data Warehousing

```text
Earned a certificate in SAP Data Warehousing and HANA from ERP College, Calgary, in 2017.
```

### SAIT Polytechnic

Diploma, Business Intelligence

```text
Completed a Business Intelligence Diploma from SAIT Polytechnic, Calgary, in 2015.
```

### SAIT Polytechnic

Diploma, Database Administration

```text
Completed a Database Administrator Diploma from SAIT Polytechnic, Calgary, in 2014.
```

### ISET

Degree, Computer Science

```text
Completed a Computer Science degree from ISET, Tunisia, in 2007.
```

## Tech stack

- Snowflake
- Apache Spark
- Tableau
- QlikView
- Microsoft Azure
- Pandas
- PySpark
- MongoDB
- Microsoft SQL Server
- Oracle
- Azure DevOps
- Python
- Azure SQL Database
- Git
- SQL
- Delta Lake
- Bash
- Power BI
- Power Query

To contact OUSSAMA, message them from this profile with a Himalayas employer account: [Hire on Himalayas](https://himalayas.app/hire).

## People also viewed

- [Mounika Ramarao](https://himalayas.app/@mounikaramarao): Azure Data Engineer, Innovapost
- [Ashritha User](https://himalayas.app/@ashrithauser): BI & Data Analyst, BMO
- [Eric luo](https://himalayas.app/@ericluo): Database Administrator, Trimble / Cengea
- [Femi Babatunde](https://himalayas.app/@femibabatunde): Intermediate Business Intelligence Engineer, Government of Alberta
- [Ismail Yunus](https://himalayas.app/@ismailyunus): Data Engineer / Cloud Data Consultant, Alphadot
- [Sai praneeth Boddupalli](https://himalayas.app/@saipraneethboddupall): Azure Data Engineer, Price Industries
- [Jerry Ade](https://himalayas.app/@jerryade): Data Engineer, Wesco
- [AI SENSI](https://himalayas.app/@aisensi): Data Engineer – ETL & Data Management, Scotiabank
- [Dharmil Patel](https://himalayas.app/@dharmilpatel): Senior Data Engineer, EY
- [Dmitro Mikhailenko](https://himalayas.app/@dmitromikhailenko): Senior DBA / Data Engineer, Ledcor Group
