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
Data Analyst for BI project

Would 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
  • Participate and contribute to CI/CD processes in alignment with DevOps Team
  • Cooperate with Business Analysts team to assist with Power BI report implementation.
  • Suggest ideas to improve data model, reporting, visualization
Get in touch

Join us!

Ready to join us – send your CV

Referral program

60% of Maxitech employees are referred by their peers or friends. If you know the best ones in the field and wish the best for them, share their contacts with us so we can make them happier with their workplace. Your referral bonus will send to you with the selfie happy face of the employee when the trial ends.

Referral program

60% of Maxitech employees are referred by their peers or friends. If you know the best ones in the field and wish the best for them, share their contacts with us so we can make them happier with their workplace. Your referral bonus will send to you with the selfie happy face of the employee when the trial ends.

Data Analyst for BI project

vacancy is currently closed