Эта вакансия уже завершена
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
Сабина