Data Solution Architect (Freelance)

Altamira Technlogies; City of London; On-site; GBP 60,000 - 80,000; Full time

Job summary

A software development outsourcing company is seeking an experienced Freelance Data Solution Architect to optimize their core data infrastructure. You will analyze data structures, identify bottlenecks, and refactor solutions for enhanced performance. Ideal candidates should have strong SQL skills, experience with BI tools like Sisense, and familiarity with AWS services. This role offers competitive salary and flexible work options including remote work.

Benefits

Competitive salary

Possibility to work remotely

Medical insurance (optional)

English courses

Technical equipment provided

Paid vacations 20 workdays

Paid sick leave

Flexible schedule

Support for personal growth

Great team environment

Qualifications

• Ability to write and optimize complex, high-load SQL queries.
• Experience in schema design, refactoring legacy databases.
• Strong ability to design scalable architecture for complex analytics.
• Understanding of core business metrics (KPIs) and analytical outputs.
• Hands-on experience with Sisense or comparable BI tools.
• Familiarity with AWS services relevant to data management.
• Experience stabilizing legacy data warehouses.

Responsibilities

• Analyze data structures and reporting logic across databases.
• Identify performance bottlenecks and architectural weaknesses.
• Refactor and optimize solutions for enhanced scalability.

Skills

SQL Expert Level

Database Administrator

Solution Architecture

Data Analysis Skills

BI Tooling

AWS Experience

Legacy Stabilization

Tools

Sisense

Power BI

Tableau

AWS RDS

AWS Redshift

AWS Glue

AWS Lambda

AWS S3

AWS IAM

Job description

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.

Data Solution Architect (Freelance)

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.

Responsibilities

• 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.

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 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!

Recruitment Process

• 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

Benefits

• 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

Seniority level

• Mid‑Senior level

Employment type

• Full‑time

Job function

• Engineering and Information Technology