Power BI Architect

Overview:

We are seeking a senior-level Power BI Architect to lead the assessment, optimization, and redesign of an existing BI/reporting environment. This is a hands-on architecture delivery leadership role focused on improving the performance, scalability, and usability of enterprise reporting solutions.

This individual will also coordinate with offshore (India) development teams, ensuring high-quality delivery, proper architecture standards, and alignment with business requirements.

Key Responsibilities:

Assess and troubleshoot existing Power BI architecture, reports, and data models
Recommend and implement improvements across performance, scalability, and design
Design and build enterprise-level Power BI solutions (data models, dashboards, reports)
Optimize DAX queries, data models, and report performance
Establish best practices around governance, workspace structure, and deployment
Lead and coordinate offshore development teams (India), including task management, code/report review, and delivery oversight
Collaborate with business stakeholders to align reporting with commercial analytics needs
Support testing, validation, and deployment of reporting solutions

Required Experience:

12 years of experience in BI / reporting design, development, and architecture
Strong hands-on expertise with Power BI (data modeling, DAX, performance tuning)
Proven experience reviewing and fixing/optimizing existing BI environments
Experience working with Life Sciences / Pharma commercial datasets (sales, market access, HCP, etc.)
Experience coordinating and leading offshore development teams
Strong communication and stakeholder management skills
Ability to work onsite in New Jersey 4 days per week

Nice to Have:

Experience in large enterprise/global environments
Exposure to cloud data platforms (Snowflake, Azure, AWS)
Familiarity with data pipelines / ETL tools

What We're Looking For (simple terms):

Someone who can come in, assess a messy Power BI environment, and fix it fast
A hands-on architect who can also lead offshore teams and drive delivery

Submission Notes:

Include candidate's Power BI architecture performance tuning experience
Highlight life sciences/pharma experience clearly
Confirm onsite availability (4 days/week in NJ)
Include communication level offshore coordination experience