BI, Data Warehouse Engineer – Azure, SSAS
Portugal
Full Time
3 weeks ago
No Sponsorship
Key skills
AzureCloudSQLPowerShellData WarehousingBIBusiness IntelligencePower BISnowflakeAzure DevOpsSQL Server
About this role
Role Overview
- Design, development, and optimisation of data warehouse solutions and analytical models
- Contributing to reporting and decision-making across the organisation
- Collaborating with teams to ensure high-quality semantic models for business intelligence
- Ensuring maintainable BI infrastructure with an Azure-centric approach
Requirements
- 5+ years of hands-on experience in data warehousing and BI engineering
- Cloud & DevOps expertise
- Azure Analysis Services — design, deployment, and administration
- Azure DevOps — pipeline management and version-controlled deployment workflows
- PowerShell scripting for automation and infrastructure management
- Solid data warehouse design experience — dimensional modelling, star/snowflake schemas
- SSAS Tabular Model — development and lifecycle management
- DAX — advanced measure and calculated column authoring
- SQL — complex querying, performance tuning, and data modelling
- SQL Server Management Studio (SSMS) proficiency
- Visual Studio / VSTS for BI solution development
- Familiarity with Tabular Editor for SSAS/Power BI model management
- DAX Studio for query analysis and optimisation
- SentryOne Plan Explorer for SQL query performance diagnostics
- MS Excel — advanced usage including PivotTables
- English fluency required — written and verbal
Tech Stack
- Azure
- Cloud
- SQL
Benefits
- Health insurance
- Flexible working arrangements
- Professional development opportunities