Senior Business Intelligence Developer

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