Business Intelligence (BI) Engineer

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. 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 & dashboards in Power BI and Oracle Analytics (OAC/OAS) that provide a 360-degree view of business performance, Python (Pandas , Polars ,SQLAlchemy, DuckDB , Plotly , ReportLab ,..) • 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-touse 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: Category Must-Have Expertise Visualization Tools Power BI (DAX, Power Query), Oracle Analytics (OAC/OAS) • Legacy BI Oracle OBIEE (RPD development, Analysis, Dashboards) • Databases Oracle Database & Microsoft SQL Server • Data Modeling Relational Modeling, Star Schema, Snowflake Schema • Languages Advanced SQL (PL/SQL & T-SQL), DAX