About the company:act digital is a global digital transformation consulting group.
We have more than ***** employees worldwide, with offices in Brazil, the United States, Canada, France, Portugal, Germany, Poland, Spain, Belgium, Luxembourg, Morocco and Serbia.We support the world's largest groups across the entire digital product development lifecycle: from digital design to growth and scaling strategies, through software engineering, architecture definition, data engineering and data science solutions.
We focus on accelerating the digital transformation of global leaders in their industry.Our group has experienced annual growth of more than 30% for 10 years.
About the Position: To support and respond to our needs, we are now looking for an Business Intelligence Engineer to join a dynamic team in the Porto area, under a hybrid arrangement- 3 times per week.
We are looking for a Business Intelligence (BI) Engineer to design, build, and maintain scalable analytics solutions that transform raw data into actionable insights.
You will work closely with business stakeholders, data engineers, and analysts to deliver reliable data models, dashboards, and reporting solutions that support strategic and operational decision-making.What are you doing...Design and maintain data models (star/snowflake schemas) for analytics and reporting;Build and optimize ETL/ELT pipelines from multiple data sources;Ensure data quality, consistency, and performance;Develop dashboards and reports (Power BI, Tableau, Looker);Implement security and governance (RLS);Translate business requirements into BI solutions;Optimize SQL queries and report performance;Monitor BI workloads (cloud & on-prem);Collaborate with stakeholders, Data Engineers, Data Scientists, and Product teams;Define data standards, documentation, and best practices;Support data lineage, metadata management, and audit processes;Ensure compliance with security and privacy policies.What we are looking for?
At least 5 years of experience in a similar role;Advanced SQL (optimization, complex joins, indexing);Experience with Data Warehouses (Snowflake, Synapse, BigQuery, Redshift, SQL Server);Power BI (DAX, semantic models, DirectQuery, Premium);ETL/ELT tools (ADF, Airflow, dbt, SSIS, Fivetran);Dimensional modeling (Kimball methodology);Excellent communication with technical & non-technical stakeholders;Ability to manage multiple priorities in fast-paced environments;Strong documentation and knowledge-sharing mindset;Good level of English.Nice to HaveExperience with cloud platforms (Azure, AWS, GCP);Python for automation or data processing;BI DevOps / CI-CD (Git, deployment pipelines);Knowledge of data governance frameworks.Perks:Health insurance;Meal allowance card;Variable components ;Training hours;Other complementary benefitsJoin us and grow in a place where your talent is valued, your effort is recognized, and your future truly matters.