Senior Data Engineer / Data Warehouse Developer
Sky Systems, Inc
Montreal, QC, Canada
2d ago

Senior Data Engineer / Data Warehouse Developer

We need someone well-verse in DWH architecture, modeling and ETL using Microsoft SSIS, SSAS and with some experience in Azure Data Solutions (ADF, Synapse, Databricks).

Experience with SAP ECC data extraction is a plus. Very good English is a must, bilingual is a clear asset Requis : Connaissance de l'architecture modeling and ETL using Microsoft SSIS, SSAS experience in Azure Data Solutions (ADF, Synapse, Databricks) Very good English is a must, t

Time allocation per item of scope :

1- 20%, 2- 40%, 3- 25% 4- 10% 5- 5%

1. Design and implement the Bombardier Data platform on Microsoft Azure cloud :

o Bring concept of a cloud "lake house (Data Lake and Data Warehouse architecture)

o Support definition of functional and non-functional requirements

o Define Policies and Operating Procedures to ensure compliance to bombardier policies and industry best practices for data management (i.

e. Data Lake governance, Relational database governance)

o Identify cloud service building blocks for the platform and their integration (ETL, data modeling and data serving tools, advanced analytics capabilities for Client / AI)

o Validate proposed design with PoC

o Perform as data architect for initial projects to be levering the data platform and formalize data architecture guidelines.

2. Perform as technical lead to deliver a "Cost Accounting data warehouse built on Azure which will feed a PowerBI and PowerOn BI frontend layer.

o Solution Design and development to be provided by a third party

o Manage the third party from a technical execution and Bombardier acceptance aspect

o Define best approach to SAP ECC data extraction to Azure

o Coordinate with internal groups at BBD to enable the developers

o Configure Azure services and manage Role / access for the solution

o Ensure maintenance and operating procedures are properly documented for the solution when going in Production

3. Work together with IBM to ensure proper execution of the existing legacy BI environment (SSIS, SSRS, WhereScape Red)

o Good knowledge of SAP ECC data structure

o Experience with SAP SLT and ODATA extraction on SAP ECC

o Perform as SQL database admin to manage access to view / query for data analysts

o Advanced SQL scripting competency for troubleshooting

4. Support ad-hoc Data engineering request related to PoC or change request on the existing MS BI / Wherescape Red platform

o New / modified ETL

o New / modified SQL query / view

5. Support recruitment process with technical candidate screening and interview for competencies related to the mandate.

Ideal Work Experience / Profile

MS BI Developer (Backend) SQL Db, DWH, SSIS, SSRS, SSAS - 10 years

BI Solution Architecture on Azure - 3-5 years

Soft skills / personnalite recherche e

Highly autonomous in driving a small team to deliver optimized BI solution

Good English communication skill, French not required

Organized, capable of driving with a project mindset

Competencies / Knowledge

Functional knowledge of WhereScape Red-Nice to have

Good knowledge of Python

Experience with SAP ECC data extraction -Nice to have

Education / Accreditation / Technical Expertise

SSIS expertise

Report this job
checkmark

Thank you for reporting this job!

Your feedback will help us improve the quality of our services.

Apply
My Email
By clicking on "Continue", I give neuvoo consent to process my data and to send me email alerts, as detailed in neuvoo's Privacy Policy . I may withdraw my consent or unsubscribe at any time.
Continue
Application form