Mid Data Analyst BI&DS | DH037946

Porto, Portugal
Mid-level (2-3 Years)
Hybrid
English Required Not Accepting Candidates Living Abroad
Key Responsibilities
Dashboard Development: Design and develop high-performance, enterprise-grade Power BI reports and dashboards for CIB Financing.
Data Modeling: Design, build, and optimize robust data models using Dimensional Modeling (Star Schema).
DAX Development: Write and optimize complex DAX calculations and ensure report performance over large datasets.
SQL & Data Extraction: Write and optimize complex SQL queries to extract and prepare data from bank databases.
Stakeholder Management: Gather requirements directly from CIB business stakeholders, help them define KPIs, and advise them on the best visualization solutions.
Governance & Security: Implement Row-Level Security (RLS), manage Power BI workspaces, and enforce best practices across the team.
Technical Skills
Senior Power BI Expertise: Deep, senior-level experience in architecting and deploying end-to-end enterprise Power BI solutions.
Advanced DAX & Power Query: Master-level knowledge of DAX (expert in evaluation context, time intelligence, and performance tuning) and complex M/Power Query transformations.
Advanced SQL: Expert-level SQL querying skills (performance optimization, complex joins, CTEs, and window functions) for data extraction and preparation.
Dimensional Modeling: Deep theoretical and practical expertise in data warehousing concepts, specifically Kimball methodology (Star Schema, Fact and Dimension tables).
Soft Skills
Executive Stakeholder Management: Exceptional communication skills with the ability to confidently present to, negotiate with, and influence senior CIB business leaders.
Consultative Leadership: A proactive, advisory mindset—the ability to constructively challenge business requests to deliver the best possible analytical product rather than just executing specifications.
Analytical & Strategic Thinking: Strong problem-solving skills to translate ambiguous financial business needs into structured, scalable technical requirements.
Language: Full professional proficiency in English (written and spoken) to operate fluently in an international and multicultural banking environment.
We connect IT professionals with projects that match their skills, professional experience, and goals, then we offer a career progression program, delivered by in-house specialists - our People Experience Partners - to guide them through our journey with us.

What we offer:

  • A project that matches your skills and ambitions, as well as your preferences for working policies and culture.
  • A competitive salary with awesome benefits and opportunities to leverage your knowledge and network to earn additional income.
  • An empowering and respectful work culture enriched with social and learning events.
  • A People Experience Partner specially assigned to you - your go-to career guide, responsible for supporting your growth, facilitating training, and ensuring your work-life balance at KWAN.
At KWAN, they make sure that I feel comfortable with the client I’m working for and that what I’m doing aligns with my career aspirations.
Luis Caldeira, DevOps @ KWAN
At KWAN, I’m given the space to be myself and do what I love. I have control over the projects I work on, as well as the direction of my career.
Pedro Fonseca, Front End Developer @ KWAN
I see my People Experience Partner as someone who is always available to provide me with motivation and constant feedback, which helps me be sure that I am in the right place.
Josimar dos Reis, Software Developer @ KWAN
I know that I’ve contributed to the growth of a company that truly values a “people first culture”, because my ideas, experiences, and individuality were always appreciated.
João Nascimento, Software Developer (KWAN Alumni)
My two years at KWAN were an incredible experience! From the start, I was welcomed into a warm and collaborative environment where I felt truly supported.
Laís Ortiz, Software Developer @ (KWAN Alumni)
Grab this opportunity, apply now!

What You Can Expect as a KWANer

Respect isn’t optional here

You’re trusted to deliver and supported to speak up.

Dedicated People Experience Partner

Someone accountable for your growth, not your allocation.

Continuous learning, built in

Learning that keeps pace with the systems you build.

Recognition that’s visible

Your impact doesn’t go unnoticed. Through our Rocket Points System, we constantly recognize your contributions.

A culture you can feel

From movie and quiz nights to dinners and our annual summer gathering, we don’t just work together - we build real connections.

Flexible spaces to work your way

Remote-first, with physical hubs when you want connection.

Didn't find your mission yet?


Strong profiles don’t always match timing. That doesn’t mean there isn’t alignment.

We review every application. If there’s alignment, we won’t let it get lost in a database.