Position: BI Engineer / Data Analyst / SQL
Category: Data Analyst
English level: intermediate
Years of experience: 3

Analytical mindset, eagerness to understand and solve problems, self-organized, proactive, highly reliable, and willing for new challenges and achievements.
3 years of commercial experience in IT, including:
- 3 years with SQL
- 2,5 years with BI tools ( Tableau, MіcrоStrаtеgу, PowerBI, QlikView)
- 2,5 years with reporting tools (MіcrоStrаtеgу, CоntrоllеrVіеw)
- 1 year as a mentor for junior colleagues

• BI Developer
– Development of Dashboards, Ad-Hoc and Detailed Reports, and drilling features for them via YAML or specific drill maps.
– Write complex SQL queries using MS SQL Server DB to investigate issues or calculations in reports and dashboards. 
– Optimization of SQL queries in Cubes for ETL process performance manipulating BI tool features to get the most efficient SQL statement that automatically generates in Cubes.
– Environment configuration in BI tool.
– Configuration of security structure, roles, and user hierarchy for data view for end users.
– Requirements clarifications and management.
– Mentoring junior colleagues.

• Data Analyst
– Reconciliation of the General Ledger and the Balance Sheet with MS Excel.
– Analysis of discrepancy, and elimination of errors after data profiling - data format converting, parsing, and data transformation.
– Development of complex ETL workflow in Alteryx tool.
– Write complex SQL queries using MS SQL Server DB.
– Preparation of control panels for further audit in PowerBI and QlikView BI tools - install financial data dashboards.


• Data Solution Developer
– Design pipelines to automate the creation of regulatory banking reports - processing, grouping, and aggregating data according to proper financial logic in the proprietary software.
– Building proper relational data models (joining client and permanent tables).
– Creation of technical solutions with fundamentals of XBRL.
Interested in opportunities for professional development and learning new technologies.