Senior Business Intelligence Developer

Lakshya Software Technologies Pvt. Ltd.; Pune District; On-site; INR 800,000 - 1,200,000; Full time

Job summary

A technology consulting firm in Pune is seeking a Business Intelligence Developer skilled in Power BI with at least 5 years of experience in analytics and data warehousing. The role requires solid knowledge in data modeling, SQL, and effective communication skills. A full-time position offering opportunities to work with various data warehousing concepts and advanced reporting techniques. Ideal for mid-senior level professionals looking to advance their careers in IT services.

Qualifications

• At least 5 years of relevant experience in Power BI, analytics and data warehousing concepts.
• Strong understanding of data modeling and data warehousing principles.
• Ability to write SQL queries and optimize performance.

Skills

Power BI

Data Warehousing

SQL

Data Modeling

Communication Skills

Education

Engineering degree

Job description

Business Intelligence Developer – Power BI

We’re looking for an experienced BI developer with strong Power BI, analytics and data‑warehousing skills.

Qualifications & Experience

• At least 5 years of relevant experience in Power BI, analytics and data‑warehousing concepts.
• Educational Background – Engineering degree.
• Communication Skills – 4/5 – Clear, confident and professional, able to explain technical concepts.
• Power BI – 4/5 – Hands‑on experience with:
  - Data modeling and relationships
  - DAX fundamentals and measures
  - Report and dashboard development
  - Performance optimization basics
• Data Warehousing Concepts – 4/5 – Strong understanding of core principles:
  - 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 concepts such as:
  - Cardinality and relationship types
  - Conceptual, Logical and 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 – Ability to write stored procedures, create views, and apply 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?

Data Warehousing 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?

Seniority Level

• Mid‑Senior level

Employment Type

• Full‑time

Job Function

• Information Technology and Consulting
• Industries: IT Services and IT Consulting

Referrals increase your chances of interviewing at Lakshya Software Technologies Pvt. Ltd. by 2×.