Caixa Mágica Software
Caixa Mágica Software

Business Data Analyst

TLDR

Drive design, development, and rollout of a Data Factory framework, collaborating with developers, data engineers, and product owners to build a scalable data aggregation platform.

Overview:

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.

Benefits

Equity Compensation

The commitment of letting you grow with us, and be rewarded accordingly

Free Meals & Snacks

Coffee, fruits, snacks and a warm welcoming when you pass by the office.

Health Insurance

Health and Life Insurance

Home Office Stipend

Tech equipment + SIM Card + personal smartphone

Learning Budget

Training in the latest technologies

supportive team environment

A dynamic and young team that will be always there to support you

Paid Time Off

Social events and team buildings

Caixa Mágica Software develops advanced software solutions tailored for the automotive industry, including embedded systems and Android Automotive applications, enabling seamless in-vehicle experiences. Targeting both consumers and businesses, they modernize existing SAP systems while providing a diverse range of IT and business consulting services.

View company profile
Report this job
Apply for this job