Power BI Architects are experts in data modeling and analysis and are responsible for developing high-quality datasets and visually stunning reports. They design and develop data models that effectively support business requirements, ensuring the accuracy and reliability of the data presented in the dashboards and reports. They possess proficiency in Power BI Desktop and expertise with SQL and DAX. Projects may range from short-term individual client engagements to multiyear delivery engagements with large, blended teams.
Requirements:
- A minimum of 6-8 years full-time experience using Power BI Desktop, with extensive knowledge of Power Query, Power Pivot, and Power View
- Able to quickly write SQL for database querying and DAX for creating custom calculations
- Possess good knowledge of M and Vertipaq Analyzer
- Understand data modeling concepts and be able to create effective data models to support reporting needs.
- Perform data ETL processes to ensure that data sets are clean, accurate, and ready for analysis.
- Work closely with stakeholders to understand requirements, deliver solutions that meet those needs, and bridge the gap between technical and non-technical sides.
- Unwavering ability to quickly propose solutions by recalling the latest best practices learned from MVP & Product Team articles, MSFT documentation, whitepapers, and community publications
- Excellent communication, presentation, influencing, and reasoning skills
- Familiarity with the Azure data platform, e.g., ADLS, SQL Server, ADF, Databricks etc.
We would like to see a blend of the following technical skills:
- Power BI Desktop, Power BI Dataflows, Tabular Editor, DAX Studio, and VertiPaq Analyzer
- T-SQL, DAX, M, and PowerShell
- Power BI Service architecture design and administration
- Understanding the business requirements, designing the data model, and developing visualizations that provide actionable insights
- VertiPaq and MashUp engine knowledge
- Data modeling using the Kimball methodology