> Markdown version of [/jobs/ext/10264-datamarts-engineer-developer](https://www.wearedevelopers.com/jobs/ext/10264-datamarts-engineer-developer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Datamarts Engineer & Developer - **Company:** GFT - **Location:** Madrid, Spain (Remote available) - **Contract:** Permanent contract - **Skills:** Microsoft Windows, Artificial Intelligence, Data Analysis, Microsoft Azure, Microsoft Outlook, Cloud Computing, Data Governance, Data Transformation, Data Visualization, Data Warehousing, Microsoft Visual Studio, Microsoft SQL Server, Object-Oriented Software Development, Performance Tuning, Power BI, Microsoft SharePoint, SQL Stored Procedures, Transact-SQL, Data Import/Export, Powerquery - **Published:** May 22, 2026 - **Apply:** https://www.opcionempleo.com/jobad/esf8006ba7cbdd67f164a571daa4db1ca6 ## About the Role * Power BI (Advanced): Service administration, governance, complex DAX, time intelligence. * SQL Server / Azure: Advanced T-SQL for data import, transformation, and set-based processing. * Data Modeling: TMDL, Tabular Object Model (TOM), advanced model management. * Performance optimization for T-SQL, Power BI semantic models, and DAX queries. * Data Governance and security best practices. Prefered Skills: * Experience with GIT and version control best practices. * Familiarity with Visual Studio Code. * Power Query / M for data transformation. * Integration with Microsoft 365 (Outlook, Teams, SharePoint). * Data visualization & storytelling skills. * Dashboard design for diverse stakeholders. Soft Skills: * Independent working style combined with strong teamwork. * Ability to translate business needs into BI models. * Strong abstraction and analytical skills for requirements and data modeling. * Clear communication with both technical and business audiences. * Technical documentation and organizational skills (agendas, sprints). * Proactive problem-solving and creativity. * Fast learning and adaptability. ## Description GFT Technologies is an AI-centric global digital transformation company. We design advanced data and AI business transformation solutions, modernize technology architectures and develop next-generation core systems for industry leaders in Banking, Insurance, Manufacturing and Robotics. Partnering closely with our clients, we push boundaries to unlock their full potential. We are looking for a Datamarts Engineer & Developer to join our BI/Data Warehouse team. This role focuses on enterprise data modeling, data analysis, and close collaboration with internal business departments to translate business needs into robust BI solutions. Report building is only a minor aspect-your main responsibility will be designing, optimizing, and managing data models and processes. Your main responsabilities will be: * Design and maintain enterprise data models and semantic layers. * Perform data analysis and collaborate with business stakeholders for requirements gathering. * Define and implement KPIs aligned with business objectives. * Develop and optimize Power BI datasets and semantic models. * Manage Power BI Premium Capacity, including: * Query cost management * Workspace administration & governance * Security & access control * Implement Row-Level Security (RLS) and data governance practices. * Optimize T-SQL queries, stored procedures, and DAX measures for performance. * Manage data dependencies, partitioning, and incremental refresh strategies. * Support and collaborate with key users of Power BI / Fabric. * Stay up-to-date with cloud technologies and adapt to evolving tools. ## Related Videos - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Spanish Business Culture and Etiquette](https://www.wearedevelopers.com/magazine/353-spanish-business-culture-and-etiquette)