Senior Data Analyst – Power BI & SQL (Hybrid, Porto)

About the role

We are looking for a Senior Data Analyst to join a fast‑growing investment banking and financial services project based in Porto. The role focuses on designing and delivering end‑to‑end Power BI solutions that support innovative business operations.

Key responsibilities

• Architect, develop and deploy enterprise‑grade Power BI dashboards and reports.
• Translate ambiguous financial business requirements into clear, scalable analytical specifications.
• Perform advanced data extraction, transformation and loading using SQL and Power Query.
• Design data‑warehousing models following Kimball methodology, including star schemas, fact and dimension tables.
• Collaborate with business stakeholders to challenge requests and ensure optimal analytical outcomes.

Required profile

• 3–6 years of professional experience in data analysis or business intelligence.
• Senior‑level expertise in Power BI, DAX and M/Power Query.
• Strong SQL skills, including performance tuning, CTEs and window functions.
• Deep knowledge of data‑warehousing concepts (Kimball, star schema).
• Proactive advisory mindset with strong problem‑solving abilities.
• Full professional proficiency in English (written and spoken).

Required skills

• Power BI
• DAX
• M/Power Query
• SQL (CTE, window functions, performance optimization)
• Data Warehousing – Kimball methodology
• Star Schema design, Fact and Dimension tables

What we offer

• Health insurance.
• Personalized training plan with a dedicated budget.
• Continuous feedback and professional growth opportunities.
• Remote onboarding process.
• Team events each semester.
• A culture of proximity, transparency and employee voice.