Power BI Architect

Job Title

• Power BI Architect Location
• Morristown, NJ (Hybrid) Duration
• 3-month contract (strong potential for extension) could go 12+ months.

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