SUMMARY
Technical Skills (Required):
Azure Analysis Services (AAS)
- Authoring and optimising Queries and Views
- Designing and managing Cubes (measures, KPIs, hierarchies)
- Configuring Partitions and Performance Tiers
Power BI Semantic Models
- Building tabular models: relationships, calculated measures (DAX), Dataflow
- Data transformation with Power Query (M language)
Microsoft Fabric OneLake
- Working with Delta Tables: creation, optimisation, maintenance
- Implementing Mirror Tables and Direct Lake architectures
- Databricks Connection (Good to have)
Row-Level Security (RLS)
- Defining dynamic and static security roles
- Testing and validating user-based access controls
Fabric Capacity Management
- Sizing and scaling capacity (compute & storage)
- Monitoring utilisation and cost optimization
SQL
- Writing and tuning T-SQL queries in Azure SQL, Synapse, etc.
- Creating Views, Stored Procedures, and maintenance scripts
- Required Skills for PowerBI Analyst in Data & Analytics team
Technical Skills (Good - to - Have):
Fabric Notebooks (PySpark)
- Python programming for big data processing with Spark APIs
Azure Data Factory (ADF)
- Orchestrating data pipelines and integrating multiple data sources
Advanced DAX: time-intelligence, complex calculations, performance tuning
CI/CD & DevOps: Git, Azure DevOps pipelines, infrastructure as code
API Integration: REST/OData connectors, custom data ingestion
Performance Troubleshooting: query diagnostics, bottleneck analysis
Monitoring & Governance: Azure Monitor, Log Analytics, data cataloging
Confluence: for documentation
Soft Skills:
Effective Communication: presenting technical insights clearly to diverse audiences
Advanced English Proficiency: reading/writing documentation, collaborating with global teams
Team Collaboration: working closely with BI developers and engineers
Analytical Mindset: problem-solving and pattern recognition in data
Proactivity & Autonomy: driving improvements and anticipating business needs
Time Management: prioritising tasks and meeting deadlines
Adaptability: embracing changing requirements and new technologies