Description

Core Responsibilities

Power BI Development

• Build interactive, executive‑ready Power BI dashboards with drill‑downs, KPIs, bookmarks, tooltips, and advanced visualizations.
• Develop robust semantic models, star/snowflake schemas, and optimized datasets for enterprise reporting.
• Write advanced DAX (time intelligence, row‑level security, dynamic measures, calculation groups).
• Use Power Query (M) to clean, transform, and shape data for reporting.
• Implement dataset refresh strategies, incremental refresh, and performance optimization.
• Manage Power BI Service: workspaces, deployment pipelines, gateways, permissions, and governance.
• Create dataflows, reusable entities, and standardized models for self‑service BI.
• Ensure data accuracy, consistency, and reconciliation between source systems and Power BI outputs.
• Apply best practices for visual design, usability, and storytelling.

Oracle Data Extraction & Integration

• Extract and prepare data from Oracle 12c/19c using SQL, PL/SQL, stored procedures, and views.
• Build ETL/ELT pipelines to move Oracle data into Power BI (Import, DirectQuery, or hybrid).
• Optimize Oracle queries for performance, scalability, and refresh efficiency.
• Collaborate with DBAs and data engineering teams to validate data structures and ensure reliable data ingestion.

Required Skills & Experience

• 5–8+ years in BI development with a strong emphasis on Power BI.
• Expert‑level Power BI skills, including:
  • Advanced DAX
  • Power Query (M)
  • Data modeling & semantic layer design
  • Performance tuning
  • Row‑level security
  • Dataflows & deployment pipelines
• Strong SQL and PL/SQL experience with Oracle databases.
• Hands‑on experience integrating Oracle data into Power BI.
• Deep understanding of data warehousing, dimensional modeling, and BI best practices.
• Experience with Power BI Gateway, scheduled refreshes, and enterprise governance.
• Ability to translate business requirements into scalable BI solutions.
• Strong communication and documentation skills.

Preferred Qualifications

• Oracle DBA exposure (performance tuning, indexing, schema support, backup/recovery fundamentals).
• Experience with Azure Data Factory, Azure SQL, Synapse, or Data Lake for modern BI pipelines.
• Familiarity with Oracle BI Publisher, OBIEE, or legacy reporting tools.
• Experience with Python, Shell scripting, or automation frameworks.
• Knowledge of DevOps, Git, or CI/CD for BI deployments.
• Background in financial, operational, or enterprise reporting environments.

Soft Skills

• Strong analytical mindset with attention to detail.
• Ability to work with business stakeholders and translate needs into technical solutions.
• Excellent communication, documentation, and presentation skills

Key Skills

Education

Bachelor's degree