RESPONSIBILITIES:

Work with Power BI Analysts/Developers to understand report requirements and Design solutions with Power BI Analysts.

Develop extract, transform and load (ETL) jobs to migrate data from source systems to Azure DW.

Develop Azure database objects (Tables, Views, Procedures, Functions, Indexes, Triggers…

Investigate and Optimize database objects performance

Provide written documentations for Azure developments and Power BI model design.

Guide Azure DW development team members with data model and structures of Oracle ERP and commercial application

Support month-end closing activities by monitoring related Azure processes.

Monitor ETL jobs as needed.

Administer Power BI workspace access and permissions, monitor dataset refreshes.

Education and/or Work Experience Requirements:

Over 5 years experience on RDMS database development such as Azure SQL Database, MS SQL Databases or Oracle database.

Over 5 years experiences with Oracle ERP EBS from database backend to application end.

Excellent communication skills both verbal and written.

Great team player and can work independently well as a great individual contributor.

Strong analytics and troubleshooting skills.

Quick learner for new technologies and applications.

Experiences with commercial applications such as Salesforces.com and ServiceMax is a plus

Knowledge and experience with Informatica Cloud Services is a plus.