Data Analyst

Ajax Systems — an international technology company and the largest manufacturer of security systems in Europe. We are looking for a specialist for the Operations department for the position of Data Analyst.

Required knowledge and skills:

• SQL and data handling: SQL (JOIN, CTE, Window Functions), Databricks / Spark SQL, Delta Lake, data modeling and quality verification.
• Automation: Google Sheets (QUERY, ARRAYFORMULA, IMPORTRANGE), Apps Script, API.
• Tools: Jira (JQL, REST API), Confluence, BI dashboards.
• Production processes: understanding of BOM, NPI, specifications, 1C / SAP MM, materials and procurement planning.
• Analytical skills: working with large volumes of data, defining KPIs, error detection and root cause analysis.
• Systems thinking, attention to detail, proactivity, independence, and communication.

Will be a plus:

• Experience working with Python (pandas, numpy), ETL processes, and reporting automation.
• Knowledge of orchestration tools: Airflow, Databricks Jobs.
• Experience working with dbt, Unity Catalog, Data Lineage, and Data Catalog.
• Understanding of procurement planning processes, ABC/XYZ analysis, Lead Time, and inventory forecasting.
• Experience integrating systems via API and Webhooks, creating bots for Jira.
• Experience working with large datasets (CSV / Parquet, 10+ million rows).
• Skills in building predictive models and statistical analysis.
• Understanding of BPMN, User Stories, Git.

Tasks:

• Collect, process, and reconcile data from various sources (R&D plan, 1C, Jira, etc.).
• Develop and maintain analytical models, reports, and BI dashboards.
• Automate data collection, processing, and regular reporting.
• Analyze production processes, material requirements, inventory, and procurement.
• Identify errors, discrepancies, and operational risks, find their causes, and propose solutions.
• Develop metrics and KPIs for monitoring R&D Operations efficiency.
• Integrate internal systems and automate data exchange between them.
• Interact with R&D, production, procurement, and planning to optimize processes.

We offer:

• The opportunity to propose and implement your own ideas that impact the product and its mass production;
• A place in a fast-growing company with a motivated professional team;
• Competitive salary;
• Medical insurance;
• Corporate English classes;
• The opportunity to participate in an internal beta testing project for Ajax security systems;
• Discounts on company and partner products.

Ajax Systems is a Ukrainian success story that has grown into a global product. Ajax devices are trusted by over 4.5 million end users and 330 thousand PRO users in more than 180 countries. The company offers comprehensive solutions for protecting residential and commercial properties of various scales. Currently, the Ajax portfolio includes 280 devices for intrusion detection, video surveillance, fire safety, and comfort and automation.