Information Technology jobs in United Kingdom

Join to apply for the Data Solution Architect (Freelance) role at Altamira

Altamira is a software development outsourcing company. We provide solutions that make a tangible impact on our client's growth and productivity. With domain knowledge across product and technology development, we aim to provide cost‑efficient solutions without compromising quality. We are driven to deliver the best, every single time. Altamira’s service delivery teams span Slovakia, Ukraine, and the Middle East, with ambitions to expand across Europe and into the UK and US. We focus on EdTech, Fintech, eCommerce, and Pharma.

We operate a secure, real‑time platform critical for managing educational and social services. Our platform provides real‑time attendance tracking, manages personal education plans, and facilitates 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. Future enhancements include mobile app accessibility, AI‑driven insights, and automated support features.

We are looking for an experienced Data Solution Architect to join us on a freelance (B2B) basis and optimize our core data infrastructure as we prepare for significant scaling and feature expansion.

• Analysis & Diagnostics: Analyze the current state of data structures and reporting logic across 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 to enhance scalability and performance.

• 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 scalable architecture to support complex analytics.
• Data Analysis Skills: Understand core business metrics (KPIs), map relationships, and validate analytical outputs.
• BI Tooling: Hands‑on experience with Sisense or comparable enterprise BI semantic modeling (Power BI, Tableau, etc.).
• AWS Experience: Familiarity with RDS, Redshift, Glue, Lambda, S3, IAM.
• Legacy Stabilization: Experience stabilizing legacy data warehouses, fixing performance regressions after releases, refactoring aging models, and introducing proper data marts or star schemas.

The success of altamira.ai is inseparable from the success of our Talents and the success of our Clients!

• Recruiting Interview – 30‑45 min
• Technical Interview – 1–1.5 h
• Client Interview (optional) – up to 1 h
• Pre‑Offer Call – 15 min
• Reference Check
• Offer

• Competitive salary, room for development and growth
• Possibility to work in Bratislava, 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
• The great environment inside the team, support of initiatives, and ability to contribute to a common goal

• Mid‑Senior level

• Full‑time

• Engineering and Information Technology