Senior Data Analyst

Role: Senior Data Analyst
Job Ref Id: JD-1312
Competence level: senior
Start date:
End date:
Extension option: Yes
Scope: 100%
Location: Malmo
Remote work: In-office
Language: English
Application deadline:
Number of consultants: 1
Security clearance: No

About the assignment

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

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 2030% 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.