Job Description:
- Experience
- At least have 5 years of relevant experience in Power BI,Analytics , Datawarehousing concepts roles.
- Educational Background
- Must have an Engineering background.
- Communication Skills 4/5
- Should demonstrate clear, confident, and professional communication, with the ability to explain technical concepts effectively.
- Power BI 4/5
- Strong hands-on experience in:
- Data modeling and relationships
- DAX fundamentals and measures
- Report and dashboard development
- Performance optimization basics
- Data Warehousing Concepts 4/5
- Good understanding of core data warehousing principles, including:
- Slowly Changing Dimensions (SCD)
- Star Schema and Snowflake Schema
- Role-Playing Dimensions
- Fact Tables and Factless Fact Tables, Confirmed Dimension etc.
- Data Modeling 4/5
- Solid knowledge of data modeling concepts such as:
- Cardinality and relationship types
- Conceptual vs Logical vs Physical Data Models
- Differences between Databases and Data Warehouses
- Natural Keys vs Surrogate Keys
- Power BI Fabric 2/5
- Basic or theoretical understanding is sufficient.
- Hands-on project experience is not mandatory.
- Database / SQL Knowledge 4/5
- Strong SQL skills, including:
- Writing Stored Procedures
- Creating Views
- Using CTEs
- Writing complex SQL queries
- Query optimization techniques
Data Modeling Exposure
- Have you designed data models yourself or worked with existing ones
- Do you understand different types of data models (conceptual, logical, physical)
- Have you handled relationships between multiple tables
Datawarehousing concepts :
- Have you worked with a data warehouse If yes, in what capacity
- Are you familiar with concepts like Star Schema or Slowly Changing Dimensions
- In your projects, did you work with fact and dimension tables
Power BI Fabric (Optional / Nice to Have)
- Have you heard about Power BI Fabric
- Have you used it in any project or only learned it conceptually
