Data Analyst

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