Tech Lead - Power BI

Patient Solutions Bangalore, Karnataka


About ConcertAI

ConcertAI is the leading provider of precision oncology solutions for biopharma and healthcare, leveraging the largest collection of research-grade Real-world Data and the only broadly deployed oncology-specific AI solutions. Our mission is to improve translational sciences; accelerate therapeutic clinical development; and provide new capabilities for post-approval studies to accelerate needed new medical innovations to patients and to improve patient outcomes. 

ConcertAI has emerged as one of the highest growth technology companies in Real-world Data and AI, backed by industry leading private equity companies: SymphonyAI, Declaration Partners, Maverick Ventures, and Alliance| Bernstein. 


· Utilize Microsoft technology stack, lead solution design and delivery, guide development best practices.

· Visualize data and information for business customers through the creation of reports and queries using Microsoft’s technology stack.

· Create Power BI reports based on business requirements with linked content, drilldowns, and nested parameters.

· Optimize Microsoft Power BI dashboards with a focus on usability, performance, flexibility, testability, and standardization.

· Develop concepts of reports, analytics and visualizations development, using DAX, SQL, tuning, data models and semantic models.

· Performance tune products including, but not limited to, load balancing, caching, etc.

· Create and administer App Workspaces to control permissions and access to Power BI dashboard.

· Ensure reports meet data accuracy, query performance, usability and functionality requirements.

· Collaborate and guide other team members to design and develop end to end process aligning to the defined architecture.

· Continuously improve processes to ensure information delivered is of the highest quality, contributing to the overall effectiveness of the AZURE architecture.

· Resolve all technical issues on production and other environments by working with all stakeholders.

· Create technical and maintenance documentation as needed.

· Familiarity with the Agile development methodology - experience as a member of a Scrum development team.

Experience Level: 8+ years

Skills required:

· 8 or more years programming experience with Microsoft Business Intelligence tools.

· Must have minimum 4 years of BI development using PowerBI, AAS & Azure.

· Should have hands-on experience in developing reports/dashboard using Power BI.

· Should have experience and through understanding of Tabular, Multidimensional model, security, dimensional structures, business intelligence and data warehousing best practices and standards.

· Should be strong in data modeling in Power BI and using SQL to analyze data.

· Should be strong in SQL programming skills with Microsoft SQL Server.

· Solid understanding of master data management, data structures, database concepts, design patterns, concepts of object relationships, version control systems, and data modeling.

· Ability to understand business processes and map them to BI-architectures/applications.

· Ability to simplify use cases and drive them to a smart prototype/POC.

· Excellent analytical, mathematical, and creative problem-solving skills.

· Experience working with business users or end users is required

· Exhibits solid communication skills, both written and verbal.

Learn More About ConcertAI

Our team at ConcertAI is dedicated to transforming healthcare decision-making through the application of RWE and AI to improve patient outcomes. We work in a fast-paced, dynamic, high-performing culture where diversity, collaboration, and innovation are valued. Join us on our quest to create a world free of disease. Learn more about ConcertAI at , or follow us on LinkedIn.