Дата аналитик

CRAE GROUP builds and manages technology and operational services for online businesses, providing scalable systems and specialized teams to support brands across various industries.

• Create one-off reports using SQL based on business and operational requests;
• Translate reporting needs from management, product, finance, CRM, and operations into accurate data outputs;
• Write, review, and improve SQL queries used in reports, dashboards, exports, and internal tools;
• Analyze existing queries to identify issues such as incorrect joins, duplicate counting, wrong aggregations, missing filters, or inefficient logic;
• Review slow or heavy queries and suggest improvements to performance and structure;
• Help validate that reported numbers are accurate and aligned with business definitions;
• Recommend improvements to query structure, indexes, views, or reporting approaches where relevant;
• Document the logic behind important reports and recurring SQL queries;
• Collaborate with developers and stakeholders to clarify requirements and edge cases;
• Raise concerns early when data may be incomplete, misleading, or incorrectly interpreted.

• Strong SQL experience in production environments;
• Ability to write, review, and optimize complex SQL queries;
• Good understanding of joins, aggregations, subqueries, CTEs, indexes, and query execution logic;
• Experience working with relational databases such as MySQL, PostgreSQL, or similar;
• Ability to understand business requirements and convert them into reliable data outputs;
• Strong attention to detail and ability to identify inconsistencies in data;
• Good debugging and investigation skills when numbers do not match expectations;
• Ability to explain query logic and findings clearly to both technical and non-technical stakeholders;
• Practical mindset with the ability to improve existing queries without overengineering;
• Clear communication and a strong sense of ownership;
• Nice to have: experience with BI or reporting tools such as Metabase, Power BI, Tableau, Looker, or similar, experience working with Laravel/PHP-based applications or product databases, experience with finance, CRM, payments, user activity, gaming, or high-volume transactional data, understanding of database performance analysis and execution plans, ability to suggest improvements to reporting structures.

• €45 000 – €70 000 Gross per year.