Data Engineer (m/f)

Brix IT; Lisboa; Híbrido; EUR 35 000 - 52 000; Tempo integral

Resumo da oferta

At Brix IT, we are seeking a data engineer to translate business requirements into robust, scalable data solutions. You will work on Data Warehouse, ETL, dimensional modelling, reporting, and SQL Server performance optimization, collaborating with technical teams and stakeholders to ensure data quality and value.

Ideal candidates have 2+ years in Data Engineer/BI roles, strong SQL Server/T-SQL, hands-on ETL with SSIS, SSAS knowledge, and Power BI expertise.

Qualificações

• 2+ years of experience as a Data Engineer, BI Developer, or similar role.
• Strong SQL Server and T-SQL skills.
• Hands-on ETL with SSIS.
• Experience with SSAS (tabular or multidimensional).
• Power BI expertise incl. data modelling and DAX.
• Knowledge of Data Warehouse concepts and dimensional modelling.
• Ability to translate requirements into scalable data solutions.
• Good troubleshooting and performance optimization.
• Autonomy and strong communication with stakeholders.
• Experience in hybrid environments combining on-premises and cloud solutions.

Responsabilidades

• Develop, maintain and optimize data integration processes using SSIS.
• Design data models for Data Warehouses and Data Marts.
• Develop analytical solutions with SSAS (tabular or multidimensional).
• Build and maintain Power BI and SSRS reports and dashboards.
• Work with SQL Server, including T-SQL development and query optimization.
• Ensure data quality, consistency, performance and governance.
• Collaborate with business teams to analyze requirements.
• Support technical teams and junior profiles.
• Contribute to ongoing data model and data flow improvements.

Conhecimentos

Data engineering

SQL Server

T-SQL

SSIS

SSAS

Power BI

Data Warehouse

Requirements analysis

Troubleshooting

Communication

Ferramentas

SSIS

SSAS

Power BI

SQL Server

Descrição da oferta de emprego

At Brix IT, we build technology with purpose.
We’re a specialized IT consultancy focused on tailored solutions, technical excellence, and long-term partnerships.

We believe technology is made by people, for people - and that’s why we place talent at the heart of everything we do. Here, you’ll find a transparent, collaborative environment where growth truly matters.

If you’re looking for a project built on vision, trust, and real impact, Brix might be your next step.

About the role

We are looking for a professional with hands-on experience in data engineering, capable of translating business requirements into robust, scalable and well-structured technical solutions.

The selected candidate will work on Data Warehouse, ETL, dimensional modelling, reporting and SQL Server performance optimization, collaborating with both technical teams and business stakeholders to ensure data quality, consistency and value.

Responsibilities

• Develop, maintain and optimize data integration processes, mainly using SSIS
• Design and evolve analytical data models for Data Warehouses and Data Marts
• Develop analytical solutions with SSAS, either tabular or multidimensional
• Build and maintain reports and dashboards using Power BI and/or SSRS
• Work with SQL Server, including T-SQL development and query optimization
• Ensure good practices regarding data quality, consistency, performance and governance
• Collaborate with business teams to analyse requirements and design technical solutions
• Support technical teams and junior profiles in solving functional and technical challenges
• Contribute to the continuous improvement of data models, processes and data flows

Requirements

• 2+ years of experience as a Data Engineer, BI Developer or similar role
• Solid experience with SQL Server and T-SQL
• Hands-on experience with ETL processes using SSIS
• Knowledge of SSAS, either tabular or multidimensional
• Experience with Power BI, including data modelling, DAX and visualization
• Understanding of Data Warehouse concepts and dimensional modelling
• Ability to analyse requirements and propose suitable technical solutions
• Good troubleshooting and performance optimization skills
• Autonomy, critical thinking and problem-solving mindset
• Good communication skills with both technical and non-technical stakeholders

Nice to have

• Experience with SSRS
• Knowledge of the Kimball methodology
• Experience in hybrid environments combining on-premises and cloud solutions
• Knowledge of Azure services such as Azure Data Factory or Azure Synapse
• Experience with CI/CD practices applied to data projects
• Knowledge of Data Quality, Data Governance or data lineage concepts

Why Brix:

At Brix IT, we care about what really matters: people, balance, and continuous growth.

Personalized career development: Your career path is built with you - based on your short and long-term goals, and shaped to match your pace.

Projects with purpose: We work with clients across multiple industries, giving you exposure to different challenges and meaningful tech experiences.

Ongoing learning: From tech certifications to soft skills training, we support your growth through tailored learning opportunities.

Flexible work models: Remote, hybrid, or onsite - we adapt to what makes sense for you and for each project.

Human-centered culture: We’re a close-knit team with real transparency and care. We value genuine relationships, collaboration, and the well-being of those who grow with us.

Well-being matters: We know that performance depends on a healthy balance between personal and professional life. That’s why we promote a respectful, supportive environment that encourages responsible time management - recognizing well-being as key to sustainable, high-quality performance.