Ajax Systems

European security systems maker, smart homes

Middle Power BI Analyst

Data Engineering +1Confirmed live in the last 24 hours

Full-timeChișinău, MoldovaNo salary listedIn-person

About the Job

Requirements

Write complex SQL queries using joins, common table expressions, and window functions to retrieve and analyze data.
Design and implement reliable data pipelines and extract, transform, and load (ETL) processes that consolidate data from various sources into a centralized data warehouse or data lake.
Have hands-on experience with Google BigQuery.
Tell a clear, compelling story from data that supports specific business decisions, including structuring presentations and communicating insights effectively.
Have strong knowledge of Power BI.
Work with SQL, Power BI, Google BigQuery, and Python.

Responsibilities

Collect and extract data from databases, enterprise resource planning systems, Google Sheets, and application programming interfaces.
Clean and transform data through data cleaning and wrangling.
Develop reports and dashboards.
Select appropriate visualizations to communicate information effectively.
Respond to ad hoc requests from different departments and support report users.
Document analysis methodologies, data sources, and key performance indicator calculation logic.
Automate regular reporting to reduce manual operational work and build data pipelines using ETL tools or scheduling features in business intelligence tools.

The international technology company Ajax Systems opens a full-cycle production.

Ajax Systems is the largest developer and manufacturer of security systems in Europe. The back office, R&D department, and two full-cycle production facilities are located in Ukraine. The company has branch offices worldwide: UAE (Dubai), Italy, Spain, Germany, Poland, Canada, and many other regions. Ajax team has more than 2,200 employees, including 500 developers and 1,200 production workers. Attracting local expertise in each key market enables us to scale the product globally and grow fast.

Responsibilities:

Data collection and extraction: working with databases, ERP systems, Google Sheets, and APIs.
Data cleaning and transformation: Data Cleaning / Wrangling.
Report and dashboard development.
Data visualization: selecting the most appropriate visualizations to communicate information effectively.
Ad-hoc business support: responding to ad-hoc requests from different departments and supporting report users.
Documentation: documenting analysis methodologies, data sources, and KPI calculation logic.
Report automation: automating regular reporting, reducing manual operational work, and building data pipelines using ETL tools or scheduling features in BI tools.

Requirements:

Advanced SQL analysis: writing complex queries using JOINs, CTEs, and window functions to retrieve and analyze the required data.

Building data pipelines and ETL processes: designing and implementing reliable processes for extracting, transforming, and loading data from various sources into a centralized storage system (Data Warehouse, Data Lake).

Working with cloud platforms: hands-on experience with Google BigQuery.

Data Storytelling: ability to go beyond simply presenting charts and tell a clear, compelling story based on data that leads to specific business decisions. This includes structuring presentations and effectively communicating insights.

Strong knowledge of Power BI.

Tech Stack: SQL, Power BI, Google BigQuery, Python.

Ajax Systems is a big team of professionals and open-minded people who share ambitious goals. Join in!

About the Company

Ajax Systems

European security systems maker, smart homes

Ajax Systems designs and manufactures security systems for homes and businesses, focusing on products that integrate smart home capabilities. The company produces security hardware such as sensors and alarms that can work together as a system, usually managed through a centralized platform. Distinguishing factors include its European manufacturing base and specialization in security systems with smart home integration, catering to customers who want connected and remotely manageable protection. The goal is to provide reliable security solutions that combine traditional protection with smart, networked features for easier monitoring and control.

Company size: 1,001-5,000
Company stage: Late Stage VC
Total funding: $11M
Headquarters: Kyiv, Ukraine
Founded: 2011

Recently Posted Jobs

Explore more opportunities at Ajax Systems

See more jobs