What You'll Do As a Consulting Power BI Developer, you will:
- Design, develop, and deploy enterprise Power BI reports, dashboards, and semantic models (datasets) that meet client business requirements and performance standards.
- Build and optimize data models using SQL, DAX and Power Query (M), applying best practices for star schema design, calculated measures, and row-level security (RLS).
- Collaborate with data architects and engineers to connect Power BI to data sources including On-prem SQL, Azure Synapse Analytics, Microsoft Fabric Lakehouses, Azure SQL, and Databricks.
- Develop and maintain Microsoft Fabric workspaces, including Lakehouses, Data Pipelines, and Dataflows Gen2, as part of end-to-end analytics solutions.
- Translate complex business requirements into clear, actionable data visualizations and self-service BI capabilities for client stakeholders.
- Implement deployment pipelines, version control practices, and workspace governance standards to ensure reliable, scalable BI solutions.
- Support client enablement and knowledge transfer through documentation, training sessions, and handoff materials to ensure long-term client self-sufficiency.
- Advise clients on Power BI licensing, capacity planning (Premium/Fabric SKUs), and governance best practices aligned to their organizational maturity.
- Contribute to the development of RapidScale's Power BI practice standards, reusable solution templates, and internal knowledge resources.
- Participate in pre-sales activities, including solution scoping, effort estimation, and delivery of client-facing presentations and demonstrations.
Qualifications Minimum Requirements
- Power BI Expertise: Advanced proficiency in Power BI Desktop, Power BI Service, and the full report development lifecycle.
- Data Modeling: Strong command of DAX for calculated columns, measures, and time intelligence; solid understanding of star/snowflake schema design.
- Write advanced SQL queries (joins, CTEs, window functions, query optimization) to support analytical workloads.
- Power Query (M): Ability to write and troubleshoot complex data transformation logic using Power Query in both Power BI and Dataflows.
- Cloud Data Connectivity: Experience connecting Power BI to Azure-based data sources such as Azure SQL Database, Azure Synapse Analytics, or Azure Data Lake Storage.
- Microsoft Fabric Familiarity: Working knowledge of Microsoft Fabric components including Lakehouses, Dataflows Gen2, and semantic model integration.
- Client Communication: Demonstrated ability to translate technical findings into clear business narratives for non-technical stakeholders.
- Collaboration: Experience working in cross-functional teams alongside data engineers, architects, and project managers. Preferred Qualifications
- Experience in a consulting or client-facing services delivery role.
- Microsoft certifications such as PL-300 (Power BI Data Analyst) or DP-600 (Microsoft Fabric Analytics Engineer).
- Familiarity with other Azure data platform services including Azure Data Factory, Azure Databricks, or Azure Purview.
- Experience with Paginated Reports (SSRS/RDL) for operational reporting requirements.
- Exposure to CI/CD pipelines for BI assets using Azure DevOps or GitHub Actions.
- Knowledge of data governance and data catalog concepts within the Microsoft ecosystem.
- Familiarity with complementary BI tools such as Tableau or Qlik for client migration or comparison engagements.
- Experience using Power BI Reporting with M365 and Co-Pilot inte