FlexSolution

FlexSolution is seeking a Data Analyst with strong SQL skills and experience working with databases to join our team. Your main tasks will include analyzing database structures, understanding business needs, and writing complex SQL queries to generate reports and insights.

About the project: 

We are building the solution for one of the biggest developers of electricity lines (construction field) in the USA. The solution consists of many components required for different needs like signing tailboards, tracking spent time by workers, punch lists management, scheduling tasks/projects, document management, generating reports, etc. The UI components (services) have been written with Angular 1, Angular 2+, and React, which communicate with the backend over the REST API. There is no fancy UI as it is an enterprise project, mostly our UI is the collection of tables and forms.

What will you do:

✔ Analyze database structures and understand business requirements

✔ Write complex SQL queries to extract and process data

✔ Develop analytical reports to support decision-making

✔ Collaborate with development teams and business analysts

✔ Optimize queries for better performance

Requirements:

🔹 Strong experience in writing complex SQL queries (CTEs, joins, window functions, etc.)

🔹 Understanding of relational databases and data modeling principles

🔹 Analytical mindset and ability to work with large datasets

🔹 English level B2+ (for communication verbal and documentation)

🔹 Curiosity and willingness to deep dive into data to uncover insights

Nice to Have:

➕ Experience with BI tools (Tableau, Power BI, etc.)

➕ Experience working with cloud databases (BigQuery, Snowflake, AWSRDS)

Team:

—PM x1

— Group lead x3

— Frontend dev x3

— Backend dev x3

— QA x3

— DevOps x1

Interview stages:

— HR interview

— Tech/ PM interview

We offer:

— Full remote with flexible business hours;

— Three weeks of vacation per year (15 working days);

— Paid sick leave per year (5 working days);

— Amazing opportunities for professional growth within a top-notch team of professionals;

— Competitive compensation commensurate with your experience and skills;

— English l lessons;

— Co-working compensation;

— An excellent team with a friendly atmosphere.

We are looking for candidates with strong backend engineering experience, particularly in Ruby, AWS, and Terraform, to contribute to the ongoing enhancement of a key data reporting and analytics module. The work involves building data visualisation and reporting features that will provide deeper insights into physical performance metrics and
trends. This is a fully remote role, though candidates must be available during UK business hours (GMT/BST). Occasional travel may be required.

About the Project:
The engineers will be working on enhancing a newly released data reporting and
visualisation module. The module has been in development for two years and is now in a
phase where iterative improvements can deliver significant value with relatively low effort.

The engineering team follows SCRUM methodologies and is well-established, consisting of
Backend, Frontend, Product, Design, and QA professionals. Engineers will be paired with a
buddy for onboarding, and development processes are mature and well-documented.

The focus will be on:

• Enhancing and expanding API capabilities
• Optimising data processing and pipelines
• Improving data visualisation and reporting features
• Ensuring robust security and compliance standards
•  

Technical Requirements:

• Ruby (5+ years) — Proficiency in backend development using Ruby
• AWS (5+ years) — Strong cloud infrastructure experience
• MySQL (5+ years) — Database design and optimisation
• Terraform (2+ years) — Infrastructure as Code experience
• API Development — Experience designing and maintaining RESTful APIs
• Security & Compliance Awareness — Experience working in a business following audited security practices (e.g. ISO27001)

Soft Skills:

• Ability to work independently yet collaboratively
• Experience working within a mature engineering culture
• Comfortable working in a matrix management structure
• Strong problem-solving skills and a user-focused mindset

Responsibilities:

• Design, build, and maintain scalable backend services, APIs, and databases
• Collaborate with frontend engineers to deliver end-to-end features
• Support data scientists in implementing data processing models
• Ensure security best practices, including data encryption and authentication/authorisation
• Maintain and enhance AWS infrastructure using Terraform
• Participate in code reviews, ensuring high standards and maintainability
• Debug production issues across multiple layers of the stack
• Improve engineering processes, tooling, and deployment pipelines

Success Criteria:

Efficient Feature Delivery — Enhancing the reporting module with minimal defects
Stable & Scalable Code — Writing tested, maintainable, and efficient backend services
Strong Security Practices — Adhering to security standards and best practices
Smooth CI/CD Process — Contributing to a reliable and automated deployment pipeline

Working Practices:

• Current team of 9 consisting of Product, Design, QA, Front and Back End engineers, including Team Lead
• Buddy to be provided. Onboarding well documented
• Agile development practices, with Scrum methodology
• Daily standups (15 mins)
• Weekly backlog review (1hr)
• Weekly sprint planning (1 hr)
• Biweekly sprint demos (1 hr)
• Biweekly retros (1hr)

Additional Information:

Travel: Potentially travel to the client’s HQ (UK), 1-2 times per year. Travel and accommodation costs will be covered separately.

Laptop & Equipment: Provided post-verification.

Onboarding: Comprehensive onboarding process including security training and development environment setup.Tooling: Jira, Slack, Github, Google Workspace

Assessment Process:

1. CV & Code Review — Evaluating experience and relevant projects
2. Initial Technical Interview (20 mins) — Focused on experience and background
3. Technical Assessment — Format and duration to be agreed with the client
4. Final Interview with Client — Soft skills and cultural fit assessment

What We Offer:

• Full remote with flexible business hours;
• Two weeks of vacation per year (10 working days), next year 15 working days;
• Paid sick leave per year (5 working days);
• Amazing opportunities for professional growth within a top-notch team of professionals;
• Competitive compensation commensurate with your experience and skills;
• English lessons;
• Co-working compensation;
• An excellent team with a friendly atmosphere.