• Jobs
  • >
  • BI Developer (Powercenter & Oracle)

BI Developer (Powercenter & Oracle)

  • Sem termo
  • Full time
  • Hybrid (1050-094, Lisboa, Portugal)

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.

Key Responsibilities:

  • Design, develop, and maintain ETL/ELT processes using Informatica PowerCenter.

  • Develop and optimize data integration workflows sourcing data from multiple systems.

  • Design and maintain data models (dimensional and relational) to support BI and reporting needs.

  • Work with Oracle databases for data extraction, transformation, performance tuning, and optimization.

  • Collaborate with business stakeholders and BI teams to translate requirements into technical solutions.

  • Ensure data quality, consistency, and reliability across BI solutions.

  • Support testing, deployment, and maintenance of BI and data integration solutions.

  • Document data flows, models, transformations, and technical specifications.

Profile & Skills

  • Strong experience with Informatica PowerCenter in enterprise BI or data integration projects.

  • Solid hands-on experience with Oracle databases, including SQL and performance optimization.

  • Proven experience in data modeling, including:

  • Dimensional modeling (star/snowflake schemas)

  • Relational data modeling

  • Good understanding of data warehousing concepts and BI architectures.

  • Ability to analyze business requirements and translate them into effective data solutions.

  • Experience working in structured, enterprise-scale environments.

  • Strong communication skills and ability to work with both technical and business teams.

Nice to Have

  • Experience with reporting or visualization tools (e.g., Power BI, OBIEE, Tableau).

  • Knowledge of data governance, data quality, and metadata management.

  • Experience with scheduling, monitoring, and troubleshooting ETL processes.

  • Familiarity with Agile or iterative delivery methodologies.

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.