BI Consultant | SSIS, SSRS & SSAS
Make an impact by working for sectors where technology is the enabler, everything is ground-breaking and there’s a constant need to be innovative.
Create and enhance projects in Java, Pyhton, Angular, PHP, .NET and so much more while diving in the world of Blockchain, Artificial Intelligence, Data Science, Security and Internet of Things.
Be part of the team that combines business knowledge, technological edge and a design experience. Our different backgrounds and know-how are key in developing solutions and experiences for digital clients.
Face challenges and learn other ways of thinking and seeing the world - there’s always room for your energy and creativity.
About the role
We are seeking a highly skilled BI Consultant ETL with expertise in Data Warehouse, SSIS, SSRS, SSAS, and Power BI. The successful candidate will be responsible for designing, developing, and implementing ETL processes, integrating data from various sources, and transforming it into meaningful information for business stakeholders. This role requires a deep understanding of Data Warehouse, ETL processes, and BI tools, as well as strong analytical, problem-solving, and communication skills.
As a part of your job, you will:
- Develop, design, and implement ETL processes to integrate data from various sources;
- Analyze business requirements, data sources, and data models to create data integration solutions;
- Build and maintain data pipelines to move and transform data across systems;
- Ensure data accuracy, completeness, and consistency across data sources;
- Optimize ETL performance to improve data processing times;
- Create and maintain documentation for ETL processes and data flows;
- Develop and maintain reports and dashboards using Power BI;
- Provide technical support for BI tools, ETL processes, and data warehouse solutions;
- Collaborate with cross-functional teams to identify and resolve data quality issues;
- Stay up to date with the latest BI tools, trends, and best practices to enhance data-driven decision-making.
What are we looking for?
- Bachelor's degree in Computer Science, Information Systems, or a related field;
- In-depth knowledge of Data Warehouse concepts, methodologies, and architectures;
- Minimum of a B2 level English;
- Proficiency in SQL, SSIS, SSRS, and SSAS;
- Experience in creating reports and dashboards using Power BI.
Nice to have:
- Experience in the banking area.
Personal traits:
- Strong communication skills;
- Teamwork skills but also sense of autonomy;
- Critical thinking;
- Motivation to learn about new topics;
- Willingness to collaborate with other players.
We want people who like to roll up their sleeves and open their minds. Believe this is you? Come join the Team!
- Department
- Data & Analytics
- Role
- Data Governance
- Locations
- Lisbon
- Remote status
- Hybrid Remote

Colleagues
Lisbon
About Celfocus
Celfocus delivers high-tech system integration services in the digital and cognitive space
As a Technology company, Celfocus accelerates Product & Service innovation, by promoting innovative digital capabilities and delivering business value in the most complex, mission-critical challenges.
From Strategy through Operations, collaborating in areas such as Actionable AI, Cognitive Automation and Digital – to produce the maximum benefits across Business & Technology.
BI Consultant | SSIS, SSRS & SSAS
Loading application form
Already working at Celfocus?
Let’s recruit together and find your next colleague.