Caixa Mágica Software

Business Data Analyst

Caixa Mágica Software  •  Lisbon, PT (Onsite)  •  22 days ago
Apply
AI can make mistakes so check important info. Chat history is never stored.

Job Description

Location: Lisbon,Lisbon,Portugal

We are expanding our Transversal Squad with Business Data Analyst who will drive the design, development and rollout of our Data Factory framework. In this role you will work side by side with developers, data engineers and product owners to turn business needs into a robust, scalable data aggregation platform.

Data Factory is a strategic initiative that will deliver a Data Aggregation & Curation platform built on a relational database and modern ETL pipelines. The objective is to create a single, centralised repository that holds a copy of all operational and referential data, fully harmonised, quality checked and ready for downstream consumption.

What will you do?

  • Gather and analyze requirements from business stakeholders, data owners, and regulatory teams.
  • Translate business needs into functional specifications (user stories, acceptance criteria, data model diagrams).
  • Create and maintain documentation (requirements catalog, data dictionary, process maps, test plans).
  • Facilitate test planning by participating in design test cases
  • Communicate progress and outcomes to stakeholders through sprint demos, status reports and reviews
  • Identify improvement opportunities in the transversal framework, propose enhancements
  • Collaborate with the ETL development team to design optimal data flow and transformation logic
  • Define, implement, and maintain the data quality framework (rules, thresholds, validation check)

What are we looking for?

  • SQL development skills (Oracle is the DB used)
  • PL/SQL development skills
  • IBM Datastage PX and/or other similar ETL tools
  • Agile Project Management Tools – Manage backlogs, user stories, and traceability in Jira or Azure DevOps; ensure requirements are linked to test cases and delivery artifacts
  • Data Analysis & Visualization – Perform exploratory data analysis (EDA), statistical summarization, and create visual insights (Power BI, Tableau, or Excel) to support requirement‐gathering and decision making.
  • Data Quality & Profiling Techniques – Use data profiling methods to define validation rules, cleansing procedures, and quality metric dashboards
  • Autonomous, organized and delivery-focused with attention to detail
  • Dynamic and proactive taking own initiative to mitigate risk, and prevent issues arising
  • Great communication skills while being capable of negotiating with sponsors and reaching to an agreement
  • Ability to work well under pressure and tight timeframes
  • Good work ethic and high levels of motivation
  • English (read, spoken, written - C level minimum)
  • French knowledge is a nice to have
  • Portuguese – Mastery

What can you expect from us?

  • A permanent job contract for a long term project;
  • Tech equipment + SIM Card + personal smartphone;
  • Health and Life Insurance;
  • Social events and team buildings;
  • The commitment of letting you grow with us, and be rewarded accordingly;
  • A dynamic and young team that will be always there to support you;
  • Training in the latest technologies;
  • Coffee, fruits, snacks and a warm welcoming when you pass by the office.
Caixa Mágica Software

About Caixa Mágica Software

Caixa Mágica Software is a Portuguese SME and a recognized leader in the open source ecosystem. Founded in 2000 as a spin-off from a university research project, we’ve grown into a trusted technology partner for both public institutions and private companies across Europe.

Our journey began with the development of the Linux Caixa Mágica distribution, and over the years, we’ve expanded into embedded systems, cloud platforms, mobile and web applications and digital identity solutions. We're also the official LPI certification provider in Portugal and a consistent contributor to EU-funded research and innovation projects.

With a strong foundation in open source values, we believe in building sustainable, secure and future-ready technology. Always through collaboration, transparency and innovation.

Industry
IT & Software
Company Size
51-200 employees
Headquarters
Lisbon, PT
Year Founded
2004
Social Media