~26d ago

Commercial Analyst

Ukraine·Kyivmid

SalesCommercial Analyst

2 views0 saves0 applied

Apply Now

Quick Summary

Key Responsibilities

Regular updating and maintenance of the department's commercial databases in line with established procedures: loading of market data (day-ahead and intraday markets, imbalance settlement),

Technical Tools

SalesCommercial Analyst

Responsibilities

~1 min read

→Regular updating and maintenance of the department's commercial databases in line with established procedures: loading of market data (day-ahead and intraday markets, imbalance settlement), generation and consumption data, contract and counterparty data;
→Support and updating of existing Power BI reports and dashboards: refreshing data sources, adjusting queries and visuals, monitoring scheduled refreshes and resolving or escalating refresh failures; assistance in building new reports;
→Consolidation of data from different sources (market platform exports, metering and generation systems, internal registers, Excel files) into unified structured datasets;
→Preparation of regular and ad hoc commercial reports in agreed formats: volumes, prices, revenues and margins by asset, product and counterparty;
→Data quality checks: reconciliation between sources, identification of discrepancies and flagging them to the responsible colleagues; maintaining up-to-date descriptions of data flows;
→Support of forecasting and commercial modelling activities under the guidance of senior colleagues: preparation of input datasets, scenario calculations, tracking of forecast accuracy metrics;
→Support of automation of recurring routines using IT and AI tools: Power Query, scripts, AI assistants for generating and debugging queries.

Requirements

~1 min read

Higher education in Data Analytics / IT / Mathematics / Statistics / Economics / Energy or related fields;
Up to 2 years of experience in analytical or data roles; graduates with demonstrable practical skills are welcome to apply;
Microsoft Excel – advanced level (mandatory): complex formulas, PivotTables, Power Query, handling of large workbooks;
Power BI – working level (mandatory): ability to build and refresh reports, work with Power Query; basic knowledge of DAX with readiness to develop it on the job;
Knowledge of the core principles of data analysis: data structuring and normalisation, descriptive statistics, validation of results;
Experience of working with large data arrays and consolidating data from several sources (including academic or personal projects);
Experience of AI assistants in day-to-day data work together with the ability to critically verify their output;
High level of attention to detail and accuracy; willingness to learn and to work with several parallel tasks within reporting deadlines;
English – Intermediate (ability to work with English-language materials and reporting).

What We Offer

~1 min read

✓Competitive salary and official employment with all social protection requirements;

✓Opportunity for career growth in an innovative renewable energy company with international investments;

✓Cooperation in a friendly atmosphere with a great professional team that implements ambitious energy projects and helps the country become truly energy independent;

✓Participation in corporate trainings and English language courses;

✓Performance management system for all employees;

✓A good health insurance package that will be available after the probationary period (3 months);

✓Phone package;

✓Workplace in a modern and innovative office in Kyiv with hybrid working schedule (3 days in the office, up to 2 days remote).