What are the responsibilities and job description for the Power BI Architect position at VDart, Inc.?
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
Salary : $88 - $110