Data Analyst for BI project

For large international holding that builds a portfolio of products linked to each other with the business goals they are addressing. Our project is long term and has stable financing we are looking for a Data Analyst for BI project.

Requirements:

• Excellent knowledge of SQL (creation of views, stored procedures, functions, indexes, and relational

• database management in general)

• Understanding the concepts of data profiling and main data quality checks

• Understanding of Business Intelligence projects (data integration, data warehousing and visualization)

• Basic knowledge of programming and scripting language (preferably Python) to deliver test automation

• for data consistency and data integrity checks

• At least Upper-intermediate English level.

Will be a plus:

• Strong financial and business analysis skills

• Experience with a whole BI process verification (ETL, DWH, Data Marts, Reporting)

• Hands-on knowledge of Python to deliver data quality test automation.

Responsibilities:

• Ensure data completeness, consistency and accuracy while performing data checks

• Perform data quality validation using SQL for the next data sources: Microsoft SQL Server, MySQL databases

• Perform data profiling and regression testing

• Perform data integrity checks for REST API data sources and Data Warehouse (DWH)

• Validation of the financial metrics calculation using Power BI and Microsoft Excel

• Make sure that current Power BI reports updated with new business metrics

• Bug reporting via TFS and help with data quality issues communication and troubleshooting

• Create and maintain test documentation

• Conduct experiments and test with BI Data Model to find gaps and issues

• Perform validation of full-cycle Business Intelligence solution