Senior BI Developer (Microsoft Stack)
Descrição da Empresa
Step into a dynamic ecosystem where the future of business is created and lived every day. Be part of it! At LUZA Group, passion, perseverance, and the drive to excel define our path to success. Founded in 2006, we are a Portuguese multinational with over 1,200 talented professionals and a turnover surpassing 30M. With a strong presence in key markets (Portugal, Spain, Morocco, Brazil, Mexico, the United States, and China) we deliver innovative solutions in engineering, IT, design, consulting, Industry 4.0, training, and recruitment. Our people and their talent power everything we do. This is a moment of growth and opportunity. The future belongs to visionary minds. Will you join us?
Descrição da Função
Job Title: Senior BI Developer (Microsoft Stack) Location: Lisbon, Portugal Work Regime: Full-time & Hybrid (2x office days) Overview / Summary: We are looking for a Senior Business Intelligence Specialist with extensive experience in the Microsoft SQL ecosystem, responsible for designing, developing, maintaining, and optimizing corporate BI solutions, ensuring data quality, performance, security, and reliability. Responsibilities and Tasks: Design, develop, maintain, and optimize corporate BI solutions, ensuring data quality, performance, security, and reliability across the Microsoft SQL ecosystem. Define end-to-end BI architectures and build complex data models using relational and dimensional modeling (Star Schema / Snowflake). Develop ETL/ELT processes with SSIS and analytical models with SSAS (Multidimensional and Tabular), including DAX and MDX. Create reports and dashboards in SSRS and Power BI, implementing security and access control (including RLS). Perform performance tuning and monitoring (SQL code, indexes, execution plans) and support Development, Testing, and Production environments. Produce technical documentation, enforce data governance, gather business requirements, translate them into technical solutions, and communicate with stakeholders. Participate in critical, high-complexity projects and provide technical leadership and mentoring.
Perfil
- Bachelor’s or Master’s degree in Computer Science, Engineering, Applied Mathematics, Data Science, or related fields
- +5 years of proven experience in BI projects
- Experience with Microsoft SQL Server (2016–2022)
- Advanced T-SQL skills (complex queries, optimization, tuning)
- Experience in relational and dimensional modeling (Star Schema / Snowflake)
- Proficiency in SSIS (ETL/ELT processes)
- Experience in SSAS (Multidimensional and Tabular)
- Proficiency in DAX and MDX
- Experience with SSRS and Power BI (modeling, dashboards, RLS)
- Strong knowledge of performance optimization and monitoring
- Experience in implementing security and access control
- Proven ability to support multiple environments (Development, Testing, Production)
- Strong communication skills with both technical and functional stakeholders
- Microsoft certifications in Data, BI, or Analytics (preferred)
- Experience in data governance and technical documentation
- Experience in high-complexity or critical BI projects
- Technical leadership and mentoring experience
Oferta
- Our company does not sponsor work visas or work permits. All applicants must have the legal right to work in the country where the position is based.
- Only candidates who meet the required qualifications and match the profile requested by our clients will be contacted.
Localização
- Largo Luís de Camões Piso 7, Oliveira de Azeméis, Aveiro, pt, 3720-232