Role:Power BI Technical Lead
Location :Oaks, PA Hybrid
Contract
W2/1099
F2F Interview
Skill:
Power BI Architecture & Technical Leadership Enterprise BI Architecture Designs scalable, enterprise-wide BI solutions. Lead end-to-end BI architecture and solution design
Technical Leadership Guides teams on best practices and architecture decisions
End to End Ownership Handles design → build → deploy → operate lifecycle
Platform Strategy Defines roadmap aligned with business needs.Align with Power BI & Fabric roadmap
Alignment with Data Platform Works with data engineering & architecture teams
Semantic Modeling & Data Modeling Dimensional Modeling Star schema, fact/dimension design.Design semantic models using star schema, relationships, and cardinality optimization
Relationship Optimization Efficient use of relationships, cardinality
Model Scalability Handles enterprise-scale datasets
Semantic Layer Design Business-friendly, reusable datasets
Data Warehouse Integration and ETL/ELT Concepts Integration with enterprise DW/Lakehouse platforms and Align transformation layers with reporting structure
Data Integrity Accurate modeling of business logic
Advanced DAX & Performance Optimization DAX Expertise Strong command of advanced DAX patterns.Advanced measures, calculated tables, and performance tuning
Financial/Analytical Calculations KPIs, trends, time intelligence
Context Mastery Deep understanding of filter/row context
Performance Tuning Optimizes slow measures and queries
Large Dataset Efficiency Works effectively with high-volume models
Power BI Capabilities Aggregations Effective use for performance optimization. Implement aggregations for large datasets
Incremental Refresh Handles large datasets efficiently
RLS (Row Level Security) Secure and scalable data access
Storage Modes Import, DirectQuery, Hybrid optimization for performance
Service & Administration Governance, workspace management, and platform administration
Composite/Hybrid Models Balances performance and flexibility
Dataflows Reusable transformation layers
Microsoft Fabric & Cloud BI Ecosystem Fabric Components Lakehouse, OneLake, Direct Lake
Cloud Architecture Designs cloud-native BI solutions
Integration with Data Platforms Works with Snowflake/Azure/etc.
Real-Time Analytics Knowledge of Fabric real-time intelligence
Innovation Awareness Keeps up with Fabric roadmap
SAP BusinessObjects to Power BI Migration SAP BO Knowledge WebI, Universes understanding
Migration Strategy Converts BO reports to Power BI models
Semantic Layer Mapping BO Universe → Power BI Dataset
Legacy Modernization Handles coexistence scenarios
Optimization Post-Migration Improves performance and usability
Visualization, UX & Insight Delivery Advanced Visual Design Uses effective, non-cluttered visuals. Build intuitive, visually compelling dashboards for business users
Dashboard Usability Intuitive navigation and filtering
Executive Reporting Clear, decision-oriented insights
Data Storytelling Converts data into actionable insights
Standardization Consistent design patterns across reports
Data Integration & APIs REST API Integration Connects and consumes external services
Embedded Analytics Integration with enterprise applications
Data Connectivity Works across multiple sources
Real-Time Data Near real-time integration patterns
Scalability Handles enterprise-grade integrations
Governance, Standards & Security Governance Framework Defines standards across BI assets
Naming Conventions Enforces structured and consistent naming
Performance Standards Creates guidelines for optimization
Security & Compliance RLS, data sensitivity, enterprise controls
Platform Administration Workspace, tenant-level governance
DevOps, Deployment & Governance Deployment Pipelines Manage Dev/Test/Prod pipelines
CI/CD Integration Align BI deployments with DevOps practices
Standards & Frameworks Define naming conventions, standards, and governance
Never miss an opportunity! Create an alert based on the job you applied for.
