bi developer

Headquartered in Monaco, our client has been investing in and operating shipping assets since 1926. Our client is a leading service provider engaged in the seaborne transportation of commodities. The Group has experience investing in crude oil and product tankers, gas, dry bulk, containers as well as offshore oil and wind. With fourteen different offices located all around the world, and a shore workforce of nearly 1,000 employees, our client is a fast-growing, fast-paced and stimulating work environment. Our client’s core values are Integrity, Collaboration, Stewardship and Moxie.

SQL – Development Experience:

• Minimum 5 years of experience as BI developer with Microsoft tools and technologies (MS BI)

• Excellent Data Analysis skill.

• IT experience in working with T-SQL and Development on Microsoft SQL Server database 2016 onwards.

• Experience with T-SQL in constructing Tables, implementing stored Procedures, Functions, Views, etc.

• Expert in working with database jobs, ETL scheduling etc.

• Experience in working with Cloud platform like Azure, AWS or GCP would be added advantage.

SSAS – Development Experience:

• Hands on experience on Analysis Services (SSAS), and Visual Studio.

• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

• Deploy and processed SSAS cubes using SQL Server Agent.

• Hands on experience of developing model in SSAS Cubes.

• Experience in developing DAX in SSAS.

• Good in depth understanding of different type of relationships and data modelling.

SSIS – Development Experience:

• Experienced in using ETL tools in (SSIS) 2019/2016.

• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.

• Data Loading Experience in SQL Server using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.

• Data analysis and data migration by transferring them using SSIS packages.

• Additional experience of working with ADF pipelines would be plus.

Power BI Experience:

• Developed Power BI model used for financial reporting of P & L and Headcount.

• Designed and documented the entire Architecture of Power BI.

• Expertise in writing complex DAX functions in Power BI.

• Used various sources to pull data into Power BI such as SQL Server, SQL Azure etc…

• Created content pack and allow access to the end user.

• Created Workspace and content packs for business users to view the developed reports.

• Scheduled Automatic refresh and scheduling refresh in power bi service.

• Write calculated columns, Measures queries in power bi desktop to show good data analysis techniques.

• Weekly presentation to the business users about the reports and their changes as required.

• Worked on all types of transformations that are available in Power bi query editor.