Data Analyst / PowerBi Engineer in Nacionalna sluzhba zdorov’ya Ukrayini

Responsibilities — writing ad-hoc SQL queries to databases; — analysis of medical and statistical data in EHOS; — creation of analytical reports and dashboards; — maintenance and improvement of existing reports and dashboards; — analysis of reports of medical service providers; — analysis of the fulfillment of conditions contracts by providers of medical services; — development of methodology and algorithms for automatic monitoring; — creation and calculation of a system of indicators; — search for anomalies, cases of unethical behavior of providers of medical services; — formation of periodic analytical reports and reports in accordance with requests; — development and documentation of algorithms, scripts and technical solutions Required skills— Analytical thinking— Higher technical education (mathematics/physics/statistics/IT)— Basic knowledge of statistics— Experience with databases— Knowledge of basic approaches to modeling data models— Knowledge of SQL (PostgreSQL), writing queries, aggregations, windows functions, query optimization.— Knowledge of Python (pandas, openpyxl) (knowledge of R or other programming languages ​​will be an advantage)— Knowledge of Power Bi (experience with other BI systems will be an advantage)— Knowledge of Excel (DAX, PQ, complex formulas, aggregate tables) (experience of writing macros will be an advantage)— Experience of automating processes related to data collection and analysis will be an advantage— Knowledge of the basics of data visualization— Experience of working with data warehouses (experience of working with big data will be an advantage)— Ability to work with technical documentation , the ability to independently analyze and study existing business processes. Our advantages— Official employment;— Convenient work schedule: The office is near the city of Pochayna, there is an opportunity to work remotely;— 30 calendar days of vacation;— The possibility of professional and career growth;— A friendly team;