# Data Analyst

**Company**: Ajax Systems
**Location**: Kyiv
**Work arrangement**: onsite
**Job type**: full-time
**Category**: Data Science
**Industry**: Technology

**Apply**: https://jobs.lever.co/ajax/e78344bc-8bb7-4863-bb16-9ccba8e5b3f6?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply
**Canonical**: https://yubhub.co/job/data-analyst-b87a1b16-13c/

## Description

Ajax Systems, a global technology company and Europe's largest security system manufacturer, is seeking a Data Analyst for its Operations department.

The ideal candidate will have expertise in SQL, data analysis, and automation, with experience working with large datasets and developing analytical models.

**Key Responsibilities:**

- Collect, process, and verify data from various sources (RND plans, 1C, Jira, etc.)

- Develop and maintain analytical models, reports, and BI dashboards

- Automate data collection, processing, and regular reporting

- Analyze production processes, material needs, inventory, and procurement

- Identify errors, discrepancies, and operational risks, and propose solutions

- Develop metrics and KPIs to monitor R&D Operations efficiency

- Integrate internal systems and automate data exchange between them

- Collaborate with R&D, production, procurement, and planning to optimize processes

**Requirements:**

- SQL and data analysis skills: SQL (JOIN, CTE, Window Functions), Databricks/Spark SQL, Delta Lake, data modeling, and quality verification

- Automation skills: Google Sheets (QUERY, ARRAYFORMULA, IMPORTRANGE), Apps Script, API

- Tool proficiency: Jira (JQL, REST API), Confluence, BI dashboards

- Production process understanding: BOM, NPI, specifications, 1C/SAP MM, material planning, and procurement

- Analytical skills: working with large datasets, defining KPIs, identifying errors, and root cause analysis

- Soft skills: systematic thinking, attention to detail, proactivity, independence, and communication

**Nice to Have:**

- Experience with Python (pandas, numpy), ETL processes, and automated reporting

- Knowledge of orchestration tools: Airflow, Databricks Jobs

- Experience with dbt, Unity Catalog, Data Lineage, and Data Catalog

- Understanding of procurement planning processes, ABC/XYZ analysis, Lead Time, and inventory forecasting

- Experience with system integration through API and Webhooks, and creating bots for Jira

- Large dataset handling (CSV/Parquet, 10+ million rows)

- Predictive modeling and statistical analysis skills

- Understanding of BPMN, User Stories, and Git

**We Offer:**

- Opportunity to propose and implement ideas affecting the product and its mass production

- Position in a rapidly growing company with a motivated professional team

- Competitive salary

- Medical insurance

- Corporate English language classes

- Opportunity to participate in an internal beta testing project for Ajax security systems

- Discounts on company and partner products

For more fresh new jobs, check out [yubhub.co](https://yubhub.co/).

## Skills

### Required
- SQL
- Databricks/Spark SQL
- Delta Lake
- Google Sheets
- Apps Script
- API
- Jira
- Confluence
- BI dashboards
- 1C/SAP MM
- Python
- ETL processes

### Nice to have
- Airflow
- Databricks Jobs
- dbt
- Unity Catalog
- Data Lineage
- Data Catalog
- BPMN
- User Stories
- Git

---

Source: [Apply at jobs.lever.co](https://jobs.lever.co/ajax/e78344bc-8bb7-4863-bb16-9ccba8e5b3f6?utm_source=yubhub.co&utm_medium=jobs_feed&utm_campaign=apply)