Tasks

• Data modeling: designing and implementing efficient data models that support analytical requirements in Azure and Power BI.
• SQL and T-SQL: writing complex queries and using Transact-SQL (T-SQL) to retrieve, transform, and aggregate data from various sources.
• Carrying out performance optimization
• Problem-solving and troubleshooting

Requirements

• 12+ yrs of work experience
• ETL (Extract, Transform, Load): knowledge of ETL processes and tools, such as Azure Data Factory, to extract data from different sources, transform it to fit the desired data model, and load it into Azure data storage or Power BI.
• Azure services: Azure services related to data and analytics, including Azure SQL Database, Azure Data Lake, and Azure Synapse Analytics (formerly SQL Data Warehouse).
• Techniques to optimize data models, queries, and report performance to ensure efficient and responsive analytics.
• Strong problem-solving skills to identify and resolve issues related to data, queries, performance, or visualizations in Azure and Power BI.

Must have

• Security and governance: Understanding data security principles, implementing role-based access controls, and adhering to data governance policies when working with sensitive information.

Good to have

1. Power BI knowledge.
2. DAX (Data Analysis Expressions)
3. Jira working knowledge

Location: Stockholm (partially remote)

Duration: 5 Months

Capacity: 100%