Senior Data Analyst

DataSmart

Porto

Hybrid

EUR 45,000 - 65,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

DataSmart, a Portuguese consulting company with over 20 years of experience, seeks a Senior Data Analyst for a hybrid Porto-based role. You will translate business requirements into scalable Power BI and Microsoft Fabric solutions, design enterprise reports, and develop KPI frameworks using DAX.

You will manage Power BI environments, implement Row-Level Security, and collaborate with Data Engineering teams to deliver secure, scalable analytics across geographies.

Qualifications

  • Strong hands-on experience with Power BI Desktop, Power BI Service, DAX, and semantic modelling.
  • Solid SQL and Power Query/M skills.
  • Proven experience with star-schema, fact, and dimension modelling.
  • Experience managing enterprise Power BI environments, including Workspaces, Apps, gateways, and Deployment Pipelines.
  • Experience implementing Row-Level Security and applying BI governance, security, and enterprise delivery standards.
  • Hands-on experience with Microsoft Fabric, particularly OneLake, Lakehouse, Warehouse, and Data Factory.
  • Proven ability to troubleshoot and optimize Power BI and Fabric solutions for performance and scalability.
  • Strong communication, stakeholder management, and problem-solving skills.
  • Ability to work effectively with technical teams and business stakeholders.

Responsibilities

  • Translate business requirements into scalable Power BI and Microsoft Fabric solutions.
  • Design and maintain enterprise Power BI reports, dashboards, and semantic models following best practices.
  • Develop metrics and KPI frameworks using advanced DAX.
  • Manage Power BI Service environments, including Workspaces, Apps, gateways, refreshes, semantic models, and Deployment Pipelines.
  • Implement Row-Level Security and appropriate access controls.
  • Optimize Power BI reports and semantic models for performance, scalability, and usability.
  • Design Microsoft Fabric solutions using OneLake, Lakehouse, Warehouse, and Data Factory pipelines.
  • Ingest and transform data from SQL databases, APIs, cloud platforms, and flat files.
  • Support data governance, data quality, lineage, monitoring, testing, and release management.
  • Collaborate with Data Engineering and Data Platform teams to deliver secure and scalable analytical solutions.
  • Work closely with business stakeholders across different business areas and geographies.
  • Review technical solutions and mentor other analysts and developers.
  • Troubleshoot and resolve Power BI and Microsoft Fabric performance and scalability issues.

Skills

Power BI
SQL
DAX
Semantic modelling
Star schema
Row-Level Security
Microsoft Fabric
OneLake
Lakehouse
Data Factory
Deployment Pipelines
Power Query

Tools

Power BI Desktop
Power BI Service
Power Query
Deployment Pipelines

Job description

Tel.: +351 214 171 161 - Lisboa
Tel.: +351 253 120 734 - Braga
Fax: +351 214 177 610
(Chamada para a rede fixa nacional) (Call to the national fixed network)

About Us: DataSmart is a Portuguese company, positioning itself as a consulting company of excellence, with over 20 years of existence. We are specialized in Technologies and Information Systems services, for the Portuguese and International markets. We pride ourselves on fostering a culture of involvement, experience, and excellence.

Join our team as a Senior Data Analyst (Hybrid – Porto)!

What You’ll Do:

  • Translate business requirements into scalable Power BI and Microsoft Fabric solutions
  • Design and maintain enterprise Power BI reports, dashboards, and semantic models following best practices
  • Develop metrics and KPI frameworks using advanced DAX
  • Manage Power BI Service environments, including Workspaces, Apps, gateways, refreshes, semantic models, and Deployment Pipelines
  • Implement Row-Level Security and appropriate access controls
  • Optimize Power BI reports and semantic models for performance, scalability, and usability
  • Design Microsoft Fabric solutions using OneLake, Lakehouse, Warehouse, and Data Factory pipelines
  • Ingest and transform data from SQL databases, APIs, cloud platforms, and flat files
  • Support data governance, data quality, lineage, monitoring, testing, and release management
  • Collaborate with Data Engineering and Data Platform teams to deliver secure and scalable analytical solutions
  • Work closely with business stakeholders across different business areas and geographies
  • Review technical solutions and mentor other analysts and developers
  • Troubleshoot and resolve Power BI and Microsoft Fabric performance and scalability issues

Qualifications:

  • Strong recent hands-on experience with Power BI Desktop, Power BI Service, DAX, and semantic modelling
  • Solid SQL and Power Query/M skills
  • Proven experience with star-schema, fact, and dimension modelling
  • Experience managing enterprise Power BI environments, including Workspaces, Apps, gateways, and Deployment Pipelines
  • Experience implementing Row-Level Security and applying BI governance, security, and enterprise delivery standards
  • Hands-on experience with Microsoft Fabric, particularly OneLake, Lakehouse, Warehouse, and Data Factory
  • Proven ability to troubleshoot and optimize Power BI and Fabric solutions for performance and scalability
  • Strong communication, stakeholder management, and problem-solving skills
  • Ability to work effectively with technical teams and business stakeholders

AtDataSmart, you will have the opportunity to integrate into a solid company and participate in projects of high recognition, nationally and internationally, with an appealing technological environment and career progression.

Excellence in the way to the future!

Connect with Us: Follow us on LinkedIn for updates on career opportunities, company news, and industry insights! For further details, visit us at www.datasmart.pt

#JoinOurTeam #DataSmart #ThinkDataBeSmart #PowerBI #MicrosoftFabric #DAX #DataAnalytics #DataEngineering #Lakehouse #Azure #BI

Do you accept the challenge?
We are waiting for you!
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

team.it • Portugal

Hybrid
EUR 55,000 - 85,000
Health insurance
Life insurance
Discounts and perks
+1
Senior Power BI Specialist
Senior Power BI Specialist

Adentis • Porto

Hybrid
EUR 42,000 - 65,000
Great Work-Life balance
Very flexible organizational routine
Health benefits for you and your family
+5
Senior Data Analyst (Hybrid) - Power BI & Fabric Expert
Senior Data Analyst (Hybrid) - Power BI & Fabric Expert

DataSmart • Porto

Hybrid
EUR 45,000 - 65,000
MS Fabric PBI Architect - Data Domain Deliver & Material Supply (m/f/d)
MS Fabric PBI Architect - Data Domain Deliver & Material Supply (m/f/d)

Siemens • Amadora

Hybrid
EUR 70,000 - 110,000
Hybrid model
Home office budget
Health insurance
+3
Data Engineer Master
Data Engineer Master

DataSmart • Porto

Hybrid
EUR 75,000 - 110,000
Power BI Senior Consultant
Power BI Senior Consultant

BI4ALL • Lisboa

Hybrid
EUR 45,000 - 65,000
Competitive compensation
Hybrid and flexible working model
Tailored learning paths
+2
Senior Data Analyst | PowerBI / Python
Senior Data Analyst | PowerBI / Python

Decskill • Porto

Hybrid
EUR 45,000 - 60,000
Long-term projects with national and international context
Opportunities for technical and professional growth
People-first culture focused on transparency and trust
+1
Power BI & Dataiku Developer
Power BI & Dataiku Developer

Decskill • Lisboa

Hybrid
EUR 35,000 - 55,000
Senior Data Analyst | Microsoft Fabric & Power Bi
Senior Data Analyst | Microsoft Fabric & Power Bi

LUZA Group • Lisboa

Remote
EUR 45,000 - 75,000
Equipment provided
Remote work flexibility
Benefits plan
Senior Data Engineer
Senior Data Engineer

Act Digital • Lisboa

Hybrid
EUR 60,000 - 90,000
Top locations