Analyst (Power BI) in ENEKST, TOV

Electrotechnical companyE.NEXT-Ukraine - the Ukrainian representative office of E.NEXT INTERNATIONAL ELECTROTECHNICAL GROUP in connection with the expansion of the staff invites cooperation in Analytics (Power BI).

Main goal: Building end-to-end analytics that combines internal company data (1C:) and external market indicators for automated reporting.

Working conditions:

• Official employment (social package);
• Standard working day: Monday-Thursday from 8:00 a.m. to 5:00 p.m., Friday from 8:00 a.m. to 4:00 p.m.;
• Corporate mobile communication;
• Medical insurance;
• Comfortable office in Vyshnevo (the Company's car transport from/to Akademmistechko metro station);
• Market salary level (salary level is ready to be discussed individually at the interview);
• If necessary, we provide reservations;
• Opportunity for professional development.

Requirements to the candidate:

• Power BI (DAX, Power Query): Advanced level.
• Working with databases, understanding the structure of 1C (registers, documents) and experience working with relational databases.
• Skills for working with external sources, the ability to integrate data from Excel reports, third-party APIs or external registers.
• Mathematical literacy, ability to work with large amounts of information without loss of quality and accuracy.

What needs to be done:

• Data consolidation: setting up automatic data collection from various sources: internal 1C database and external industry databases (analysis of import, export and competitive environment).
• Synchronization та автоматизація: побудова «містка» між 1С та Power BI (через OData, SQL або API), щоб виключити ручне вивантаження файлів. Reports should be updated automatically.
• Large array processing (ETL): cleaning, structuring, and combining disparate data into a single model for analysis.
• Assortment and sales analysis: building dashboards to evaluate manager performance, product group profitability, and analyze plan execution.
• Visualization: creating interactive reports that allow you to "drill down" from general company figures to a specific product or order.