Senior Data Analyst

Aqilea

Malmö kommun

On-site

SEK 900,000 - 1,200,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Aqilea in Malmö seeks a Senior Data Analyst to strengthen end-to-end BI delivery. You will design semantic models, optimize DAX, and build scalable data transformations using SQL, Python, and PySpark within Microsoft Fabric.

Role focuses on governance, reusable analytics assets, and franchisee reporting across retail datasets, with a strong user-focused reporting mentality.

Qualifications

  • Minimum six years of BI/analytics engineering or data engineering experience.
  • Extensive Power BI experience with enterprise governance and reusable models.
  • Advanced DAX skills including time intelligence and performance optimization.
  • Strong dimensional modeling with star schemas and relationships.
  • Power Query (M) and data transformation capabilities.
  • Hands-on Fabric Lakehouse/Warehouse and data pipelines expertise.
  • SQL proficiency for analytics, data transformation, validation.
  • Python and PySpark for data processing in Fabric or Databricks.
  • Knowledge of Delta Lake and modern data-platform patterns.
  • Understanding of Direct Lake/DirectQuery/Import models.
  • Experience with data-product principles, data contracts, and CI/CD.
  • Security governance: RLS/OLS and governed self-service analytics.
  • Retail domain knowledge: sales, POS, products, stores, markets.
  • Ability to translate business requirements into reliable measures.

Responsibilities

  • Design, develop and maintain Power BI reports, dashboards, and datasets.
  • Develop advanced DAX measures, calculations, and semantic models.
  • Translate business requirements into scalable analytical models and insights.
  • Create dimensional data models (star schemas, facts, dimensions).
  • Build data transformations with SQL, Python, and PySpark in Fabric.
  • Utilize Fabric features like Lakehouse, Data Pipelines, and Dataflows Gen2.
  • Develop reusable, governed analytics components and data products.
  • Ensure data quality, security, and performance across reports.
  • Support reporting migration, legacy requirements, and testing.
  • Collaborate with SSDP and stakeholders; share documentation.

Skills

Power BI
DAX
Data modeling
SQL
Python
PySpark
Fabric
Delta Lake
Data contracts
CI/CD
Security & governance
Retail analytics

Tools

Fabric Lakehouse
Data Pipelines Gen2
Power BI Service
Direct Lake
Microsoft Fabric Notebooks

Job description

About The Assignment We are looking for a Senior Data Analyst to our client in Malmö.

Role: Senior Data Analyst

Job Ref Id: JD-1312

Competence level: senior

Start date: 2026-11-15

End date: 2027-08-31

Extension option: Yes

Scope: 100%

Location: Malmo

Remote work: In-office

Language: English

Application deadline: 2026-11-06

Number of consultants: 1

Security clearance: No

Responsibilities
  • The scope of the consultant services is to assist client in:
  • Strengthening end-to-end Business Insights delivery using Power BI and Microsoft Fabric.
  • Designing governed, reusable semantic models and consumption-ready analytical solutions.
  • Developing and optimizing complex DAX calculations, measures, and analytical models.
  • Building scalable data transformations and analytical processing solutions using SQL, Python, and PySpark.
  • Supporting reporting migration, CORE-related delivery, franchisee reporting, and self-service enablement.
  • Translating retail business requirements into meaningful KPIs, reporting solutions, and actionable insights.
  • Contributing to SSDP Gold-layer, certified semantic model, and governed-consumption standards.
  • Improving data quality, performance, documentation, and knowledge sharing across Business Insights and SSDP.
  • The main tasks in the assignment are as below:
  • Design, develop, and maintain Power BI reports, dashboards, semantic models, and analytical datasets.
  • Develop and optimize advanced DAX measures, calculated tables, and business calculations.
  • Translate business requirements into scalable analytical models, measures, reports, and actionable insights.
  • Design and implement dimensional data models, including star schemas, fact tables, dimensions, and relationships.
  • Develop data transformation and processing solutions using SQL, Python, and PySpark, particularly within Microsoft Fabric.
  • Use Microsoft Fabric capabilities, including Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, notebooks, and semantic models.
  • Build scalable and reusable analytical models aligned with governed data-product principles.
  • Analyze retail business data covering sales, transactions, products, customers, stores, markets, and franchisee performance.
  • Develop and maintain retail KPIs, including sales performance, transaction volumes, average transaction value, basket analysis, product performance, and comparable sales.
  • Improve report performance, usability, data quality, security, and maintainability.
  • Optimize Power BI semantic models, DAX queries, refresh performance, and Direct Lake or DirectQuery configurations.
  • Establish standardized reporting practices, reusable components, and common data-modeling standards.
  • Support legacy reporting migration, CORE-related reporting requirements, and historical data validation.
  • Support testing, validation, release preparation, stakeholder demonstrations, documentation, and onboarding.
  • Collaborate with SSDP to establish consumption-ready patterns, including Gold-layer standards, certified semantic models, and Direct Lake usage.
  • Support franchisee onboarding, governed self-service analytics, and report access management.
  • Work closely with business stakeholders to understand retail processes and ensure reporting solutions provide relevant business insights.
  • Share knowledge, coach colleagues, and establish reusable documentation to reduce single-person dependencies.
Requirements
Mandatory
  • Experience: Minimum six years of relevant experience in BI, analytics engineering, or data engineering.
  • Power BI: Extensive hands-on experience designing and developing enterprise Power BI solutions, including report design, workspace management, reusable and certified semantic models, and governed self-service analytics.
  • DAX: Advanced DAX skills, including complex business calculations, filter and row context, time intelligence, calculation groups, and performance optimization.
  • Data Modeling: Strong experience with dimensional modeling, star schemas, fact and dimension tables, relationships, cardinality, and semantic-model optimization.
  • Power Query: Experience with Power Query, M language, and data transformation.
  • Microsoft Fabric: Hands-on experience with Fabric Lakehouse, Warehouse, Data Pipelines, Dataflows Gen2, and notebooks, or strong Power BI and Azure data-platform experience with the ability to become productive in Fabric quickly.
  • SQL: Strong SQL proficiency for analytical queries, data transformation, troubleshooting, and validation.
  • Python and PySpark: Practical experience developing data processing and transformation solutions using Python and PySpark, preferably within Microsoft Fabric or Databricks.
  • Data Architecture: Experience with Delta Lake, data lake architecture, Bronze/Silver/Gold data-layer patterns, and modern data platforms such as Databricks, Azure Data Lake, and Azure Data Factory.
  • Storage Modes: Understanding of Direct Lake, DirectQuery, and Import models, including their architectural and performance considerations.
  • Analytics Engineering: Experience building reusable, version-controlled, testable, and maintainable analytical assets, including Git integration, CI/CD, deployment pipelines, data-product principles, and data contracts.
  • Security and Governance: Experience with row-level security (RLS), object-level security (OLS), access control, and governed self-service analytics in Power BI and Fabric.
  • Performance and Quality: Proven experience with report and semantic-model performance optimization, data validation, and reliable analytical solution design.
  • BI Modernization: Experience with enterprise BI migration and reporting modernization.
  • Retail Business Knowledge: Good understanding of retail operations, sales and POS transactions, product and store hierarchies, markets, customer data, and reporting requirements.
  • Retail Analytics: Experience with retail transaction analysis, market basket analysis, sales trends, and KPIs such as net sales, gross sales, transaction count, average transaction value, basket size, product performance, and comparable sales.
  • Multi-Market Retail: Understanding of multi-market retail operations, franchisee reporting, and consistent KPI definitions across business entities.
  • Business Engagement: Ability to translate retail business requirements and terminology into reliable analytical measures and reporting solutions, and communicate effectively with business and technical stakeholders.
  • Collaboration: Experience working in agile, cross-functional teams, with strong documentation, communication, and knowledge-sharing skills.
  • Cross-Team Contribution: Ability and willingness to contribute across Business Insights and SSDP, with approximately 20–30% allocation to the secondary team as required.
  • Adaptability: Comfortable working in a platform-building environment where standards and processes are evolving.
Nice-to-have
  • Familiarity with customer loyalty, retention, segmentation, and customer behavior analytics is an advantage.
  • Relevant Microsoft certifications, such as PL-300 or DP-600, are an advantage.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analyst/ PowerBI
Senior Data Analyst/ PowerBI

Swediumglobal • Stockholms kommun

On-site
SEK 45,000 - 65,000
Senior Analytics Engineer, Power BI & Fabric
Senior Analytics Engineer, Power BI & Fabric

Avaron AB • Malmö kommun

On-site
SEK 700,000 - 900,000
Permanent employment at Avaron AB
Occupational pension
Wellness allowance SEK 5,000 per year
Data Business Analyst
Data Business Analyst

Rasulson Consulting • Albacken

On-site
SEK 540,000 - 900,000
Senior Data Analyst
Senior Data Analyst

Swediumglobal • Göteborgs kommun

On-site
SEK 700,000 - 950,000
Junior Power BI and Fabric Developer
Junior Power BI and Fabric Developer

Nordic Investin Group Aktiebolag • Stockholms kommun

On-site
SEK 420,000 - 540,000
Senior Data Analyst
Senior Data Analyst

Trust in SODA • Göteborgs kommun

Hybrid
SEK 600,000 - 800,000
Data Scientist
Data Scientist

Aqilea • Stockholms kommun

Hybrid
SEK 900,000 - 1,300,000
Senior Data Engineer
Senior Data Engineer

Techrytera • Stockholms kommun

On-site
SEK 669,600 - 892,800
Business Analyst/Data Analyst
Business Analyst/Data Analyst

Techrytera AB • Göteborgs kommun

On-site
SEK 520,000 - 780,000
Senior BI Developer
Senior BI Developer

Red Commerce Schweiz GmbH • Sweden

Remote
SEK 900,000 - 1,200,000