Business Intelligence Engineer

About Valleysoft

Valleysoft is an IT services provider delivering enterprise technology solutions, software development, process management, and infrastructure support for clients around the world. Working across a broad range of client needs, the team helps organizations turn complex systems and data into practical, high-value business outcomes through reliable technology and thoughtful execution.

Role Overview

In this role, you will help shape how business performance is understood through modern reporting and analytics. As a Business Intelligence (BI) Engineer, you will contribute to solutions that connect legacy reporting environments with more modern visualization and self-service analytics capabilities, helping stakeholders access clear, trusted insights that support better decisions.

Responsibilities

Dashboard & report development: Design, develop, and deploy interactive reports and dashboards in Power BI and Oracle Analytics (OAC/OAS) that provide a 360-degree view of business performance. Utilize Python (Pandas, Polars, SQLAlchemy, DuckDB, Plotly, ReportLab, etc.).

Semantic layer architecture: Build and optimize complex metadata models (RPD) in Oracle OBIEE and shared datasets in Power BI to ensure "one version of the truth."

Advanced data modeling: Utilize relational data modeling to understand source systems and dimensional modeling (star/snowflake) to build performant reporting layers.

Self-service enablement: Empower business units by creating curated, easy-to-use data models and providing guidance on BI best practices.

Performance tuning: Optimize front-end report performance and underlying SQL queries to ensure sub-second response times for executive-level dashboards.

Technical Toolkit

We require a specialist who is comfortable operating across both the Oracle and Microsoft BI stacks:

Visualization tools: Power BI (DAX, Power Query), Oracle Analytics (OAC/OAS)

Legacy BI: Oracle OBIEE (RPD development, Analysis, Dashboards)

Databases: Oracle Database and Microsoft SQL Server

Data modeling: Relational modeling, star schema, snowflake schema

Languages: Advanced SQL (PL/SQL and T-SQL), DAX

Requirements

Experience: 5+ years in Business Intelligence, with a proven track record of migrating or integrating Oracle BI environments with Power BI.

Analytical translator: You have the rare ability to talk to a DBA about join types and then turn around and explain a KPI trend to a business executive.

Design aesthetic: You understand that "good enough" isn't enough; you take pride in creating clean, intuitive, and mobile-responsive data visualizations.

Integrity focused: You understand that a beautiful dashboard is useless if the numbers are wrong. You are obsessed with data validation and reconciliation.

Banking knowledge: You understand banking business.

Eligibility: Eligibility to work in Egypt.