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