The Role
Collects, cleans, transforms, and analyzes data from databases, ERP systems, Google Sheets, APIs, and cloud platforms. Develops Power BI reports and dashboards, automates recurring reporting and ETL pipelines, performs advanced SQL analysis, documents data sources and KPI logic, and provides ad-hoc business support. Communicates insights through effective data visualizations and storytelling to support business decisions.
Summary Generated by Built In
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!
Skills Required
- Advanced SQL analysis, including JOINs, CTEs, and window functions
- Experience building data pipelines and ETL processes
- Hands-on experience with Google BigQuery
- Ability to communicate insights through data storytelling and presentations
- Strong knowledge of Power BI
- Experience with SQL, Power BI, Google BigQuery, and Python
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
The largest manufacturer of security systems in Europe. Designed and developed in Ukraine
