Requirements: English
Company: Bismart, Business Intelligence Specialist Services
Region: Barcelona , Catalonia
Bismart is a leading consulting firm in its sector, offering business solutions based on technology, specializing in Data Management and Analytics. We have been recognized by Microsoft as the best Business Intelligence partner and a preferred Power BI partner.
We help organizations maximize the value of their data. Our headquarters is located in Barcelona, from where we operate globally.
We are in a growth phase and are looking to onboard professionals who can contribute to the organizations organic expansion and help drive even more exponential growth.
Were Looking for a Business Intelligence Consultant!
We are expanding our team of Microsoft BI experts! If you think youre the right fit for this role, dont hesitate to reach out.
Are you ready to take on a new professional challenge working with cutting-edge business intelligence technologies?
Do you want to grow in an international, dynamic, and flexible environment?
We are looking for you!
Were seeking a Senior Business Intelligence Consultant with experience in Microsoft technologies (SSIS, SSRS/Power BI, SSAS).
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 DWH layer (DWH layer, staging layer, BI relational models).
- Collaborate with teams to integrate systems.
- Develop and execute database queries and perform analytics (analytical databases: cubes, dimensions, measures, KPIs, actions, MDX, partitions, role security).
- Create visualizations and reports for requested projects (Reporting Services reports, Power BI, and/or Excel pivot tables).
- Develop and update technical documentation.
- Perform functional analysis and requirements gathering.
- Maintain direct client interaction and follow Agile methodologies.
- Administer Power BI Service and generate reports.
- Work in a Cloud environment (Azure) and its components.
Requirements:
- Experience as a Microsoft Business Intelligence Consultant.
- Proven experience with SSIS, Power BI, SSAS, and SQL Server.
- Strong experience in data modeling (both relational and dimensional models).
- Solid knowledge of SQL and ETL processes (SSIS, T-SQL, process auditing, data integration).
- Experience in requirements gathering and functional analysis.
- Languages: Spanish and English.
Nice to Have:
What we offer
- Permanent contract.
- Flexible schedule.
- Hybrid work model if based in Barcelona (2 days on-site, 3 days remote).
- Excellent work environment.
- Annual certification plan with dedicated training hours during work hours.
- Professional development plan.
- Work with the latest technologies.