Инженер данных

The company builds software for a large computer hardware distributor that processes thousands of customer orders every day. Its platform manages the full order lifecycle from purchase through warehouse fulfillment and shipping, while its data platform supports operational efficiency, business intelligence, and AI-driven decision making.

• Analyze and improve the existing MySQL database;
• Optimize database schemas, relationships, indexes, and slow SQL queries;
• Evaluate and plan a potential migration from MySQL to PostgreSQL;
• Ensure database scalability, reliability, and maintainability;
• Design and build reliable ETL/ELT pipelines;
• Move operational data into the Data Lake and Amazon Redshift;
• Automate data processing workflows;
• Improve data quality, consistency, and governance;
• Monitor and troubleshoot data pipelines;
• Build datasets for sales analytics, warehouse operations, order fulfillment, shipping performance, inventory management, marketing analytics, pricing optimization, and customer purchasing trends;
• Prepare datasets for demand forecasting, product recommendations, dynamic pricing, shipping optimization, and advertising optimization;
• Guide the technical direction of the data platform;
• Mentor junior engineers through code reviews and technical guidance;
• Break down large initiatives into manageable technical tasks;
• Establish best practices for SQL, data modeling, and data engineering;
• Review database and pipeline designs before implementation;
• Collaborate with the engineering team to prioritize work and define technical solutions;
• Promote clean, maintainable, and well-documented data infrastructure;
• Improve database performance and reliability;
• Reduce slow queries and implement better indexing strategies;
• Deliver clean, well-structured datasets for analytics;
• Establish best practices for the growing data platform;
• Make architectural decisions influencing the company's technology.

• 3+ Years of experience working with relational databases;
• Strong SQL skills;
• Experience optimizing database performance;
• Solid understanding of indexes and query execution plans;
• Experience building or maintaining ETL/ELT pipelines;
• Experience with MySQL or PostgreSQL;
• Experience working with AWS or another major cloud platform;
• Good understanding of data modeling and database design;
• Strong analytical and problem-solving skills;
• Ability to work independently and take ownership of projects;
• Nice to have: Amazon Redshift, AWS Glue, Data Lakes, Change Data Capture (CDC), Apache Airflow, Amazon SageMaker, experience with warehouse, logistics, distribution, or e-commerce systems, experience mentoring engineers or leading technical initiatives.

• No conditions specified