Job Opening: Backend Developer, Analytical Data (PHP + MySQL, complex queries)
Location: Remote
About the Company
We are a fast-growing product company in eSIM and digital roaming for travel. Our platform helps users around the world get mobile internet without plastic SIM cards — quickly, conveniently, and at a fair price.
We build products where decisions are data-driven: from monitoring connection quality and activation funnels to behavior analytics. That’s why it’s critical for us that production data is transformed into clean, structured, analysis-ready datasets.
About the Role
We’re looking for a developer who will take ownership of processing and preparing analytical data. Your mission is to extract and transform data from the main database, preparing it for reports and decision-making.
You’ll write complex SQL queries, aggregate, filter, and group data, and set up daily jobs for synchronization and processing. You will build processes end-to-end — from raw sources to ready-to-use data structures.
Responsibilities
-
Daily processing and transfer of data from the production database.
-
Writing and optimizing complex SQL queries.
-
Data aggregation, filtering, and formatting.
-
Supporting and developing scripts for data transfer and processing.
-
Optimizing the performance of queries and routine tasks.
-
Collaborating with the backend team and business stakeholders to understand needs.
Requirements
-
Excellent knowledge of MySQL and ability to write efficient SQL queries.
-
Confident proficiency in PHP.
-
Experience working with large data volumes and complex joins.
-
Basic understanding of reporting systems or data warehouses.
-
Python is a big plus (for utilities and automation).
-
Ability to work independently and propose solutions.
What We Offer
-
Fully remote work format.
-
Direct product impact: your processes and scripts will power reports and decision-making.
-
Strong team and fast feedback cycles.
-
Opportunity to grow toward analytics engineering and performance optimization.
Dear Candidate,
Thank you for your interest in the Customer Support Specialist position at Yesim!
To move forward with your application, please answer the questions: https://docs.google.com/forms/d/e/1FAIpQLSf4sdfYYuZQQ7_S2TMd8cUkQLiwncCyC2CasymQ7iD8kKnx-g/viewform
⚠️ Important: To proceed, please complete a short questionnaire. Applications without answers will not be considered.
Ready to turn raw data into clear, actionable analytics? Apply now!