Business Intelligence Consultant

Bismart - Business Intelligence Consultant Role Bismart is a leading consulting firm specializing in Data Management and Analytics, recognized by Microsoft as a top Business Intelligence partner. Headquartered in Barcelona, we operate globally and are experiencing growth.

We are seeking a Senior Business Intelligence Consultant with expertise in Microsoft technologies (SSIS, SSRS / Power BI, SSAS) to join our expanding team of BI professionals.

Your Responsibilities : Design, develop, and maintain business intelligence solutions.

Present insights through reports and visualizations.

Work with Microsoft technologies, developing solutions using the SQL suite (SSIS, SSRS / Power BI, SSAS).

Translate business needs into technical specifications.

Develop and implement ETL processes (SSIS packages, process auditing, notifications, MDS, T-SQL).

Maintain and support data analytics platforms.

Evaluate and improve existing BI systems.

Create the Data Warehouse (DWH) layer, including staging and relational models.

Collaborate with teams to integrate systems.

Develop and execute database queries, perform analytics (cubes, dimensions, measures, KPIs, MDX, partitions, role security).

Create visualizations and reports (Power BI, Reporting Services, Excel pivot tables).

Develop and update technical documentation.

Perform functional analysis and gather requirements.

Maintain client interaction and follow Agile methodologies.

Administer Power BI Service and generate reports.

Work within a Cloud environment (Azure) and its components.

Requirements : Experience as a Microsoft BI Consultant.

Proven experience with SSIS, Power BI, SSAS, and SQL Server.

Strong data modeling skills (relational and dimensional).

Solid knowledge of SQL and ETL processes (SSIS, T-SQL, data integration).

Experience in requirements gathering and functional analysis.

Languages : Spanish and English.

Nice to Have : Knowledge of Azure.

What We Offer : Permanent contract.

Hybrid work model in Barcelona (2 days on-site, 3 days remote).

Annual certification plan with dedicated training hours.

#J-18808-Ljbffr