BI Data Analyst: Hybrid Work, Growth & Training

Affinity; Oeiras; On-site; EUR 38,000 - 60,000; Full time

Job summary

Affinity is looking for a Data BI Analyst to analyze business requirements, design semantic models and deliver analytical solutions for projects in multiple countries. The role involves translating business needs into data models and ETL rules, and delivering actionable insights using BI tools.

You will work with SQL, dimensional modeling and reporting platforms (Power BI/Tableau), collaborating with stakeholders to ensure data quality and governance.

Qualifications

• Degree in Data Engineering, Computer Engineering or similar preferred.
• 4+ years as Data Analyst/BI Analyst or similar roles.
• Strong SQL, data modeling, and data transformation skills.
• Experience with dimensional modeling (Star/Snowflake).
• Proficiency in Power BI or Tableau for reporting and visualization.
• Ability to translate business needs into data models and specs.
• Good communication and teamwork across stakeholders.
• English proficiency (min. B2); Portugal residency required.

Responsibilities

• Analyze, document and validate business requirements within BI projects.
• Design and develop semantic models and data structures for reporting.
• Collaborate with stakeholders to turn needs into insights and analytics.
• Translate requirements into technical specs, data models and ETL rules.
• Ensure data quality, consistency and integrity in analyses.
• Coordinate User Acceptance Testing (UAT) activities.
• Develop datasets, metrics and analytic models to support decisions.
• Create functional and technical documentation for BI solutions.
• Provide training and support to users of analytical tools.
• Contribute to continuous improvement of reporting, modeling and governance.

Skills

SQL

Dimensional modeling

Power BI

Tableau

English (B2)

Data analysis

Stakeholder collaboration

Data governance

Education

Degree in Data Engineering or Computer Engineering

Degree in Information Systems/Math/Statistics

Tools

Power BI

Tableau

Job description

Affinity is looking for a Data BI Analyst to analyze business requirements, design semantic models and deliver analytical solutions for projects in multiple countries. The role involves translating business needs into data models and ETL rules, and delivering actionable insights using BI tools.

You will work with SQL, dimensional modeling and reporting platforms (Power BI/Tableau), collaborating with stakeholders to ensure data quality and governance.