Data Solution Architect (Freelance)

Altamira.ai; United Kingdom; Remote; GBP 60,000 - 90,000; Part time

Job summary

A software development outsourcing company in the UK is looking for a Data Solution Architect (Freelance B2B) to optimize their core data infrastructure. The ideal candidate will have expertise in SQL, database administration, and BI tools like Sisense. Responsibilities include analyzing data structures and improving performance. Benefits include a competitive salary, flexible schedule, and remote work options.

Benefits

Competitive salary

Possibility to work remotely

Medical insurance (optional)

Paid vacations (20 workdays)

Support for personal growth

Qualifications

• Ability to write and optimize complex, high-load SQL queries.
• Proven experience in schema design and normalization.
• Strong skills to define optimal data logic architecture.
• Understand core business metrics and validate analytical outputs.
• Hands-on experience with enterprise BI tools semantic modeling.
• Familiarity with AWS services such as RDS and Redshift.
• Experience stabilizing legacy data warehouses.

Responsibilities

• Analyze current data structures and reporting logic.
• Identify performance bottlenecks and inconsistencies.
• Refactor and optimize existing solutions.
• Improve performance and scalability of analytical systems.

Skills

SQL Expert Level

Database Administrator

Solution Architecture

Data Analysis Skills

BI Tooling

AWS Experience

Legacy Stabilization

Tools

Sisense

Power BI

Tableau

AWS Services

Job description

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 service delivery teams currently span Slovakia, Ukraine, and the Middle East, and we have ambitions to expand our footprint to meet the growing demand across Europe and into our primary growth markets in the UK and the US. In terms of industry verticals, we are focused 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, which is why we are trusted by over 100 local authorities.

We are committed to innovation. Future enhancements include expanding to mobile app accessibility, integrating AI‑driven insights, and developing automated support features.

Data Solution Architect (Freelance B2B) to optimize our core data infrastructure as we prepare for significant scaling and feature expansion.

Responsibilities

• Analyze the current state of data structures and reporting logic across both our production databases and our Sisense BI environment.

• Identify performance bottlenecks, data model inconsistencies, and architectural weaknesses within the existing system.

• 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, where it can provide superior scalability and performance.

• Significantly improve the performance and scalability of our analytical systems.

Requirements

• SQL Expert Level: Must have the 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 reliably 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 semantic models, cubes).

• AWS Experience: Familiarity with any of the following services: RDS, Redshift, Glue, Lambda, S3, IAM.

• Legacy Stabilization: Direct experience stabilizing legacy data warehouses, fixing performance regressions after major releases, refactoring aging data 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!

Recruitment Journey

• Technical Interview -> 1‑1.5 h
• Client Interview (optional) -> up to 1 h
• Pre‑Offer Call -> 15 min
• Reference Check
• Offer

We 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)
• Technical equipment providing
• Paid vacations 20 workdays, paid sick leave, regular salary reviews
• Flexible schedule and ability to manage your working hours
• Support your personal growth and skills upgrading
• The great environment inside the team, support of initiatives, and ability to contribute to the common goal