1. Power BI Development and Data Modeling
Requirement Gathering: Translate logical business requirements into clear technical specifications and
analytical workflows.
Data Connectivity: Connect directly to backend enterprise systems (SQL databases, cloud warehouses, and
APIs), moving beyond flat Excel files.
Data Modeling: Design efficient, optimized data schemas (Star/Snowflake) and establish clean table
relationships.
DAX & Power Query: Author high-performing DAX queries, calculations, and measures. Perform complex
data transformation and cleansing in Power Query.
Dashboard Design: Build intuitive, user-friendly, and visually clean dashboards that emphasize clear data
storytelling.
2. Power BI Platform Administration
Workspace & Deployment: Set up and manage workspaces, app publishing pipelines, and deployment
environments.
Access Control & Security: Configure Row-Level Security (RLS) and manage workspace user permissions
and sharing.
Gateway & Refresh Management: Configure, maintain, and troubleshoot on-premises/cloud data
gateways and automated refresh schedules.
Performance Optimization: Proactively monitor report performance, identify bottlenecks, and resolve
dataset refresh errors.

Requirements

Professional Experience: 1 to 2 years of actual, hands-on experience building and administering Power BI
environments.
Strong SQL Skills: Proficient in writing and optimizing SQL queries (joins, aggregations, subqueries) to
extract and manipulate data directly.
Cloud Databases: Experience connecting to and querying modern cloud platforms (such as Snowflake,
Databricks, Azure SQL, BigQuery, or Redshift).
Power BI Fundamentals: Solid core knowledge of Power BI Desktop, Power BI Service, data gateways, and
complex DAX measures.
Analytical Reasoning: Strong logical thinking and problem-solving skills to ask clarifying questions and
unpack requirements.
Preferred Skills and Qualifications
Microsoft Fabric & GCP: Exposure to Microsoft Fabric (OneLake, Lakehouses) and experience querying
data within Google Cloud Platform (BigQuery).
Certifications & Tools: Microsoft PL-300 certification or basic familiarity with Power Platform tools (Power
Apps, Power Automate).

Required skills

Data Modeling (Star/Snowflake schemas)DAX (authoring high-performing queries, calculations, measures)Power Query (complex data transformation and cleansing)Dashboard Design and Data StorytellingRequirements Analysis (translate business requirements into technical specifications)SQL (writing and optimizing queries: joins, aggregations, subqueries)Cloud data warehouse connectivity and querying (Snowflake, Databricks, Azure SQL, BigQuery, Redshift)API data integration (connect to backend systems via APIs)Power BI Administration (workspace setup, app publishing, deployment pipelines)Row-Level Security (RLS) and access control in Power BIData Gateway configuration and automated refresh managementPower BI performance monitoring and optimizationAnalytical reasoning and problem solvingMicrosoft Fabric (OneLake, Lakehouses) exposureFamiliarity with Power Platform tools (Power Apps, Power Automate)

Similar jobs