Currently Open - Microsoft Power BI Architect

KPI Partners provides strategic guidance and technology systems for clients wishing to enable big data applications for both operations and analytics. We empower businesses with the ability to derive deep insights for fact-based decisions that can increase competitive advantage, create process efficiencies, monetize data, and increase revenue.

KPI is a Microsoft Partner and global provider of consulting, mentoring and training services for Microsoft Data Management, Business Intelligence and Analytics.

Title: Microsoft Power BI Architect

Locations: Hyderabad and Bengaluru (India)

Experience: 8-15 years

Education/Qualification: Bachelor’s degree in Computer Science or related field, or equivalent education and experience


  • 8+ years of relevant consulting or industry experience
  • 5+ years of hands-on development experience with Microsoft Business Intelligence stack
  • Ability to thrive in a fast-paced, dynamic, client-facing role where delivering solid work products to exceed high expectations is a measure of success
  • Excellent leadership and interpersonal skills
  • Eager to contribute in a team-oriented environment
  • Strong prioritization and multi-tasking skills with a track record of meeting deadlines
  • Ability to be creative and analytical in a problem-solving environment
  • Effective verbal and written communication skills
  • Adaptable to new environments, people, technologies and processes
  • Ability to manage ambiguity and solve undefined problems
  • Demonstrates proficiency in the development and administration at least one of the following areas:
    • Back-end data integration and architecture including dimensional data modeling, database design, data warehousing, ETL development, and performance tuning
    • Front-end reporting and analytics platforms including OLAP cube design, tabular data modeling, Performance Point, Power Pivot, Power View, Power BI Report and Dashboard development
  • Extremely strong SQL skills
  • Foundational knowledge of the following areas:
    • Metadata management
    • Master Data Management
    • Data Governance
    • Data Analytics
  • Deep experience in Kimball and Inmon modeling techniques
  • Experience leading or working with Agile development methodology
  • Willing to establish strong work relationships with clients and team members
  • Ability to generate ideas and understand different points of view

Job Summary:

  • Oversee and support the design, development and implementation of data warehousing, reporting and analytics solutions that deliver information efficiently, with the end goal to solve business challenges and achieve business objectives
  • Provide oversight and expertise in Data Modeling and Database Design
  • Architect and develop data models, ETL packages, OLAP cubes, and reports utilizing Power BI applying best practices to the development lifecycle
  • Documentation of source-to-target mappings, data dictionaries, and database design
  • Identify areas of improvement to optimize data flows
  • Installation and Administration of Microsoft SQL Server
  • Lead and mentor junior resources
  • Support business development efforts (proposals and client presentations)
  • Identify opportunities to add value to the client's organization by effective use of information management
  • Build relationships with key stakeholders responsible for information and performance management in client's organization
  • Estimate effort and cost for a Microsoft Business Intelligence solution


  • MS BI Product Suite
  • Power BI
  • MS SQL
  • SSIS
  • SSRS