Power BI Architect

Job role: Power BI Architect

Duration: 3-month contract (strong potential for extension) – could go 12+ months

Location: Remote onsite as needed in Morristown, NJ

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 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

Nice to Have:

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