Position: Data Analyst for BI project
Company: Maxitech
Experience required: 3y
Category: SQL
English level: upper
Published: 2020-09-01T00:00:00+03:00

Project description
Maxitech is a R&D office of large international holding, building a portfolio of products linked to each other with the business goals they are addressing. Our project is long term and has stable financing. There are existing solutions for Marketing&Sales departments which are already in production and have active phase of new functions development as well as start-up products.

Maxitech R&D team’s target is developing software solutions maximizing the performance of the core business. Current team size is 190+ employees. We are looking for experts ready to bring their knowledge and contribute to building the new, best-in-the class, software product.
Our company headquarter is in Israel. We also have offices in 8 locations worldwide. R&D team is fully concentrated in Kyiv.
We don’t do outstaff or outsource, we don’t have a “client” and don’t sell any service. We make qualitative software products to enable the business become more efficient and successful.


Required skills:

—	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.

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.

As 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.


What we offer:

—	Unique working environment where you communicate and work directly with client
—	Being a part of the positive and fun team
—	Cutting-edge technology stack
—	Team of strong IT professionals working in a dynamic startup environment
—	Big amount of knowledge-sharing practices and sessions
—	Centrally located office near Poshtova Square metro station with great view from our terrace
—	Competitive salary, reasonable and fair working conditions, flexible schedule
—	 Medical insurance after 3 months cooperation
—	English classes
—	Lances provided by Maxitech
—	Corporative events.


About Maxitech
Maxitech R&D team’s target is developing software solutions maximizing the performance of the core business. Current team size is 200+ employees. We are looking for experts ready to bring their knowledge and contribute to building the new, best-in-the class, software product.
Our company headquarter is in Israel. We also have offices in 8 locations worldwide. R&D team is fully concentrated in Kiev.
We don’t do outstaff or outsource, we don’t have a „client” and don’t sell any service. We make qualitative software products to enable the business to become more efficient and successful.


Companies’ Site:
https://www.maxitechs.com/
DOU:
https://jobs.dou.ua/companies/maxitech/