Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyse and optimise data structures for enhanced performance and scalability.
- Company: Join Altamira, a forward-thinking software development outsourcing company.
- Benefits: Competitive salary, flexible hours, remote work, and opportunities for personal growth.
- Why this job: Make a real impact by optimising data solutions in a dynamic environment.
- Qualifications: Expertise in SQL, database administration, and BI tooling required.
- Other info: Collaborative team culture with support for your initiatives and career development.
The predicted salary is between 48000 - 84000 £ per year.
Altamira is a software development outsourcing company that provides solutions making a tangible impact on our client's growth and productivity. We aim to provide cost-efficient solutions without compromising quality, driven to deliver the best every single time. Our service delivery teams currently span Slovakia, Ukraine, and the Middle East, with ambitions to expand across Europe and into primary growth markets in the UK and the US. We focus on industry verticals such as EdTech, Fintech, eCommerce, and Pharma.
We operate a secure, real-time platform critical for managing educational and social services, providing real-time attendance tracking, managing personal education plans, and facilitating secure data sharing among social workers, teachers, and local authorities. We prioritize data security, compliance, and granular role-based access, trusted by over 100 local authorities. We are committed to innovation, with future enhancements including mobile app accessibility, integrating AI-driven insights, and developing automated support features.
We are currently looking for an experienced Data Solution Architect to join us on a freelance (B2B) basis to optimize our core data infrastructure as we prepare for significant scaling and feature expansion.
Responsibilities:- Analysis & Diagnostics: Analyze the current state of data structures and reporting logic across both our production databases and our Sisense BI environment.
- Bottleneck Identification: Identify performance bottlenecks, data model inconsistencies, and architectural weaknesses within the existing system.
- Refactoring & Optimization: Refactor and optimize the existing solution by applying database-level improvements, adjusting Sisense models, and strategically relocating specific logic from the Sisense layer back to the database.
Your mission will be to significantly improve the performance and scalability of our analytical systems.
Requirements:- SQL Expert Level: Ability to write and optimize complex, high-load queries, implement advanced performance tuning, and define effective indexing strategies.
- Database Administrator: Proven experience in schema design, refactoring legacy databases, normalization/denormalization, and using advanced features like materialized views and partitioning.
- Solution Architecture: Strong ability to define where logic optimally belongs (DB vs. BI vs. ETL) and design the right scalable architecture to support complex analytics.
- Data Analysis Skills: Ability to understand core business metrics (KPIs), map relationships between domain objects, and validate the correctness of analytical outputs.
- BI Tooling: Hands-on experience with Sisense or proven experience in a comparable enterprise BI tool's semantic modeling capabilities (e.g., Power BI/Tableau).
- AWS Experience: Familiarity with services such as RDS, Redshift, Glue, Lambda, S3, IAM.
- Legacy Stabilization: Direct experience stabilizing legacy data warehouses, fixing performance regressions after major releases, and introducing proper data marts or star schemas.
- Recruiting Interview → 30–45 min
- Technical Interview → 1–1.5h
- Client Interview (optional) → up to 1h
- Pre-Offer Call → 15min
- Reference Check
- Offer
- Competitive salary, room for development and growth.
- Possibility to work in the Bratislava and Kyiv office or fully remotely.
- Loyal management, interesting tasks, constant support.
- Medical insurance (optional).
- English courses.
- Technical equipment provided.
- Paid vacations (20 workdays), paid sick leave, regular salary reviews.
- Flexible schedule and ability to manage your working hours.
- Support for personal growth and skills upgrading.
- A great environment inside the team, support of initiatives, and ability to contribute to the common goal.
The success of altamira.ai is inseparable from the success of our Talents and the success of our Clients!
Data Solution Architect (Freelance) in City of London employer: Altamira
Contact Detail:
Altamira Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Solution Architect (Freelance) in City of London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage in online forums. We all know that sometimes it’s not just what you know, but who you know that can land you that freelance gig.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your past projects and successes. We recommend including case studies that highlight how you’ve optimised data solutions in previous roles. This will give potential clients a taste of what you can bring to the table.
✨Tip Number 3
Prepare for those interviews! Brush up on your SQL and database management skills, and be ready to discuss your approach to solving complex data challenges. We want you to feel confident and ready to impress during the technical interview.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who take the initiative to connect directly with us.
We think you need these skills to ace Data Solution Architect (Freelance) in City of London
Some tips for your application 🫡
Tailor Your Application: Make sure to customise your CV and cover letter for the Data Solution Architect role. Highlight your SQL expertise and experience with BI tools like Sisense, as these are key to what we’re looking for.
Showcase Your Experience: Don’t just list your skills; give us examples of how you’ve used them in real projects. Talk about your successes in optimising data structures or refactoring legacy databases – we love a good success story!
Be Clear and Concise: Keep your application straightforward and to the point. We appreciate clarity, so avoid jargon unless it’s necessary. Make it easy for us to see why you’re the perfect fit for our team.
Apply Through Our Website: We encourage you to submit your application directly through our website. It’s the best way for us to receive your details and ensures you’re considered for the role without any hiccups!
How to prepare for a job interview at Altamira
✨Know Your Data Inside Out
Before the interview, dive deep into your understanding of data structures and reporting logic. Be ready to discuss specific examples of how you've optimised complex queries or refactored legacy databases. This will show that you not only have the skills but also the practical experience to back them up.
✨Showcase Your Problem-Solving Skills
Prepare to talk about past experiences where you've identified performance bottlenecks or architectural weaknesses. Use the STAR method (Situation, Task, Action, Result) to structure your answers, making it clear how your actions led to tangible improvements in data performance.
✨Familiarise Yourself with Their Tech Stack
Research Altamira's use of Sisense and any other BI tools they might be using. If you have experience with similar tools like Power BI or Tableau, be ready to draw parallels and discuss how your skills can translate to their environment.
✨Emphasise Your Adaptability
As a freelance Data Solution Architect, you'll need to demonstrate your ability to adapt to different projects and client needs. Share examples of how you've successfully navigated changes in project scope or technology, highlighting your flexibility and commitment to delivering quality solutions.
