Junior Data Analyst (SQL Server, Access)

Lisbon, Portugal

Senior (4-6 Years)

Hybrid

English Required Portuguese Required Not Accepting Candidates Living Abroad

Payments and financial technology company operating across Portugal. Team responsible for the financial control of a cash cycle across multiple operational stages, ensuring amounts match at each stage and that discrepancies are identified, documented and resolved.

What you will do

Extract data from multiple sources (internal databases, partner files, terminal records, bank statements), clean and consolidate it into a single analysis base.
Reconcile financial movements across the value chain, cross-checking data from different stages of the process.
Identify gaps such as value differences, missing movements or settlement delays, and quantify their impact.
Produce periodic executive reports on gaps found, trends and recommendations, in clear language for management.
Open and follow up correction requests with internal teams (operations, accounting, IT, partner management) until each case is closed.
Propose improvements to collection and control processes to reduce recurring discrepancies.

Location and work model

Hybrid (3 days/week in the office, Lisboa)

Degree in Computer Engineering, Management Information Systems, Statistics or Data Analysis
SQL Server and T-SQL — writing complex queries (joins, aggregations, subqueries), creating views and simple procedures
Advanced Excel (pivot tables, VLOOKUP/XLOOKUP, Power Query)
Access (queries, table relationships, data import)
English A2
Portuguese

Nice to have

VBA for automating extractions and recurring reports
Knowledge of information systems architecture and integration methods (ETL, APIs, batch files)
Proactive, results-oriented profile with strong interpersonal skills and comfort working under pressure with sensitive financial data

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!