Data Solution Architect (Freelance)

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.

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, where it can provide superior scalability and performance. As our Data Solution Architect, your mission will be to significantly improve the performance and scalability of our analytical systems:

Requirments

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

Our transparent recruitment journey usually takes up to 2 weeks and includes a few stages:

• Recruiting Interview -> 30-45 min

• Technical Interview -> 1-1,5h

• Client Interview (optional) -> up to 1h

• Pre-Offer Call -> 15min

• Reference Check

• Offer

We offer:

• Competitive salary, room for development and growth.

• Possibility to work in the Bratislava and Kyiv offices or fully remotely.

• Loyal management, interesting tasks, constant support.

• Medical insurance (optional).

• English courses.

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

We do believe that the success of altamira.ai is impossible without the success of our Talents and the success of our Clients!