Caixa Mágica Software
Caixa Mágica Software
Caixa Mágica Software develops custom IT solutions with a focus on open-source technologies and human-centred software. Its work spans software engineering, UX/UI design, research and development, and artificial intelligence, supporting projects across mobile, desktop, web, and automotive environments. With more than two decades of experience, the company also provides nearshore staffing services, connecting businesses with European technology professionals. Its expertise serves organisations across consulting, logistics, and manufacturing.

Senior BI Developer, Caixa Mágica Software (Hybrid, Lisbon)

Build complex SQL solutions, star-schema models, and Power BI applications for Caixa Mágica Software. Improve data warehouse performance using DAX, Tabular Models, Git, and SSDT.

Description

  • Contribute data and BI expertise to a long-term project
  • Develop solutions using complex SQL
  • Improve SQL query performance
  • Create star schemas and use advanced data modeling when appropriate
  • Work with data warehouses, preferably Dedicated SQL Pools
  • Build with Power BI, DAX, Tabular Models, Git, and SSDT
  • Implement business logic produced in C#

Requirements

  • Bring at least 10 years of BI experience
  • Demonstrate strong SQL expertise
  • Understand SQL engine behavior and query performance optimization
  • Be able to discuss and resolve complex SQL challenges
  • Model data using star schema design
  • Know when advanced data modeling approaches are needed
  • Have experience with data warehouse environments, preferably Dedicated SQL Pools
  • Have experience using Git
  • Have experience with Power BI, DAX, Tabular Models, and SSDT (SQL Server Data Tools)
  • Have basic knowledge of C#

Benefits

  • Permanent employment on a long-term project
  • Technology equipment, a SIM card, and a personal smartphone
  • Health and life insurance
  • Social events and team-building activities
  • Support for your growth, with rewards aligned to your development
  • A supportive, dynamic team
  • Training in current technologies
  • Coffee, fruit, snacks, and a warm welcome when visiting the office

Related Jobs

No jobs found

Try adjusting or clearing your filters to find more opportunities.