Data Engineer - Microsoft BI Specialist

About the role

knowmad mood, a digital transformation company with more than 3,000 professionals, is hiring a Data Engineer / Microsoft BI Specialist for its Community Big Data department in Madrid. The position is full-time and hybrid, with two days per week in the Madrid office.

Key responsibilities

• Develop and maintain Business Intelligence and Data Warehouse solutions.
• Design and optimize SQL Server databases, including T-SQL, stored procedures, views and indexes.
• Develop and maintain ETL/ELT processes, OLAP cubes and reporting solutions.
• Integrate data from multiple sources and troubleshoot data quality, performance and integration issues.
• Develop reports and dashboards using SSRS and Tableau.
• Manage deployments across development, integration, QA and production environments.

Required profile

• Experience developing and maintaining BI and Data Warehouse solutions.
• Fluent English.
• Nice to have: C#/.NET and PostgreSQL, Apache Spark, Kafka, Parquet and Hadoop, source control and release management, and Tableau experience.

Required skills

• Strong knowledge of SQL Server, T-SQL, Oracle and PL/SQL.
• Hands-on experience with SSIS, SSAS, OLAP Cubes, SSRS and ETL processes.

What we offer

• Hybrid work model (2 days per week in the Madrid office).
• Internal training and access to professional certifications.
• Flexible benefits plan (private health insurance, transportation allowance, childcare and meal vouchers).
• Referral program with extra rewards.
• Events, meetups, Tech Days and talks.
• 26 days off per year (22 vacation days, 2 personal days, plus company holidays on Dec 24 and 31).
• Flexible working hours: 8-hour day throughout the year.