Position: Strong Middle/Senior Data Enginneer (CLOUD TECHNOLOGY)
Company: Sigma Software Group
Experience required: 2y
Category: Data Engineer
English level: intermediate
Published: 2022-06-01T00:00:00+03:00

As a Strong/Middle Data Engineer, you will be able to take part in the design and development of a new data platform enabling Power BI reporting/analytics functionality to build hundreds of reports, self-service analytics, and a modern data science capability with automation capabilities.

Are you ready to dive deep into exciting products and affect the industry with incredible creativity? How about joining the team developing products with a smile? This might be your golden chance!

**CUSTOMER**
Our customer is helping IT providers be more successful in the cloud. Also, the company plays an important role in the Microsoft cosmos. Over 20,000 IT partners in over 125 countries are accelerating their cloud businesses with our client.

**PROJECT**
The product is intended to facilitate and centralize management of different SaaS cloud subscriptions for small and medium-sized businesses.

The project’s main goal is to automate common IT tasks like on/offboarding users, password resets, and enforcing security policies as well as to facilitate the administration of Microsoft 365, Azure AD, and many other SaaS applications used by clients.

Sigma Software assists the project in delivering their latest innovations.

One of the important subprojects is related to Power BI reporting/analytics functionality to build hundreds of reports and dozens of dashboards. The main priority for now is aimed on MS 365 Security Center reporting.

The dashboards are to be interactive and based on both standard and customized components.

Current team: 3-4 Power BI technicians.

**REQUIREMENTS**
Bachelor’s degree in computer science, engineering, mathematics, or a related field
2+ years of experience using the following software and tools:
At least one RDBMS database: MySQL, MS SQL, or Azure SQL
At least one MPP database: Azure Data Explorer, Azure Synapse Analytics, Redshift
ETL/ELT software: SSIS or Azure Data Factory
At least one programming language: C#/.NET, JavaScript, Python, Java
Experience in data modeling, abstraction, and schema development, ETL/ELT development, and data warehousing
Experience in writing complex SQL queries across large data sets
Experience processing and extracting value from large and complex datasets
Experience in testing data quality from source to destination systems
Exposure to Power BI, Tableau, or similar BI tools
 

**NICE TO HAVE:**
Experience integrating PowerBI and/or PowerBI Embedded in a site/product UX
Experience with PBI query language (Power Query M)

**RESPONSIBILITIES**
Read and interpret user reporting requirements for the Cloud Manager product
Define data models in Azure Data Explorer to support direct queries from in-product Power BI Embedded that satisfy the user requirements
Extract, transform, and load data into downstream data models, using a staged approach where necessary
Work with Azure Data Factory and other orchestration enabling technologies (custom apis, Azure Event Grid) to source data on event triggers
Ensure Power BI Embedded is presenting the data in a way that meets the user requirements